CN103914572A - Database construction system, device and method - Google Patents
Database construction system, device and method Download PDFInfo
- Publication number
- CN103914572A CN103914572A CN201410176940.6A CN201410176940A CN103914572A CN 103914572 A CN103914572 A CN 103914572A CN 201410176940 A CN201410176940 A CN 201410176940A CN 103914572 A CN103914572 A CN 103914572A
- Authority
- CN
- China
- Prior art keywords
- database
- type
- sql statement
- key
- assignmerts
- 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
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/21—Design, administration or maintenance of databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (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 construction system which is run in a compiling system and used for executing compiling and access to a database. The database construction system comprises a receiving unit, a judging unit and a translating unit. The receiving unit is used for receiving a universal initialization SQL statement of a database. The judging unit is used for judging the type of a target database. The translating unit is used for compiling character strings in different languages according to key values of the initialization SQL statement of the database and generating SQL statements executed in the target database according to the initialization SQL statement of the database and the key value character strings. The invention further provides a database construction method and device. By means of the database construction system, device and method, the SQL statements adapting to various types of databases and languages can be generated according to the universal SQL statement for initialization of data of the database, so that the initialization SQL statement is easy to maintain, and the risk that errors are generated in the maintenance process is reduced.
Description
Technical field
The present invention relates to database field, relate in particular to a kind of Database system, apparatus and method.
Background technology
Existing database product is also supported distinctive SQL grammer separately outside the SQL grammer of realizing standard, and these SQL grammers are all uncurrent.For example, statement below supporting in SQL SERVER: SELECT TOP100*FROM t, but under DB2 owing to not supporting TOP key word, so this statement can not must be write as equivalent statement by correct Complied executing: SELECT*FROM t FETCH FIRST100ROWS ONLY.Can find out, realize same function, from table t, select 100 records, in SQL SERVER and DB2, all can realize, but the query statement that mode realizing is submitted to be not identical.Therefore, slip-stick artist need to, according to many SQL statement of different product hand-coding, will bring great inconvenience to exploitation and maintenance like this in the time carrying out Database system development, reduce efficiency of research and development and the risk of makeing mistakes high.
Summary of the invention
Fundamental purpose of the present invention, for a kind of Database system, apparatus and method are provided, is carried out the foundation of dissimilar database based on general SQL statement, thereby improves development and maintenance efficiency under the prerequisite that reduces slip-stick artist's hand-coding statement workload.
The invention provides a kind of Database system, run on compiling and access for performing database in a compiling system, this Database system comprises:
Receiving element, for receiving a general data base initialize SQL statement,
Judging unit, for judging target database type, and
Translation unit, the character string of writing different language according to the key assignments of this data base initialize SQL statement, and be created on according to this data base initialize SQL statement and key assignmerts of character strings the SQL statement of carrying out in this target database.
Further, the present invention also provides a kind of Database device, comprises Database system as above.
Further, the present invention also provides a kind of database building method, and the method comprises:
Receive a general data base initialize SQL statement,
Judge target database type, and
Write the character string of different language according to the key assignments of this data base initialize SQL statement, and generate according to the difference of the SQL grammer of definite target type database the SQL statement that is applicable to respective type database.
A kind of Database system provided by the invention, apparatus and method, a SQL statement for database data initializing universal generates the SQL statement that adapts to all types of databases and language, make initialization SQL statement easy care, reduce the risk of makeing mistakes in maintenance process.
Accompanying drawing explanation
Fig. 1 is the structural representation of the Database system in embodiment of the present invention;
Fig. 2 is the process flow diagram of the database building method in embodiment of the present invention;
Fig. 3 is the process flow diagram of the Derby database building method in embodiment of the present invention;
Fig. 4 is the process flow diagram of the Pgsql database building method in embodiment of the present invention;
Fig. 5 is the process flow diagram of the oracle database method for building up in embodiment of the present invention;
Fig. 6 is the process flow diagram of the sybase database method for building up in embodiment of the present invention.
Label declaration:
Database system 10
Receiving element 11
Judging unit 12
Translation unit 13
Parsing module 131
Judge module 132
Replacement module 133
Embodiment
By describing technology contents of the present invention, structural attitude in detail, being realized object and effect, below in conjunction with embodiment and coordinate accompanying drawing to be explained in detail.
Structured Query Language (SQL) (Structured Query Language) is called for short SQL, and Structured Query Language (SQL) is a kind of data base querying and programming language, for access data and inquiry, renewal and administrative relationships Database Systems; Also be the extension name of database script file simultaneously.
In the prior art, common type of database has Derby, Pgsql, Oracle and Sybase conventionally, below will simply introduce every kind of database.
Derby is a database of writing with java completely, is Open source product, distributes based on Apache License2.0.Derby is very small and exquisite, and core derby.jar only has 2M, so both can use as independent database server, also can be embedded in application program and use.
Pgsql, Object-Relation Database management system, the Database Systems of the state-of-the-art open source code that can obtain in the world, the parallel control of many versions is provided, support nearly all SQL member (to comprise subquery, affairs and user defined type and function), and (exploitation) language binding that can obtain boundless scope (comprises C, C++, Java, perl, tcl, and python), support most of SQL standard and many other Modern Characteristic are provided, for example, complex query external key trigger view transactional integrity, Multi version concurrency control.
Oracle database system is one group of software product take distributed data base as core that ORACLE company of the U.S. (inscriptions on bones or tortoise shells) provides, and is one of database of current most popular client/server (CLIENT/SERVER) or B/S architecture.ORACLE database, as general Database Systems, has complete data management function; As a relational database, it is the product of a complete relation; As distributed data base, it has realized distributed processing power.But its all knowledge, have needed only at a kind of type learning ORACLE knowledge, just can on various types of machines, use it.
Sybase is the database based on client/server architecture, Adoption Network agreement between client and server (as TCP/IP, IPX/SPX) is connected and communication, send request by user end to server, server end response request, and carry out respective service.Owing to having adopted client/server structure, application has been on many machines and has moved, and discloses application programming interfaces DB-LIB, encourages third party to write DB-LIB interface.Because open client DB-LIB allows to use identical calling at different platforms, thereby the application program of accessing DB-LIB is easy to from a platform to another platform transplantation.Meanwhile, Sybase has the high performance characteristics of programmable data storehouse, event driven trigger and multi thread.
In various types of databases, conventionally there will be the function of following several types to form corresponding SQL statement, for example, boolean and comprise Timestamp, Current_timestamp and the timestamp function of Gatdate ().Wherein, the variable storage of boolean data type is the numerical value form of 16 (2 bytes), but can only be True or False.The value of boolean variable is shown as True or False (in using Print), or #TRUE# or #FALSE# (in using Write#).Using key word True and False can be in these two states by boolean variable assignments.In java, boolean value can only be true and false, and can not replace with 0 and 1, and must small letter.
Please refer to Fig. 1, for the structural representation of a kind of Database system in embodiment of the present invention, this Database system 10 is for operating in compiling and the access of the built-in compiling system platform of a device with performing database, and wherein, this compiling system platform can be linux system etc.This Database system 10 comprises receiving element 11, judging unit 12 and translation unit 13.
This receiving element 11 is for receiving a general data base initialize SQL statement (calling KSQL statement in the following text), and this KSQL statement is for generating the SQL statement that is applicable to respective type database according to the difference of the SQL grammer of distinct type data-base.Particularly, this KSQL statement is by slip-stick artist's hand-coding, the present invention supports this KSQL statement proposing on the basis of different SQL grammers at disparate databases, this KSQL statement has the grammer of self, this grammer is the various functions of descriptive data base easily, but it can not directly operate in concrete target database.Therefore, use this general SQL statement can make external application no longer be concerned about moved database environment, improved the dirigibility of application.
This judging unit 12 is for judging target database type.Particularly, this judging unit 12 obtains the database environment information that application system is moved, i.e. target database type, and this database environment information is kept in configuration file, in the time that creation database connects, obtains.Because KSQL statement is to carry out in concrete again database, so before KSQL statement being translated into the SQL statement that is adapted at the execution of specific objective database, must first judge the type of database that it will move, thereby translate into the SQL statement of respective type.
This translation unit 13 is for write the character string of different language according to the key assignments of this KSQL statement, and is created on according to this KSQL statement and key assignmerts of character strings the SQL statement of carrying out in specific objective database.
This translation unit 13 comprises parsing module 131, judge module 132 and replacement module 133.This translation unit 13 generates according to this KSQL statement and key assignmerts of character strings the SQL statement that is applicable to specified database type and language, specifically comprises: this parsing module 131 is for obtaining this KSQL statement and resolving this KSQL statement to obtain key assignmerts of character strings.This judge module 132 is for judging that the field type of resolving the key assignmerts of character strings drawing by this parsing module 131 is constructed fuction or timestamp function.This replacement module 133 is replaced this KSQL statement key assignmerts of character strings value for resolve the type function that draws and target database type language according to this judge module 132 is the character string of associated databases language, and generates the SQL statement of the various language that adapt to this database.
In the present embodiment, in the time that this judge module 132 judges that the field type of the key assignmerts of character strings of this KSQL statement is timestamp function, add the timestamp function representation current time in system that is applicable to target database type.
Below will utilize this KSQL statement to carry out associated databases foundation for Derby of the prior art, Pgsql, Oracle and sybase database be illustrated.
In the time that target database type is Derby database, this parsing module 131 parses this KSQL statement to obtain key assignmerts of character strings, and this judge module 132 judges that the key assignmerts of character strings that this parsing draws is the function of boolean type or the function of timestamp type.In the time that definite this key assignmerts of character strings is the function of boolean type, the value of the variable of this boolean function represents True and represents False with 0 with 1, this judge module 132 judges whether this key assignmerts of character strings is the major key of self-propagation further, if delete the field that this key assignmerts of character strings is corresponding, this key assignmerts of character strings is not processed if not.This replacement module 133 replaces with the value of the key assignmerts of character strings in KSQL statement the character string that is suitable for Derby database, and generates corresponding SQL statement.In the time that this judge module 132 determines that this key assignmerts of character strings is the function of timestamp type, add further current_timestamp function to represent the current time in system.Then, carry out and judge whether this key assignmerts of character strings is the autonomous major key increasing and replacement and the generation that is completed as mentioned above SQL statement by replacement module 133 by this judge module 132.
In the time that target database type is Pgsql database, this parsing module 131 parses this KSQL statement to obtain key assignmerts of character strings, and this judge module 132 judges that the key assignmerts of character strings that this parsing draws is the function of boolean type or the function of timestamp type.In the time that definite this key assignmerts of character strings is the function of boolean type, the value of the variable of this boolean function represents True and represents False with False with True, this replacement module 133 replaces with the value of the key assignmerts of character strings in KSQL statement the character string that is suitable for Pgsql database, and generates corresponding SQL statement.In the time that this judge module 132 determines that this key assignmerts of character strings is the function of timestamp type, add further current_timestamp function to represent the current time in system.Then, completed as mentioned above replacement and the generation of SQL statement by this replacement module 133.
In the time that target database type is oracle database, this parsing module 131 parses this KSQL statement to obtain key assignmerts of character strings, and this judge module 132 judges that the key assignmerts of character strings that this parsing draws is the function of boolean type or the function of timestamp type.In the time that definite this key assignmerts of character strings is the function of boolean type, the value of the variable of this boolean function represents True and represents False with 0 with 1, this replacement module 133 replaces with the value of the key assignmerts of character strings in KSQL statement the character string that is suitable for oracle database, and generates corresponding SQL statement.In the time that this judge module 132 determines that this key assignmerts of character strings is the function of timestamp type, add further sysdate function to represent the current time in system.Then, completed as mentioned above replacement and the generation of SQL statement by this replacement module 133.
In the time that target database type is sybase database, this parsing module 131 parses this KSQL statement to obtain key assignmerts of character strings, and this judge module 132 judges that the key assignmerts of character strings that this parsing draws is the function of boolean type or the function of timestamp type.In the time that definite this key assignmerts of character strings is the function of boolean type, the value of the variable of this boolean function represents True and represents False with 0 with 1, this replacement module 133 replaces with the value of the key assignmerts of character strings in KSQL statement the character string that is suitable for sybase database, and generates corresponding SQL statement.In the time that this judge module 132 determines that this key assignmerts of character strings is the function of timestamp type, add further getdate () function to represent the current time in system.Then, completed as mentioned above replacement and the generation of SQL statement by this replacement module 133.
For example, the KSQL statement of writing that this receiving element 10 receives is:
insert?into?Users(userid,username，enabled)values(1，${users.defaultuser},true)；
Write the character string of the various language that key assignments users.defaultuser is corresponding:
Users.defaultuser=system default root user;
The default root Households of users.defaultuser=Xi System;
users.defaultuser＝Default?user；
This translation unit 13 generates according to this KSQL statement and key assignmerts of character strings the SQL statement that is applicable to specified database type and language, as:
Derby simplified form of Chinese Character: insert into Users (username, enabled) values (' system default root user ', 1);
Derby Chinese-traditional: insert into Users (username, enabled) values (the default Households ' for root of ' Xi System, 1);
Derby English: insert into Users (username, enabled) values (' Default user', 1);
Pgsql simplified form of Chinese Character: insert into Users (username, enabled) values (' system default root user ', true);
Pgsql Chinese-traditional: insert into Users (username, enabled) values (the default Households ' for root of ' Xi System, true);
Pgsql English: insert into Users (username, enabled) values (' Default user', true).
Referring to Fig. 2, is the process flow diagram of database building method of the present invention, and the method comprises:
Step S20, this receiving element 11 receives a general data base initialize SQL statement (calling KSQL statement in the following text).
This KSQL statement is for generating the SQL statement that is applicable to respective type database according to the difference of the SQL grammer of distinct type data-base.
Particularly, this KSQL statement is by slip-stick artist's hand-coding, the present invention supports this KSQL statement proposing on the basis of different SQL grammers at disparate databases, this KSQL statement has the grammer of self, this grammer is the various functions of descriptive data base easily, but it can not directly operate in concrete target database.Therefore, use this general SQL statement can make external application no longer be concerned about moved database environment, improved the dirigibility of application.
Step S21, this judging unit 12 judges target database type.
Particularly, this judging unit 12 obtains the database environment information that application system is moved, i.e. target database type, and this database environment information is kept in configuration file, in the time that creation database connects, obtains.Because KSQL statement is to carry out in concrete again database, so before KSQL statement being translated into the SQL statement that is adapted at the execution of specific objective database, must first judge the type of database that it will move, thereby translate into the SQL statement of respective type.
Step S22, this translation unit 13 is write the character string of different language according to the key assignments of this KSQL statement, and generates according to the difference of the SQL grammer of definite target type database the SQL statement that is applicable to respective type database.
Particularly, this translation unit 13 generates according to this KSQL statement and key assignmerts of character strings the SQL statement that is applicable to specified database type and language, comprising: this parsing module 131 obtains this KSQL statement and resolves this KSQL statement to obtain key assignmerts of character strings.This judge module 132 judges that the field type of resolving the key assignmerts of character strings drawing by this parsing module 131 is constructed fuction or timestamp function.This replacement module 133 is resolved the type function that draws and target database type language according to this judge module 132, and to replace the value of key assignmerts of character strings in this KSQL statement be the character string of associated databases language, and generate the SQL statement of the various language that adapt to this database.
In the present embodiment, in the time that this judge module 132 judges that the field type of the key assignmerts of character strings of this KSQL statement is timestamp function, add the timestamp function representation current time in system that is applicable to target database type.
Referring to Fig. 3, is the process flow diagram of the Derby database building method in embodiment of the present invention, and the method comprises:
Step S30, this parsing module 131 parses this KSQL statement to obtain key assignmerts of character strings.
Step S31, this judge module 132 judges that the key assignmerts of character strings that this parsing draws is the function of boolean type or the function of timestamp type.In the time being defined as the function of boolean type, enter step S32; In the time being defined as the function of timestamp type, enter step S35.
Step S32, this judge module 132 judges whether this key assignmerts of character strings is the major key of self-propagation, if so, enters step S33, otherwise, enter step S34.Wherein, the value of the variable of this boolean function represents True and represents False with 0 with 1.
Step S33, this replacement module 133 is deleted field corresponding to this key assignmerts of character strings.
Step S34, this replacement module 133 replaces with the value of the key assignmerts of character strings in KSQL statement the character string that is suitable for Derby database, and generates corresponding SQL statement.Then, this flow process finishes.
Step S35, this replacement module 133 adds current_timestamp function to represent the current time in system, then, returns to step S32.
Referring to Fig. 4, is the process flow diagram of the Pgsql database building method in embodiment of the present invention, and the method comprises:
Step S40, this parsing module 131 parses this Pgsql statement to obtain key assignmerts of character strings.
Step S41, this judge module 132 judges that the key assignmerts of character strings that this parsing draws is the function of boolean type or the function of timestamp type.In the time being defined as the function of boolean type, enter step S42; In the time being defined as the function of timestamp type, enter step S43.
Step S42, this replacement module 133 replaces with the value of the key assignmerts of character strings in KSQL statement the character string that is suitable for Pgsql database, and generates corresponding SQL statement.Then, this flow process finishes.
Step S43, this replacement module 133 adds current_timestamp function to represent the current time in system, then, returns to step S42.
Fig. 5 is the process flow diagram of the oracle database method for building up in embodiment of the present invention, and the method comprises:
Step S50, this parsing module 131 parses this Oracle statement to obtain key assignmerts of character strings.
Step S51, this judge module 132 judges that the key assignmerts of character strings that this parsing draws is the function of boolean type or the function of timestamp type.In the time being defined as the function of boolean type, enter step S52; In the time being defined as the function of timestamp type, enter step S53.
Step S52, this replacement module 133 replaces with the value of the key assignmerts of character strings in KSQL statement the character string that is suitable for oracle database, and generates corresponding SQL statement.Then, this flow process finishes.
Step S53, this replacement module 133 adds sysdate function to represent the current time in system, then, returns to step S52.
Fig. 6 is the process flow diagram of the sybase database method for building up in embodiment of the present invention, and the method comprises:
Step S60, this parsing module 131 parses this Sybase statement to obtain key assignmerts of character strings.
Step S61, this judge module 132 judges that the key assignmerts of character strings that this parsing draws is the function of boolean type or the function of timestamp type.In the time being defined as the function of boolean type, enter step S62; In the time being defined as the function of timestamp type, enter step S63.
Step S62, this replacement module 133 replaces with the value of the key assignmerts of character strings in KSQL statement the character string that is suitable for sybase database, and generates corresponding SQL statement.Then, this flow process finishes.
Step S63, this replacement module 133 adds getdate () function to represent the current time in system, then, returns to step S62.
A kind of Database system provided by the invention, apparatus and method, a SQL statement for database data initializing universal generates the SQL statement that adapts to all types of databases and language, make initialization SQL statement easy care, reduce the risk of makeing mistakes in maintenance process.
The foregoing is only embodiments of the invention; not thereby limit the scope of the claims of the present invention; every equivalent structure or conversion of equivalent flow process that utilizes instructions of the present invention and accompanying drawing content to do; or be directly or indirectly used in other relevant technical fields, be all in like manner included in scope of patent protection of the present invention.
Claims (11)
1. a Database system, for compiling and the access of performing database, is characterized in that, described Database system comprises:
Receiving element, for receiving a general data base initialize SQL statement;
Judging unit, for judging target database type; And
Translation unit, the character string of writing different language according to the key assignments of described data base initialize SQL statement, and be created on according to described data base initialize SQL statement and key assignmerts of character strings the SQL statement of carrying out in described target database.
2. Database system as claimed in claim 1, is characterized in that, described translation unit comprises:
Parsing module, for obtaining described data base initialize SQL statement and resolving described data base initialize SQL statement to obtain key assignmerts of character strings;
Judge module, for judging that the field type of resolving the key assignmerts of character strings drawing by described parsing module is constructed fuction or timestamp function; And
Replacement module, be the character string of described target database language for resolves the value that the type function that draws and described target database type language replace described data base initialize SQL statement key assignmerts of character strings according to described judge module, and generate the SQL statement of the various language of the described target database of adaptation.
3. Database system as claimed in claim 2, it is characterized in that, in the time that described judge module judges that the field type of the key assignmerts of character strings of described data base initialize SQL statement is timestamp function, add the timestamp function representation current time in system that is applicable to described target database type.
4. Database system as claimed in claim 1, is characterized in that, described target data type comprises Derby, Pgsql, Oracle and Sybase.
5. Database system as claimed in claim 1, it is characterized in that, the database environment information that described judging unit acquisition application system is moved is to judge target database type, and described database environment information is kept in configuration file, in the time that creation database connects, obtains.
6. a Database device, described Database device is for moving the Database system as described in as arbitrary in claim 1-5.
7. a database building method, is characterized in that, described method comprises:
Receive a general data base initialize SQL statement;
Judge target database type; And
Write the character string of different language according to the key assignments of described data base initialize SQL statement, and generate according to the difference of the SQL grammer of definite target type database the SQL statement that is applicable to respective type database.
8. database building method as claimed in claim 7, it is characterized in that, " write the character string of different language according to the key assignments of described data base initialize SQL statement, and generate according to the difference of the SQL grammer of definite target type database the SQL statement that is applicable to respective type database " and comprising:
Obtain described data base initialize SQL statement and resolve described data base initialize SQL statement to obtain key assignmerts of character strings;
Judge that the field type of resolving the key assignmerts of character strings that draws is constructed fuction or timestamp function; And
The value that key assignmerts of character strings in described data base initialize SQL statement replaced in the type function drawing according to parsing and described target database type language is the character string of described target database language, and generates the SQL statement of the various language that adapt to described target database.
9. database building method as claimed in claim 8, it is characterized in that, in the time carrying out " field type that judge key assignmerts of character strings that draws of parsing is constructed fuction or timestamp function " and determine the field type of the key assignmerts of character strings of described data base initialize SQL statement and be timestamp function, also comprise:
Add the timestamp function representation current time in system that is applicable to described target database type.
10. database building method as claimed in claim 7, is characterized in that, described target data type comprises Derby, Pgsql, Oracle and Sybase.
11. database building methods as claimed in claim 7, it is characterized in that, " judge target database type " and comprise or obtain the database environment information that application system is moved, described database environment information is kept in configuration file, in the time that creation database connects, obtains.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410176940.6A CN103914572A (en) | 2014-04-29 | 2014-04-29 | Database construction system, device and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410176940.6A CN103914572A (en) | 2014-04-29 | 2014-04-29 | Database construction system, device and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103914572A true CN103914572A (en) | 2014-07-09 |
Family
ID=51040252
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410176940.6A Pending CN103914572A (en) | 2014-04-29 | 2014-04-29 | Database construction system, device and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103914572A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104731597A (en) * | 2015-03-30 | 2015-06-24 | 上海华力微电子有限公司 | Method for applying SQL statements to engineering software compiling platform |
| CN106355094A (en) * | 2016-07-08 | 2017-01-25 | 耿童童 | SQL (structured query language) injection attack defensive system and defensive method based on grammar transformation |
| CN108197277A (en) * | 2018-01-09 | 2018-06-22 | 福建星瑞格软件有限公司 | A kind of unified data base administration querying method and device |
| CN110046163A (en) * | 2019-04-12 | 2019-07-23 | 网宿科技股份有限公司 | A kind of data retrieval method and system |
| CN110489441A (en) * | 2019-08-12 | 2019-11-22 | 厦门商集网络科技有限责任公司 | A kind of extemporaneous querying method and equipment based on big data |
| CN113239014A (en) * | 2021-05-18 | 2021-08-10 | 安翰科技(武汉)股份有限公司 | Management device and application system for maintaining SQL records |
| CN113391818A (en) * | 2021-03-26 | 2021-09-14 | 广州海量数据库技术有限公司 | Compiled file generation method and device |
| CN114860314A (en) * | 2022-07-06 | 2022-08-05 | 深圳华锐分布式技术股份有限公司 | Deployment upgrading method, device, equipment and medium based on database compatibility |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1388793A2 (en) * | 2002-08-09 | 2004-02-11 | Joint Technology Corporation | Method for transforming SQL queries |
| CN101158975A (en) * | 2007-11-21 | 2008-04-09 | 金蝶软件（中国）有限公司 | Method and system for accessing distinct type data-base |
| CN102073490A (en) * | 2009-11-25 | 2011-05-25 | 阿里巴巴集团控股有限公司 | Method and device for translating database language |
-
2014
- 2014-04-29 CN CN201410176940.6A patent/CN103914572A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1388793A2 (en) * | 2002-08-09 | 2004-02-11 | Joint Technology Corporation | Method for transforming SQL queries |
| CN101158975A (en) * | 2007-11-21 | 2008-04-09 | 金蝶软件（中国）有限公司 | Method and system for accessing distinct type data-base |
| CN102073490A (en) * | 2009-11-25 | 2011-05-25 | 阿里巴巴集团控股有限公司 | Method and device for translating database language |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104731597A (en) * | 2015-03-30 | 2015-06-24 | 上海华力微电子有限公司 | Method for applying SQL statements to engineering software compiling platform |
| CN106355094A (en) * | 2016-07-08 | 2017-01-25 | 耿童童 | SQL (structured query language) injection attack defensive system and defensive method based on grammar transformation |
| CN106355094B (en) * | 2016-07-08 | 2019-02-22 | 北京卫达信息技术有限公司 | A kind of SQL injection attack defending system and defence method based on grammer transformation |
| CN108197277A (en) * | 2018-01-09 | 2018-06-22 | 福建星瑞格软件有限公司 | A kind of unified data base administration querying method and device |
| CN110046163A (en) * | 2019-04-12 | 2019-07-23 | 网宿科技股份有限公司 | A kind of data retrieval method and system |
| CN110489441A (en) * | 2019-08-12 | 2019-11-22 | 厦门商集网络科技有限责任公司 | A kind of extemporaneous querying method and equipment based on big data |
| CN110489441B (en) * | 2019-08-12 | 2022-08-05 | 厦门商集网络科技有限责任公司 | Big data-based ad hoc query method and equipment |
| CN113391818A (en) * | 2021-03-26 | 2021-09-14 | 广州海量数据库技术有限公司 | Compiled file generation method and device |
| CN113239014A (en) * | 2021-05-18 | 2021-08-10 | 安翰科技(武汉)股份有限公司 | Management device and application system for maintaining SQL records |
| CN114860314A (en) * | 2022-07-06 | 2022-08-05 | 深圳华锐分布式技术股份有限公司 | Deployment upgrading method, device, equipment and medium based on database compatibility |
| CN114860314B (en) * | 2022-07-06 | 2022-10-04 | 深圳华锐分布式技术股份有限公司 | Deployment upgrading method, device, equipment and medium based on database compatibility |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103914572A (en) | Database construction system, device and method | |
| CN106934062B (en) | Implementation method and system for querying elastic search | |
| US9058360B2 (en) | Extensible language framework using data cartridges | |
| US8321450B2 (en) | Standardized database connectivity support for an event processing server in an embedded context | |
| US8387076B2 (en) | Standardized database connectivity support for an event processing server | |
| US11681723B1 (en) | Modeling of a non-relational database as a normalized relational database | |
| CN104123374A (en) | Method and device for aggregate query in distributed databases | |
| CN111309760A (en) | Data retrieval method, system, device and storage medium | |
| CN111177788A (en) | Hive dynamic desensitization method and dynamic desensitization system | |
| US10997131B1 (en) | Using a member attribute to perform a database operation on a computing device | |
| US11544326B2 (en) | Maintaining character set compatibility in database systems | |
| US11995075B2 (en) | System and method for efficient transliteration of machine interpretable languages | |
| US11520565B2 (en) | Interpreter for interpreting a data model algorithm and creating a data schema | |
| CN104461531A (en) | Implementing method for self-defined functions of reporting system | |
| CN110941641B (en) | Method for searching data across multiple databases | |
| US10732948B2 (en) | System and method for implementing automated deployment | |
| CN110309214B (en) | Instruction execution method and equipment, storage medium and server thereof | |
| US11693859B2 (en) | Systems and methods for data retrieval from a database indexed by an external search engine | |
| CN110555178B (en) | Data proxy method and device | |
| CN112434037A (en) | Data processing method, processing device, data processing apparatus, and storage medium | |
| US9727350B2 (en) | Localizing computer program code | |
| CN105205060A (en) | Method and device for generating word document database dictionary | |
| CN110737642A (en) | Database information analysis method, database information analysis device, computer device and storage medium | |
| CN114547404B (en) | Big data platform system | |
| AU2018313995B2 (en) | Systems and methods for providing globalization features in a service management application interface |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20140709 |