CN108388588B - Database function offline reading method and system of sql statement automatic generation tool - Google Patents
Database function offline reading method and system of sql statement automatic generation tool Download PDFInfo
- Publication number
- CN108388588B CN108388588B CN201810087060.XA CN201810087060A CN108388588B CN 108388588 B CN108388588 B CN 108388588B CN 201810087060 A CN201810087060 A CN 201810087060A CN 108388588 B CN108388588 B CN 108388588B
- Authority
- CN
- China
- Prior art keywords
- text file
- function
- database
- built
- sql query
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 23
- 238000012986 modification Methods 0.000 claims description 10
- 230000004048 modification Effects 0.000 claims description 10
- 230000002776 aggregation Effects 0.000 claims description 6
- 238000004220 aggregation Methods 0.000 claims description 6
- 238000013523 data management Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a database function offline reading method of an sql statement automatic generation tool, which comprises the steps of obtaining table structure information of a table to be inquired and function information of all supported built-in functions from a database, saving the table structure information into a first text file, and saving the function information into a second text file; modifying the formats of the first text file and the second text file; reading the first text file and the second text file, and storing according to a specified format; and performing data type matching on the stored first text file and the second text file, automatically generating an sql query statement by using a random algorithm, outputting the sql query statement and generating an executable file. The invention has the advantages that: the generation of the sql query statement can be realized by using an automatic sql query statement generation tool under the condition of being separated from the database; meanwhile, the input and the output of an sql query statement automatic generation tool are unified, the method is applicable to most databases, and the compatibility is strong.
Description
Technical Field
The invention relates to the field of databases, in particular to a database function offline reading method and a database function offline reading system for an sql statement automatic generation tool.
Background
Databases (databases) are warehouses that organize, store, and manage data according to data structures that have since sixty years ago, with the development of information technology and markets, particularly after the nineties of the twentieth century, data management has no longer been the only way to store and manage data, and has turned into the various ways of data management that users need.
In recent years, with the development of big data, the types of databases become more and more, the syntax and the usage method of sql are different, and the requirements on functions and performances are higher and higher. The sql query statement automatic generation tool is a tool which is often used when the function and the performance of a database are tested, but the existing database sql query statement automatic generation tool needs to interact with the database, so that the sql query statement automatic generation tool cannot be used if the database is not started or is not provided with a database driver; for different database types, different sql query statement automatic generation tools are required to be used for processing in the prior art, so that compatibility is poor, and unified processing of the tools cannot be realized; in addition, for some function updates of non-open source databases, the existing automatic sql query statement generation tools cannot synchronously update the extended functions, which may cause omission of test cases.
Disclosure of Invention
One of the technical problems to be solved by the invention is to provide a database function offline reading method of an sql statement automatic generation tool, which is used for externally arranging table structure information and function information outside a database in a text file manner, and generating sql query statements by using the sql statement automatic generation tool under the condition of being separated from the database; meanwhile, the input and the output of an sql statement automatic generation tool are unified, the method is applicable to most databases, and the compatibility is strong.
The invention realizes one of the technical problems as follows: the method for reading the database function of the sql statement automatic generation tool offline comprises the following steps:
step S1, obtaining the table structure information of the table to be inquired and the function information of all supported built-in functions from the database, saving the obtained table structure information into a first text file, and saving the obtained function information into a second text file;
step S2, modifying the formats of the first text file and the second text file to make the formats of the first text file and the second text file accord with the input format of the sql query sentence automatic generation tool;
step S3, reading the first text file and the second text file by an sql query sentence automatic generation tool, and storing the first text file and the second text file according to a specified format;
and step S4, the automatic sql query sentence generating tool performs data type matching on the stored first text file and the second text file, automatically generates an sql query sentence by using a random algorithm, outputs the sql query sentence and generates an executable file.
Further, when updating the database built-in function, the step S2 further includes:
and directly modifying or increasing the contents of the first text file and the second text file according to the contents of the updated built-in function of the database.
Further, in step S1, the table structure information of the table to be queried and the function information of all supported built-in functions obtained from the database are specifically:
acquiring the column name of a table to be inquired and the type information of each column in the table from a database, and acquiring the function names, function return value types, the number of parameters contained in the functions and the type information of each parameter of all supported built-in functions from the database; the all supported built-in functions include operators, aggregation functions, OLTP functions, or OLAP functions.
Further, the step S4 is specifically: the method comprises the steps that an sql query statement automatic generation tool obtains a first text file and a second text file which are stored, the type information of each column in the first text file is matched with the function return value type in the second text file and the type information of each parameter contained in a built-in function, the column with the matched type and the built-in function are stored, and the column with the unmatched type and the built-in function are not stored;
and randomly selecting the stored columns and built-in functions by using a random algorithm, automatically generating sql query statements, outputting the sql query statements, and generating an executable file.
The second technical problem to be solved by the invention is to provide a database function offline reading system of an sql statement automatic generation tool, which realizes that table structure information and function information are externally arranged outside a database in a text file form through the same system, and can realize that an sql statement automatic generation tool can be used for generating sql query statements under the condition of being separated from the database; meanwhile, the input and the output of an sql statement automatic generation tool are unified, the method is applicable to most databases, and the compatibility is strong.
The invention realizes the second technical problem in the following way: the system comprises an information reading module, a text modification module, a text reading module and a statement matching output module;
the information reading module is used for acquiring the table structure information of the table to be inquired and the function information of all supported built-in functions from the database, saving the acquired table structure information into a first text file, and saving the acquired function information into a second text file;
the text modification module is used for modifying the formats of the first text file and the second text file so that the formats of the first text file and the second text file accord with the input format of the sql query sentence automatic generation tool;
the text reading module is used for reading the first text file and the second text file by the sql query sentence automatic generation tool and storing the first text file and the second text file according to a specified format;
and the sentence matching output module is used for carrying out data type matching on the stored first text file and the second text file by the automatic sql query sentence generating tool, automatically generating sql query sentences by utilizing a random algorithm, outputting the sql query sentences and generating executable files.
Further, when updating the database built-in function, the text modification module is further configured to:
and directly modifying or increasing the contents of the first text file and the second text file according to the contents of the updated built-in function of the database.
Further, in the information reading module, the table structure information of the table to be queried and the function information of all supported built-in functions obtained from the database are specifically:
acquiring the column name of a table to be inquired and the type information of each column in the table from a database, and acquiring the function names, function return value types, the number of parameters contained in the functions and the type information of each parameter of all supported built-in functions from the database; the all supported built-in functions include operators, aggregation functions, OLTP functions, or OLAP functions.
Further, the statement matching output module specifically includes: the method comprises the steps that an sql query statement automatic generation tool obtains a first text file and a second text file which are stored, the type information of each column in the first text file is matched with the function return value type in the second text file and the type information of each parameter contained in a built-in function, the column with the matched type and the built-in function are stored, and the column with the unmatched type and the built-in function are not stored;
and randomly selecting the stored columns and built-in functions by using a random algorithm, automatically generating sql query statements, outputting the sql query statements, and generating an executable file.
The invention has the following advantages: 1. by adopting the mode of externally arranging the database table structure and the built-in function file outside the database, the sql query statement can be generated by using the automatic sql query statement generation tool under the condition that the database is not provided with a starting drive or a database drive (namely the database is not interacted with the automatic sql query statement generation tool), so that great convenience can be brought to actual use;
2. when the built-in function of the database is updated, only the first text file and the second text file which are externally arranged are needed to be directly modified or added, and the codes in the automatic generation tool of the sql query sentence do not need to be modified, so that not only can the time be saved, but also the expansibility can be enhanced;
3. the input and output formats of the sql query statement automatic generation tool are unified, so that the sql query statement automatic generation tool can meet the use requirements of most databases, and the compatibility is improved.
Drawings
The invention will be further described with reference to the following examples with reference to the accompanying drawings.
FIG. 1 is a schematic block diagram of a database function offline reading method of an sql statement automatic generation tool according to the present invention.
Detailed Description
Referring to fig. 1, a preferred embodiment of the method for offline reading a database function of an sql statement automatic generation tool according to the present invention includes the following steps:
step S1, obtaining the table structure information of the table to be inquired and the function information of all supported built-in functions from the database, saving the obtained table structure information into a first text file, and saving the obtained function information into a second text file;
the step S1 is executed for the purpose of: and externally arranging the table structure information and the function information outside the database in a text file mode, so that the sql query statement can be generated by using an sql query statement automatic generation tool under the condition that the database does not start a driver or the database driver is not installed.
Step S2, modifying the formats of the first text file and the second text file to make the formats of the first text file and the second text file conform to the input format of the sql query sentence automatic generation tool, that is, the first text file and the second text file need to be modified according to the specified format, so that the input and output of the sql query sentence automatic generation tool are unified, which can make the sql query sentence automatic generation tool be suitable for the use requirements of most databases, and improve the compatibility.
Step S3, reading the first text file and the second text file by an sql query sentence automatic generation tool, and storing the first text file and the second text file according to a specified format;
and step S4, the automatic sql query sentence generating tool performs data type matching on the stored first text file and the second text file, automatically generates an sql query sentence by using a random algorithm, outputs the sql query sentence and generates an executable file.
Wherein,
when updating the database built-in function, the step S2 further includes:
and directly modifying or increasing the contents of the first text file and the second text file according to the contents of the updated built-in function of the database. That is to say, when the built-in function of the database is updated, only the external first text file and the external second text file need to be directly modified or added, and the codes in the automatic generation tool of the sql query statement do not need to be modified, so that not only can the time be saved, but also the expansibility can be enhanced.
In step S1, the table structure information of the table to be queried and the function information of all supported built-in functions obtained from the database are specifically:
acquiring the column name of a table to be inquired and the type information of each column in the table from a database, and acquiring the function names, function return value types, the number of parameters contained in the functions and the type information of each parameter of all supported built-in functions from the database; the built-in functions supported include operators (e.g., plus, minus, equal, comma, etc.), aggregation functions (e.g., MAX, MIN, SUM, AVG, etc.), OLTP functions, or OLAP functions.
The step S4 specifically includes: the method comprises the steps that an sql query statement automatic generation tool obtains a first text file and a second text file which are stored, the type information of each column in the first text file is matched with the function return value type in the second text file and the type information of each parameter contained in a built-in function, the column with the matched type and the built-in function are stored, and the column with the unmatched type and the built-in function are not stored; and randomly selecting the stored columns and built-in functions by using a random algorithm, automatically generating sql query statements, outputting the sql query statements, and generating an executable file.
In specific implementation, when the automatic sql query statement generation tool matches the type information of each column in the first text file with the function return value type in the second text file and the type information of each parameter included in the built-in function, the method specifically includes: comparing and matching the type information of each column in the first text file with the type of the function return value in the second text file, and if the types are matched, saving the column and the function return value; if the types do not match, the column and function return values are not saved; comparing and matching the type information of each column in the first text file with the type information of each parameter contained in a built-in function in the second text file, and filling the type information of each column into a parameter table corresponding to the built-in function for storage if the type information of each column is correspondingly matched with the type information of each parameter contained in the built-in function; otherwise, not filling the type information of each column into the parameter table corresponding to the built-in function for storage;
when an sql query statement is generated specifically, the automatic sql query statement generation tool selects the stored columns and built-in functions randomly by using a random algorithm, and generates a first sql query clause with a numerical value comparison (such as <, >, and the like) by returning the columns and the functions with matched types; generating a second sql query clause by using a built-in function filled with column type information in the parameter table; meanwhile, the sql query sentence automatic generation tool packages the first sql query clause and the second sql query clause with other query sentences to automatically generate the sql query sentence.
The invention discloses a preferred embodiment of a database function offline reading system of an sql statement automatic generation tool, which comprises an information reading module, a text modification module, a text reading module and a statement matching output module;
the information reading module is used for acquiring the table structure information of the table to be inquired and the function information of all supported built-in functions from the database, saving the acquired table structure information into a first text file, and saving the acquired function information into a second text file;
the purpose of executing the information reading module is to: and externally arranging the table structure information and the function information outside the database in a text file mode, so that the sql query statement can be generated by using an sql query statement automatic generation tool under the condition that the database does not start a driver or the database driver is not installed.
The text modification module is used for modifying the formats of the first text file and the second text file so that the formats of the first text file and the second text file are consistent with the input format of the sql query sentence automatic generation tool, namely the first text file and the second text file need to be modified according to the specified format, the input and the output of the sql query sentence automatic generation tool are unified, and therefore the sql query sentence automatic generation tool can meet the use requirements of most databases and improve compatibility.
The text reading module is used for reading the first text file and the second text file by the sql query sentence automatic generation tool and storing the first text file and the second text file according to a specified format;
and the sentence matching output module is used for carrying out data type matching on the stored first text file and the second text file by the automatic sql query sentence generating tool, automatically generating sql query sentences by utilizing a random algorithm, outputting the sql query sentences and generating executable files.
Wherein,
when updating the database built-in function, the text modification module is further configured to:
and directly modifying or increasing the contents of the first text file and the second text file according to the contents of the updated built-in function of the database. That is to say, when the built-in function of the database is updated, only the external first text file and the external second text file need to be directly modified or added, and the codes in the automatic generation tool of the sql query statement do not need to be modified, so that not only can the time be saved, but also the expansibility can be enhanced.
In the information reading module, the table structure information of the table to be queried and the function information of all supported built-in functions obtained from the database specifically include:
acquiring the column name of a table to be inquired and the type information of each column in the table from a database, and acquiring the function names, function return value types, the number of parameters contained in the functions and the type information of each parameter of all supported built-in functions from the database; the built-in functions supported include operators (e.g., plus, minus, equal, comma, etc.), aggregation functions (e.g., MAX, MIN, SUM, AVG, etc.), OLTP functions, or OLAP functions.
The statement matching output module is specifically as follows: the method comprises the steps that an sql query statement automatic generation tool obtains a first text file and a second text file which are stored, the type information of each column in the first text file is matched with the function return value type in the second text file and the type information of each parameter contained in a built-in function, the column with the matched type and the built-in function are stored, and the column with the unmatched type and the built-in function are not stored; and randomly selecting the stored columns and built-in functions by using a random algorithm, automatically generating sql query statements, outputting the sql query statements, and generating an executable file.
In specific implementation, when the automatic sql query statement generation tool matches the type information of each column in the first text file with the function return value type in the second text file and the type information of each parameter included in the built-in function, the method specifically includes: comparing and matching the type information of each column in the first text file with the type of the function return value in the second text file, and if the types are matched, saving the column and the function return value; if the types do not match, the column and function return values are not saved; comparing and matching the type information of each column in the first text file with the type information of each parameter contained in a built-in function in the second text file, and filling the type information of each column into a parameter table corresponding to the built-in function for storage if the type information of each column is correspondingly matched with the type information of each parameter contained in the built-in function; otherwise, not filling the type information of each column into the parameter table corresponding to the built-in function for storage;
when an sql query statement is generated specifically, the automatic sql query statement generation tool selects the stored columns and built-in functions randomly by using a random algorithm, and generates a first sql query clause with a numerical value comparison (such as <, >, and the like) by returning the columns and the functions with matched types; generating a second sql query clause by using a built-in function filled with column type information in the parameter table; meanwhile, the sql query sentence automatic generation tool packages the first sql query clause and the second sql query clause with other query sentences to automatically generate the sql query sentence.
In summary, the invention has the following advantages: 1. by adopting the mode of externally arranging the database table structure and the built-in function file outside the database, the sql query statement can be generated by using the automatic sql query statement generation tool under the condition that the database is not provided with a starting drive or a database drive (namely the database is not interacted with the automatic sql query statement generation tool), so that great convenience can be brought to actual use;
2. when the built-in function of the database is updated, only the first text file and the second text file which are externally arranged are needed to be directly modified or added, and the codes in the automatic generation tool of the sql query sentence do not need to be modified, so that not only can the time be saved, but also the expansibility can be enhanced;
3. the input and output formats of the sql query statement automatic generation tool are unified, so that the sql query statement automatic generation tool can meet the use requirements of most databases, and the compatibility is improved.
Although specific embodiments of the invention have been described above, it will be understood by those skilled in the art that the specific embodiments described are illustrative only and are not limiting upon the scope of the invention, and that equivalent modifications and variations can be made by those skilled in the art without departing from the spirit of the invention, which is to be limited only by the appended claims.
Claims (4)
1. A database function off-line reading method of an sql statement automatic generation tool is characterized in that: the method comprises the following steps:
step S1, obtaining the table structure information of the table to be inquired and the function information of all supported built-in functions from the database, saving the obtained table structure information into a first text file, and saving the obtained function information into a second text file;
step S2, modifying the formats of the first text file and the second text file to make the formats of the first text file and the second text file accord with the input format of the sql query sentence automatic generation tool;
step S3, reading the first text file and the second text file by an sql query sentence automatic generation tool, and storing the first text file and the second text file according to a specified format;
step S4, the automatic generation tool of the sql query sentence matches the data type of the stored first text file and the second text file, automatically generates the sql query sentence by using a random algorithm, outputs the sql query sentence and generates an executable file;
in step S1, the table structure information of the table to be queried and the function information of all supported built-in functions obtained from the database are specifically:
acquiring the column name of a table to be inquired and the type information of each column in the table from a database, and acquiring the function names, function return value types, the number of parameters contained in the functions and the type information of each parameter of all supported built-in functions from the database; all supported built-in functions comprise an operator, an aggregation function, an OLTP function or an OLAP function;
the step S4 specifically includes: the method comprises the steps that an sql query statement automatic generation tool obtains a first text file and a second text file which are stored, the type information of each column in the first text file is matched with the function return value type in the second text file and the type information of each parameter contained in a built-in function, the column with the matched type and the built-in function are stored, and the column with the unmatched type and the built-in function are not stored;
and randomly selecting the stored columns and built-in functions by using a random algorithm, automatically generating sql query statements, outputting the sql query statements, and generating an executable file.
2. The offline reading method of the database function of the sql statement automatic generation tool according to claim 1, characterized in that: when updating the database built-in function, the step S2 further includes:
and directly modifying or increasing the contents of the first text file and the second text file according to the contents of the updated built-in function of the database.
3. A database function offline reading system of an sql statement automatic generation tool is characterized in that: the system comprises an information reading module, a text modification module, a text reading module and a statement matching output module;
the information reading module is used for acquiring the table structure information of the table to be inquired and the function information of all supported built-in functions from the database, saving the acquired table structure information into a first text file, and saving the acquired function information into a second text file;
the text modification module is used for modifying the formats of the first text file and the second text file so that the formats of the first text file and the second text file accord with the input format of the sql query sentence automatic generation tool;
the text reading module is used for reading the first text file and the second text file by the sql query sentence automatic generation tool and storing the first text file and the second text file according to a specified format;
the sentence matching output module is used for carrying out data type matching on the stored first text file and the second text file by the automatic sql query sentence generating tool, automatically generating sql query sentences by utilizing a random algorithm, outputting the sql query sentences and generating executable files;
in the information reading module, the table structure information of the table to be queried and the function information of all supported built-in functions obtained from the database specifically include:
acquiring the column name of a table to be inquired and the type information of each column in the table from a database, and acquiring the function names, function return value types, the number of parameters contained in the functions and the type information of each parameter of all supported built-in functions from the database; all supported built-in functions comprise an operator, an aggregation function, an OLTP function or an OLAP function;
the statement matching output module is specifically as follows: the method comprises the steps that an sql query statement automatic generation tool obtains a first text file and a second text file which are stored, the type information of each column in the first text file is matched with the function return value type in the second text file and the type information of each parameter contained in a built-in function, the column with the matched type and the built-in function are stored, and the column with the unmatched type and the built-in function are not stored;
and randomly selecting the stored columns and built-in functions by using a random algorithm, automatically generating sql query statements, outputting the sql query statements, and generating an executable file.
4. The system for off-line reading of database functions of an sql statement automatic generation tool according to claim 3, wherein: when updating the database built-in function, the text modification module is further configured to:
and directly modifying or increasing the contents of the first text file and the second text file according to the contents of the updated built-in function of the database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810087060.XA CN108388588B (en) | 2018-01-30 | 2018-01-30 | Database function offline reading method and system of sql statement automatic generation tool |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810087060.XA CN108388588B (en) | 2018-01-30 | 2018-01-30 | Database function offline reading method and system of sql statement automatic generation tool |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108388588A CN108388588A (en) | 2018-08-10 |
| CN108388588B true CN108388588B (en) | 2021-08-31 |
Family
ID=63074060
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810087060.XA Active CN108388588B (en) | 2018-01-30 | 2018-01-30 | Database function offline reading method and system of sql statement automatic generation tool |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108388588B (en) |
Family Cites Families (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7680862B2 (en) * | 2005-04-18 | 2010-03-16 | Oracle International Corporation | Rewriting table functions as SQL strings |
| CN101105814A (en) * | 2007-09-11 | 2008-01-16 | 金蝶软件（中国）有限公司 | Method and device for converting Script language to SQL language |
| CN101464862A (en) * | 2007-12-21 | 2009-06-24 | 英业达股份有限公司 | SQL generating system and method |
| US20100082646A1 (en) * | 2008-09-26 | 2010-04-01 | Microsoft Corporation | Tracking constraints and dependencies across mapping layers |
| CN102566990B (en) * | 2010-12-09 | 2015-03-11 | 北大方正集团有限公司 | Method and device for performing data manipulation in Java application |
| CN102541521B (en) * | 2010-12-17 | 2015-03-25 | 中国银联股份有限公司 | Automatic operating instruction generating device based on structured query language and method |
| CN104699681A (en) * | 2013-12-04 | 2015-06-10 | 航天信息股份有限公司 | Data processing method based on metadata base |
| CN106055582B (en) * | 2016-05-20 | 2019-09-24 | 中国农业银行股份有限公司 | A kind of method and device of the table name in replacement data library |
| CN107562955A (en) * | 2017-09-30 | 2018-01-09 | 北京酷我科技有限公司 | A kind of rapid generation of SQL statement |
| CN107577816A (en) * | 2017-09-30 | 2018-01-12 | 北京酷我科技有限公司 | A kind of method of entity data bak read-write |
-
2018
- 2018-01-30 CN CN201810087060.XA patent/CN108388588B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN108388588A (en) | 2018-08-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9009140B2 (en) | Optimization of database query | |
| US8666969B2 (en) | Query rewrite for pre-joined tables | |
| US20130311454A1 (en) | Data source analytics | |
| US20190138522A1 (en) | Query translation for searching complex structures of objects | |
| CN104765731A (en) | Database query optimization method and equipment | |
| CN109710220B (en) | Relational database query method, relational database query device, relational database query equipment and storage medium | |
| US10360232B2 (en) | Semantic mapping of data from an entity-relationship model to a graph-based data format to facilitate simplified querying | |
| CN110046170A (en) | Sentence based on multifile management executes method, apparatus, equipment and medium | |
| US20240256613A1 (en) | Data processing method and apparatus, readable storage medium, and electronic device | |
| EP2985691A1 (en) | Tree-based based configuration of a software application | |
| US8156091B2 (en) | Method to retain an inherent and indelible item value in a relational database management system | |
| CN108460092B (en) | Automatic generation method and system for sql query statement containing database built-in function | |
| CN110019306B (en) | SQL statement searching method and system based on XML format file | |
| CN108388588B (en) | Database function offline reading method and system of sql statement automatic generation tool | |
| CN108388589B (en) | Device for automatically generating sql query statement of database | |
| CN108399196B (en) | Automatic sql execution method and system of database sql statement automatic generation tool | |
| CN111125216B (en) | Method and device for importing data into Phoenix | |
| CN113448969B (en) | Data processing method, device and storage medium | |
| US10810196B2 (en) | Materialized view generation | |
| CN112486990B (en) | Method and equipment for describing synchronous database table structure according to model | |
| CN108153916B (en) | Method for realizing automatic generation tool of database sql query statement by using random algorithm | |
| CN113448942B (en) | Database access method, device, equipment and storage medium | |
| CN103116622B (en) | A kind of sequence value generation method for Ibatis scheme and device | |
| CN108334318B (en) | Method for customizing automatic sql statement generation tool by self-defined depth breadth | |
| CN105786928A (en) | Medical system data query method and medical system data query system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: 350000 21 / F, building 5, f District, Fuzhou Software Park, 89 software Avenue, Gulou District, Fuzhou City, Fujian Province Applicant after: FUJIAN SINOREGAL SOFTWARE Co.,Ltd. Address before: Floor 20-21, building 5, area F, Fuzhou Software Park, 89 software Avenue, Gulou District, Fuzhou City, Fujian Province 350000 Applicant before: FUJIAN SINOREGAL SOFTWARE Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |