http://rdf.ncbi.nlm.nih.gov/pubchem/patent/CN-108628975-B
Outgoing Links
| Predicate | Object |
|---|---|
| classificationIPCInventive | http://rdf.ncbi.nlm.nih.gov/pubchem/patentipc/G06F16-2455 http://rdf.ncbi.nlm.nih.gov/pubchem/patentipc/G06F16-2453 http://rdf.ncbi.nlm.nih.gov/pubchem/patentipc/G06F16-242 |
| filingDate | 2018-04-25-04:00^^<http://www.w3.org/2001/XMLSchema#date> |
| grantDate | 2020-08-21-04:00^^<http://www.w3.org/2001/XMLSchema#date> |
| publicationDate | 2020-08-21-04:00^^<http://www.w3.org/2001/XMLSchema#date> |
| publicationNumber | CN-108628975-B |
| titleOfInvention | Database SQL statement optimization method and device |
| abstract | The invention discloses a method and a device for optimizing SQL (structured query language) statements of a database. The method comprises the following steps: acquiring a database SQL statement input by a user; if the query item exists in the database SQL sentence, sequentially judging whether duplication-removing keywords and grouping clauses exist in the database SQL sentence; if the duplicate removal key words and the grouping clauses exist in the database SQL sentences, the grouping items in the database SQL sentences are obtained; if the query item contains all the grouping items in the database SQL statement, judging whether a grouping statistical data clause exists in the database SQL statement; if the data base SQL sentence does not have the grouped statistical data clause, the duplication removing key words in the data base SQL sentence are deleted to generate a new data base SQL sentence, and the new data base SQL sentence is executed. |
| priorityDate | 2018-04-25-04:00^^<http://www.w3.org/2001/XMLSchema#date> |
| type | http://data.epo.org/linked-data/def/patent/Publication |
Incoming Links
| Predicate | Subject |
|---|---|
| isDiscussedBy | http://rdf.ncbi.nlm.nih.gov/pubchem/compound/CID7156993 http://rdf.ncbi.nlm.nih.gov/pubchem/substance/SID426135032 |
Total number of triples: 13.