CN103136263A - Method for automatic generation of structured query language (SQL) sentences - Google Patents
Method for automatic generation of structured query language (SQL) sentences Download PDFInfo
- Publication number
- CN103136263A CN103136263A CN2011103919885A CN201110391988A CN103136263A CN 103136263 A CN103136263 A CN 103136263A CN 2011103919885 A CN2011103919885 A CN 2011103919885A CN 201110391988 A CN201110391988 A CN 201110391988A CN 103136263 A CN103136263 A CN 103136263A
- Authority
- CN
- China
- Prior art keywords
- sql
- generating function
- condition
- instruction
- statement
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Abstract
A method for automatic generation of structured query language (SQL) sentences includes: loading metadata, and generating a form definition category according to the metadata; generating an SQL executive category; defining an executive object of the SQL executive category, wherein the SQL executive object is used for receiving at least one condition parameter which is related to the form definition category; according to the SQL executive object, generating at least one sentence generating function, wherein each sentence generating function corresponds to an SQL instruction; receiving a first code, wherein the first code comprises at least one generating function call instruction, each generating function call instruction corresponds to one sentence generating function and comprises the condition parameter; and according to the at least one condition parameter, mapping the called generating function to the SQL sentences, and replacing the generating function call instruction in the first code with the SQL sentences.
Description
Technical field
The present invention relates to a kind of method of automatic generation SQL statement, particularly a kind of metadata (schema) of utilizing database generates the method for SQL statement automatically.
Background technology
Structured Query Language (SQL) (Structured Query Language, SQL) is the normal data query language for database (database), and the user can directly assign various SQL instructions to database and control database.And when the infosystems such as exploitation FIS or iMES, must be with relevant database basic as system, so operating database is all the technology that adopts SQL basically.If need to code must will be write, and write SQL statement in code according to real-time information dynamic control of data storehouse, database being sent the SQL instruction, and then complete the operation of database.
To write complete SQL statement in code traditionally.In other words, be exactly with the table name in database, field name, data manipulation language (DML) (Data Manipulation Language, DML) statement or write as a constant character string (constant string) as the keyword of restrictive condition, and write extremely in code.Before each performing database operation, just directly carry out the SQL statement in this character string.But adopt such method, for the complicated system such as iMES or FIS, can bring very serious problem for programming.In case when need to increase the operation relevant with the metadata (schema) of database such as field, modification field name, modification table name, modification field type in database, the program maintenance personnel need to hunt out all relevant SQL statement in a large amount of codes, and carry out correspondence and revise.If the title of field and table is quoted, the quoting to become scattered about and much write in dead SQL statement of type or length, every less important Update Table definitional language (Data Definition Language, DDL) will certainly cause very large trouble.
Summary of the invention
In order to address the above problem, the object of the present invention is to provide a kind of method of automatic generation SQL statement, it comprises: load a metadata (schema), and produce a form definition class according to metadata; Produce a SQL and carry out the body class; Definition SQL carries out one of body class and carries out the body object, wherein SQL carry out body to as if in order to receiving at least one condition parameter, and conditional parameter is relevant to the form definition class; Carry out the body object according to SQL, produce at least one statement generating function, the wherein corresponding SQL instruction of each statement generating function; Receive a first code, wherein first code comprises at least one generating function call instruction, the corresponding statement generating function of each generating function call instruction, and the generating function call instruction comprises conditional parameter; And according to conditional parameter, invoked generating function is videoed into a SQL statement, and with the generating function call instruction in SQL statement replacement first code.
The form (table) of form definition class in can a corresponding database wherein, and form can comprise at least one field (field).The form definition class can comprise a field name, a field length, a major key flag and a null value flag of field.And the form definition class also can comprise a custom-attribute.
Conditional parameter can be one equate condition, a blurred equality condition, a range of condition, a greater than condition, a less-than condition, one more than or equal to condition, one less than or equal to condition, fall into set condition, a non-empty condition, a unequal condition, not blurred equality condition, do not fall into the set conditioned disjunction and be or equal condition.
And SQL indication can be a common selection instruction, a condition selection instruction, a common insertion instruction, obtain ID inserts instruction, a common update instruction, a condition update instruction, a common delete instruction, a condition delete instruction, one are commonly blocked instruction, a condition links selection instruction or a condition comprehensively links selection instruction.
In addition, the method that automatically generates SQL statement also can comprise: the SQL statement that generates is deposited in a buffer memory (cache).Relatively, the method that automatically generates SQL statement also can comprise at the rear of step of " reception first code ": search in buffer memory whether the SQL statement that exists corresponding to generating function call instruction and conditional parameter is arranged; And when having corresponding SQL statement in buffer memory, extract SQL statement from buffer memory, and with the generating function call instruction in the SQL statement replacement first code of extracting.
Implement example according to another, the method that automatically generates SQL statement can comprise: program locks to carry out a data access layer (Data Access Layer, DAL); Metadata about load, and produce the form definition class according to metadata; Produce SQL and carry out the body class; Definition SQL carries out the execution body object of body class, wherein SQL carry out body to as if in order to receiving at least one conditional parameter, and conditional parameter is relevant to the form definition class; Carry out a data access layer unlocking program; Carry out the body object according to SQL, produce at least one statement generating function, wherein corresponding SQL instruction of each statement generating function; Receive first code, wherein first code comprises at least one generating function call instruction, the corresponding statement generating function of each generating function call instruction, and the generating function call instruction comprises conditional parameter; And according to conditional parameter, invoked generating function is videoed into SQL statement, and with the generating function call instruction in SQL statement replacement first code.
In sum, the method that automatically generates SQL statement is carried out the dynamic condition of acceptance parameter of body object by SQL, and generates required SQL statement according to generating function call instruction, conditional parameter and form definition class.Therefore when running into the metadata that needs the Update Table storehouse, only need correspondingly to revise the form definition class, and do not need to revise one by one SQL statement all in first code, efficient far beyond traditional way.
Describe the present invention below in conjunction with the drawings and specific embodiments, but not as a limitation of the invention.
Description of drawings
Fig. 1 one implements the process flow diagram of method of the automatic generation SQL statement of example;
Fig. 2 is the process flow diagram of the method for the automatic generation SQL statement of another enforcement example;
Fig. 3 is the process flow diagram of method of the automatic generation SQL statement of another enforcement example.
Embodiment
Below be described in detail detailed features of the present invention and advantage in embodiment, its content is enough to make any those skilled in the art understand technology contents of the present invention and implement according to this, and content disclosed according to this instructions, claim scope and accompanying drawing, any those skilled in the art can understand purpose and the advantage that the present invention is correlated with easily.
The invention provides a kind of automatic generation SQL statement (Structured Query Language (SQL) statement, Structured Query Language sentence) method, it is in order to automatically produce processing at least one SQL statement of a database (database) in code, and can be performed by a processor of a calculator system.
Please refer to Fig. 1, is one to implement the process flow diagram of method of the automatic generation SQL statement of example.At first the metadata (schema) of loading of databases, and produce a form definition class (step S110) according to metadata.It is noted that, below said " class " and " object " refer to " class " and " object " in Object-oriented Programming Design (Object-oriented programming, OOP).The form (table) of form definition class in can correspondence database, and form can comprise at least one field (field).Wherein the form definition class can comprise a field name, a field length, a major key flag and a null value flag of field.The form definition class also can comprise a custom-attribute.
The code of form definition class is exemplified below.
In this example, form has " Family ", " CustoerID ", " Cdt " and " Udt " totally 4 fields, and wherein " Family " is set as major key (Primary Key, PK).
Then produce a SQL and carry out body class (step S120); And definition SQL carries out one of body class and carries out the body object, wherein SQL carry out body to as if in order to receiving at least one condition parameter, and conditional parameter relevant to the form definition class (step S130).
The code that SQL carries out the body class is exemplified below.
Carry out the body object according to SQL, produce at least one statement generating function, the wherein corresponding SQL instruction (step S140) of each statement generating function.for example, the SQL instruction can be a common selection instruction (common select), one condition selection instruction (conditioned select), one common insertion instruction (common insert), one obtains ID inserts instruction (acquire ID insert), one common update instruction (common update), one condition update instruction (conditioned update) common delete instruction (common delete), one condition delete instruction (conditioned delete), one commonly blocks instruction (common truncate), one condition links selection instruction (conditioned joined select) or a condition comprehensively links selection instruction (conditioned comprehensive joined select).
Code corresponding to the statement generating function of condition selection instruction is exemplified below.
The condition selection instruction be for " SELECT ... FROM ... WHERE ... " form.In this statement generating function, first define SQL and carry out body object ret, and the form of condition selection instruction is write in character string ret.Sentence, then prepare with ret condition of acceptance selection instruction " SELECT ... FROM ... WHERE ... " in required conditional parameter.
Automatically the method that generates SQL statement can utilize SQL definition body object to produce the statement generating function of corresponding above-mentioned various different SQL instructions, therefore can give the program maintenance personnel and support greatly.
Above step S110 can be considered the work of preposition preparation to S140, then step S150 and S160 just can utilize the form definition class and the statement generating function that have generated automatically dynamically to generate SQL statement.Automatically the method reception that generates SQL statement need to be with a first code of SQL statement, wherein first code comprises at least one generating function call instruction, the corresponding statement generating function of each generating function call instruction, the generating function call instruction comprises conditional parameter (step S150).According to conditional parameter, invoked generating function is videoed into SQL statement, and with the generating function call instruction (step S160) in SQL statement replacement first code.
In other words, the program maintenance personnel write the generating function call instruction in first code, to call and to carry out corresponding statement generating function.Various conditional parameter also can import corresponding statement generating function into by the generating function call instruction according to the demand of code.and conditional parameter can be for example an equal condition (equal), one blurred equality condition (like), one range of condition (between), one greater than condition (greater), one less-than condition (smaller), one more than or equal to condition (greater or equal), one less than or equal to condition (smaller or equal), one falls into set condition (in), one non-empty condition (not null), one unequal condition (not equal), one blurred equality condition (not like) not, one does not fall into set condition (not in) or an empty or equal condition (null or equal).
For example, if call the statement generating function corresponding to the condition selection instruction, and when conditional parameter is the equal condition relevant to " Family " field, may automatically obtain the SQL statement of " SELECT Family; CustomerID; Cdt, Udt FROM Family WHERE Family=@Family ".And this SQL statement just can replace the generating function call instruction in first code and be actually carried out.
When the update routine maintainer need to revise metadata to increase field, revise field name, revise table name, when revising the operation such as field type, only to need in change form definition class just can to reach easily for the definition of section separately.Because SQL statement is automatically to generate, so first code can generate new, suitable SQL statement according to the form definition class of upgrading when carrying out automatically, and carries out new SQL statement and come access database.
Please refer to Fig. 2, it is the process flow diagram of the method for the automatic generation SQL statement of another enforcement example.
Compared to directly writing dead SQL statement in code, the SQL statement that automatically generates needs the rise time really.Although shine upon and to generate time of single the required cost of SQL statement very little, if used a large amount of generating function call instructions in first code, system still needs spended time to process.In the embodiment of Fig. 2 in order to solve this problem, the SQL statement that just will generate be kept at a buffer memory (cache) in.
After step S160, the method for the SQL statement that automatically generates deposits the SQL statement that generates in buffer memory (step S162) in addition.Relatively, before system regeneration becomes SQL statement, can whether the SQL statement (step S152) that exist corresponding to generating function call instruction and conditional parameter be arranged prior to searching in buffer memory, and judge whether there is corresponding SQL statement (step S154) in buffer memory.When having had the SQL statement that generates with identical statement generating function and identical conditional parameter in buffer memory, just can directly extract SQL statement from buffer memory, and replace generating function call instruction (step S164) in first code with the SQL statement of extracting, generate time and the computing of SQL statement and save to repeat to video.
In addition, except the SQL statement that generates, also can with used conditional parameter or even SQL with possess carry out after the result of acquisition all be temporarily stored in buffer memory, do not limit at this.
Please refer to Fig. 3, it is the process flow diagram of method of the automatic generation SQL statement of another enforcement example.
Generating in the statement generating function may be affected by other function when SQL carries out the body object, particularly when relevant data are placed in buffer memory, more can form a critical section that be protected.In order to protect the critical section, can carry out an executing data access layer (Data Access Layer, the DAL) program that locks (step S100) before step S110; And carry out a DAL unlocking program (step S132) after step S100.Because the statement generating function may relate to critical section or form definition class, be not therefore to carry out the program that locks in the statement generating function when step S100, but directly lock and unlocking program at DAL.And lock and unlocking program can utilize the existing call method of DAL to carry out, very easy.
In sum, the method that automatically generates SQL statement can generate required SQL statement according to generating function call instruction, conditional parameter and form definition class in real time, therefore has elasticity far beyond the way of directly writing traditionally SQL statement in code.In addition, the method that automatically generates SQL statement can be utilized buffer memory to improve and rise into the efficient of SQL statement, and can utilize DAL to lock/critical section during the execution of unlocking program protecting code.
Certainly; the present invention also can have other various embodiments; in the situation that do not deviate from spirit of the present invention and essence thereof; those of ordinary skill in the art work as can make according to the present invention various corresponding changes and distortion, but these corresponding changes and distortion all should belong to the protection domain of the appended claim of the present invention.
Claims (9)
1. a method that automatically generates SQL statement, is characterized in that, comprising:
Metadata about load, and produce the form definition class according to this metadata;
Produce SQL and carry out the body class;
Define the execution body object that this SQL carries out the body class, wherein this SQL carry out body to as if in order to receiving conditional parameter at least, and this conditional parameter is relevant to this form definition class;
Carry out the body object according to this SQL, produce statement generating function at least, the wherein corresponding SQL instruction of each this statement generating function;
Receive first code, wherein this first code comprises at least one generating function call instruction, corresponding this statement generating function of each this generating function call instruction, and this generating function call instruction comprises this conditional parameter; And
According to this conditional parameter, invoked this generating function is videoed into SQL statement, and replace this generating function call instruction in this first code with this SQL statement.
2. the method for automatic generation SQL statement as claimed in claim 1, is characterized in that, the form in this form definition class correspondence database, and this form comprises at least one field.
3. the method for automatic generation SQL statement as claimed in claim 2, is characterized in that, this form definition class comprises field name, field length, major key flag and the null value flag of this field.
4. the method for automatic generation SQL statement as claimed in claim 3, is characterized in that, this form definition class also comprises custom-attribute.
5. the method for automatic generation SQL statement as claimed in claim 1, it is characterized in that, this conditional parameter for equate condition, blurred equality condition, range of condition, greater than condition, less-than condition, more than or equal to condition, less than or equal to condition, fall into set condition, non-empty condition, unequal condition, not the blurred equality condition, not fall into the set conditioned disjunction be empty or equal condition.
6. the method for automatic generation SQL statement as claimed in claim 1, it is characterized in that, this SQL is designated as common selection instruction, condition selection instruction, common insertion instruction, obtain that ID inserts instruction, common update instruction, condition update instruction, common delete instruction, condition delete instruction, commonly blocks instruction, a condition links selection instruction or a condition comprehensively links selection instruction.
7. the method for automatic generation SQL statement as claimed in claim 1, is characterized in that, also comprises:
This SQL statement that generates is deposited in buffer memory.
8. the method for automatic generation SQL statement as claimed in claim 7, is characterized in that, after this receives the step of this first code, also comprises:
Search this SQL statement that whether exists corresponding to this generating function call instruction and this conditional parameter in this buffer memory; And
When having this corresponding SQL statement in this buffer memory, extract this SQL statement from this buffer memory, and replace this generating function call instruction in this first code with this SQL statement of extracting.
9. a method that automatically generates SQL statement, is characterized in that, comprising:
The executing data access layer locks;
Metadata about load, and produce the form definition class according to this outline;
Produce SQL and carry out the body class;
Define the execution body object that this SQL carries out the body class, wherein this SQL carry out body to as if in order to receiving at least one condition parameter, and this conditional parameter is relevant to this form definition class;
The release of executing data access layer;
Carry out the body object according to this SQL, produce at least one statement generating function, the wherein corresponding SQL instruction of each this statement generating function;
Receive first code, wherein this first code comprises at least one generating function call instruction, corresponding this statement generating function of each this generating function call instruction, and this generating function call instruction comprises this conditional parameter; And
According to this conditional parameter, invoked this generating function is videoed into SQL statement, and replace this generating function call instruction in this first code with this SQL statement.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011103919885A CN103136263A (en) | 2011-11-23 | 2011-11-23 | Method for automatic generation of structured query language (SQL) sentences |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011103919885A CN103136263A (en) | 2011-11-23 | 2011-11-23 | Method for automatic generation of structured query language (SQL) sentences |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103136263A true CN103136263A (en) | 2013-06-05 |
Family
ID=48496095
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011103919885A Pending CN103136263A (en) | 2011-11-23 | 2011-11-23 | Method for automatic generation of structured query language (SQL) sentences |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103136263A (en) |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104731863A (en) * | 2015-02-13 | 2015-06-24 | 杭州米加科技有限公司 | Method for simplifying PostgreSQL division codes |
| CN105159974A (en) * | 2015-08-27 | 2015-12-16 | 浪潮软件股份有限公司 | Method for automatically generating cross-data-source web service |
| CN105893031A (en) * | 2016-03-28 | 2016-08-24 | 广州华多网络科技有限公司 | Cache operation implementation method, calling method of business layer method and device |
| CN107168700A (en) * | 2017-04-30 | 2017-09-15 | 王栋 | Foundational development framework based on the SQL SELECT full-automatic list WEB background management systems driven |
| CN107679056A (en) * | 2017-06-25 | 2018-02-09 | 平安科技（深圳）有限公司 | Generate method, electronic installation and the readable storage medium storing program for executing of SQL statement |
| CN107832387A (en) * | 2017-10-31 | 2018-03-23 | 北京酷我科技有限公司 | A kind of SQL statement analytic method based on FMDB |
| CN107832055A (en) * | 2017-12-11 | 2018-03-23 | 安徽科大国创云网科技有限公司 | A kind of MQL language translations are the method for sql like language |
| CN108388589A (en) * | 2018-01-30 | 2018-08-10 | 福建星瑞格软件有限公司 | A kind of device that database sql query statements automatically generate |
| CN108460092A (en) * | 2018-01-30 | 2018-08-28 | 福建星瑞格软件有限公司 | Include the sql query statements automatic generation method and system of database built-in function |
| CN108804480A (en) * | 2017-05-05 | 2018-11-13 | 天津中铁电气化设计研究院有限公司 | A kind of analyzing platform and design method of novel dynamic generation data operation commands |
| CN108959631A (en) * | 2018-07-24 | 2018-12-07 | 北京百度网讯科技有限公司 | Method and apparatus for query information |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101770469A (en) * | 2008-12-31 | 2010-07-07 | 中国银联股份有限公司 | Page based data query method and system thereof |
| CN102073642A (en) * | 2009-11-23 | 2011-05-25 | 英业达集团(天津)电子技术有限公司 | Method for automatically generating SQL statements and electronic device thereof |
-
2011
- 2011-11-23 CN CN2011103919885A patent/CN103136263A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101770469A (en) * | 2008-12-31 | 2010-07-07 | 中国银联股份有限公司 | Page based data query method and system thereof |
| CN102073642A (en) * | 2009-11-23 | 2011-05-25 | 英业达集团(天津)电子技术有限公司 | Method for automatically generating SQL statements and electronic device thereof |
Non-Patent Citations (2)
| Title |
|---|
| 韩冰: "SQL语句的自动生成", 《甘肃科技》 * |
| 韩冰: "SQL语句的自动生成", 《甘肃科技》, vol. 22, no. 2, 28 February 2006 (2006-02-28) * |
Cited By (19)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104731863B (en) * | 2015-02-13 | 2017-10-13 | 杭州米加科技有限公司 | Simplify the method for PostgreSQL division codes |
| CN104731863A (en) * | 2015-02-13 | 2015-06-24 | 杭州米加科技有限公司 | Method for simplifying PostgreSQL division codes |
| CN105159974A (en) * | 2015-08-27 | 2015-12-16 | 浪潮软件股份有限公司 | Method for automatically generating cross-data-source web service |
| CN105893031B (en) * | 2016-03-28 | 2019-12-24 | 广州华多网络科技有限公司 | Cache operation implementation method, service layer method calling method and device |
| CN105893031A (en) * | 2016-03-28 | 2016-08-24 | 广州华多网络科技有限公司 | Cache operation implementation method, calling method of business layer method and device |
| CN107168700A (en) * | 2017-04-30 | 2017-09-15 | 王栋 | Foundational development framework based on the SQL SELECT full-automatic list WEB background management systems driven |
| CN107168700B (en) * | 2017-04-30 | 2020-06-30 | 王栋 | Basic development framework of full-automatic form WEB background management system based on SQL-SELECT drive |
| CN108804480A (en) * | 2017-05-05 | 2018-11-13 | 天津中铁电气化设计研究院有限公司 | A kind of analyzing platform and design method of novel dynamic generation data operation commands |
| CN107679056A (en) * | 2017-06-25 | 2018-02-09 | 平安科技（深圳）有限公司 | Generate method, electronic installation and the readable storage medium storing program for executing of SQL statement |
| CN107679056B (en) * | 2017-06-25 | 2021-03-02 | 平安科技（深圳）有限公司 | Method for generating SQL (structured query language) statement, electronic device and readable storage medium |
| CN107832387A (en) * | 2017-10-31 | 2018-03-23 | 北京酷我科技有限公司 | A kind of SQL statement analytic method based on FMDB |
| CN107832387B (en) * | 2017-10-31 | 2021-07-13 | 北京酷我科技有限公司 | SQL statement analysis method based on FMDB |
| CN107832055A (en) * | 2017-12-11 | 2018-03-23 | 安徽科大国创云网科技有限公司 | A kind of MQL language translations are the method for sql like language |
| CN108388589A (en) * | 2018-01-30 | 2018-08-10 | 福建星瑞格软件有限公司 | A kind of device that database sql query statements automatically generate |
| CN108460092A (en) * | 2018-01-30 | 2018-08-28 | 福建星瑞格软件有限公司 | Include the sql query statements automatic generation method and system of database built-in function |
| CN108388589B (en) * | 2018-01-30 | 2022-09-16 | 福建星瑞格软件有限公司 | Device for automatically generating sql query statement of database |
| CN108460092B (en) * | 2018-01-30 | 2022-09-16 | 福建星瑞格软件有限公司 | Automatic generation method and system for sql query statement containing database built-in function |
| CN108959631A (en) * | 2018-07-24 | 2018-12-07 | 北京百度网讯科技有限公司 | Method and apparatus for query information |
| CN108959631B (en) * | 2018-07-24 | 2022-07-15 | 北京百度网讯科技有限公司 | Method and device for querying information |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103136263A (en) | Method for automatic generation of structured query language (SQL) sentences | |
| Leis et al. | The ART of practical synchronization | |
| US10659467B1 (en) | Distributed storage and distributed processing query statement reconstruction in accordance with a policy | |
| Demers et al. | Cayuga: A General Purpose Event Monitoring System. | |
| US9292567B2 (en) | Bulk matching with update | |
| US6240418B1 (en) | Database apparatus | |
| CN107038222B (en) | Database cache implementation method and system | |
| EP3594821B1 (en) | Managing data profiling operations related to data type | |
| US20140229424A1 (en) | Systems and methods for improving database performance | |
| US20090177622A1 (en) | Method and system for speeding up rebuild of user-defined indexes during partition maintenance operations in the database systems | |
| US8073843B2 (en) | Mechanism for deferred rewrite of multiple XPath evaluations over binary XML | |
| JP2007526564A (en) | Time-addressed database management system | |
| US20070078909A1 (en) | Database System | |
| EP3365812A1 (en) | Create table for exchange | |
| US20100235344A1 (en) | Mechanism for utilizing partitioning pruning techniques for xml indexes | |
| CN104462351A (en) | Data query model and method for MapReduce pattern | |
| Durner et al. | Crystal: a unified cache storage system for analytical databases | |
| CN102262636B (en) | Method and device for generating database partition execution plan | |
| US7752181B2 (en) | System and method for performing a data uniqueness check in a sorted data set | |
| CN112000845B (en) | Hyperspatial hash indexing method based on GPU acceleration | |
| US9135302B2 (en) | Query rewrite with a nested materialized view | |
| US7392359B2 (en) | Non-blocking distinct grouping of database entries with overflow | |
| CN114637752A (en) | Connection query statement processing method, device, equipment and storage medium | |
| KR20130047431A (en) | Method for storaging in memory and pararell-processing for batch process of mass information | |
| US20170031982A1 (en) | Maintaining Performance in the Presence of Insertions, Deletions, and Streaming Queries |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20130605 |