http://rdf.ncbi.nlm.nih.gov/pubchem/patent/CN-108304505-B
Outgoing Links
Predicate | Object |
---|---|
classificationCPCInventive | http://rdf.ncbi.nlm.nih.gov/pubchem/patentcpc/G06F16-2433 |
classificationIPCInventive | http://rdf.ncbi.nlm.nih.gov/pubchem/patentipc/G06F16-242 |
filingDate | 2018-01-18-04:00^^<http://www.w3.org/2001/XMLSchema#date> |
grantDate | 2020-09-11-04:00^^<http://www.w3.org/2001/XMLSchema#date> |
publicationDate | 2020-09-11-04:00^^<http://www.w3.org/2001/XMLSchema#date> |
publicationNumber | CN-108304505-B |
titleOfInvention | SQL statement processing method and device, server and storage medium |
abstract | The embodiment of the invention discloses a method and a device for processing SQL statements, a server and a storage medium. The method comprises the following steps: judging whether the SQL statement meets a preset optimization condition; if the preset optimization condition is met, deleting the grouping clauses in the SQL statement; and if the query item or the sequencing item in the SQL statement has an aggregation function, equivalently rewriting the aggregation function in the SQL statement into a constant or a column. According to the technical scheme provided by the embodiment of the invention, the SQL sentence meeting the preset optimization condition is deleted from the grouping clauses, and the aggregation function in the sentence is equivalently rewritten, so that the existing complex process of calculating the grouping can be skipped, the grouping effect is achieved, and the overall operation efficiency is improved. |
priorityDate | 2018-01-18-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: 12.