CN102156740A - SQL (structured query language) statement processing method and system - Google Patents
SQL (structured query language) statement processing method and system Download PDFInfo
- Publication number
- CN102156740A CN102156740A CN 201110094710 CN201110094710A CN102156740A CN 102156740 A CN102156740 A CN 102156740A CN 201110094710 CN201110094710 CN 201110094710 CN 201110094710 A CN201110094710 A CN 201110094710A CN 102156740 A CN102156740 A CN 102156740A
- Authority
- CN
- China
- Prior art keywords
- database
- sql statement
- database manipulation
- sql
- type
- 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.)
- Granted
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses an SQL (structured query language) statement processing method and system. The method comprises the following steps: an SQL statement is resolved into a database operation abstract which is an ordered set of predicate-object pairs composed of database operation types and database objects, wherein each database operation type indicates one database operation mode; and each database object indicates one entity in the database. By using the method, the understanding of the SQL statement can be better indicated by the combination of the database operations and operation objects extracted from the SQL statement, namely the ordered predicate-object pairs; the authority significance of the database operation can be indicated in a concise mode; and the indication of the structured SQL statement is provided.
Description
Technical field
The present invention relates to database technology, relate in particular to a kind of disposal route and system of SQL statement.
Background technology
(products of for example a lot of existing databases audits) all are that the objects such as table name of action type, SQL statement by extracting SQL statement are realized the understanding to SQL statement in the prior art.But there is following defective in above-mentioned technology: the first, relative isolated between the operation of SQL statement and the operand; The second, can't well oppositely mate SQL statement; Three, out-of-order meaning and action value; Four, can't be under clear, the prerequisite of simplifying the abundant primitive meaning of statement SQL statement.
Summary of the invention
In order to overcome the deficiencies in the prior art, the invention provides a kind of disposal route and system of SQL statement, based on the present invention, can better express understanding to SQL statement.
On the one hand, the invention discloses a kind of disposal route of SQL statement, described method comprises: analyzing step, SQL statement is resolved to the database manipulation summary, and described database manipulation summary is that database manipulation type and database object are formed the right ordered set of meaning guest; Wherein, described database manipulation type list shows the mode of database manipulation; Described database object table is shown an entity in the database.
The disposal route of above-mentioned SQL statement, preferred described analyzing step is: make up the SQL syntax tree, by lexical analysis, extract action type and database object, it is right to form the meaning guest, according to the rank order of carrying out.
The disposal route of above-mentioned SQL statement, preferred described analyzing step is: resolve and grammatical analysis by morphology, carry out character string scanning, obtain the key word of database manipulation type, with described key word as the database manipulation type, speech section by extracting the character string back is as the database object part, with after database manipulation type and the pairing of database object coupling, presses execution sequence and sorts.
The disposal route of above-mentioned SQL statement, preferred described analyzing step is:, described analyzing step is: determine to extract the information source of database SQL statement operation, based on context, SQL statement is resolved to described database manipulation type and database object.
On the other hand, the invention also discloses a kind of disposal system of SQL statement, comprise parsing module, be used for SQL statement is resolved to the database manipulation summary that described database manipulation summary is that database manipulation type and database object are formed the right ordered set of meaning guest; Wherein, described database manipulation type list shows the mode of database manipulation; Described database object table is shown an entity in the database.
The disposal system of above-mentioned SQL statement, preferred described parsing module is used for: make up the SQL syntax tree, resolve and grammatical analysis by morphology, extract action type and database object, it is right to form the meaning guest, according to the rank order of carrying out.
The disposal system of above-mentioned SQL statement, preferred described parsing module is used for: carry out character string scanning, obtain the key word of database manipulation type, with described key word as the database manipulation type, speech section by extracting the character string back is as the database object part, after database manipulation type and the pairing of database object coupling, press the execution sequence ordering.
The disposal system of above-mentioned SQL statement, preferred described parsing module is: determine to extract the information source of database SQL statement operation, based on context, SQL statement is resolved to described database manipulation type and database object.
In terms of existing technologies, the present invention has following advantage:
The first, extract the combination of database manipulation and operand from SQL statement, promptly orderly meaning guest is right, can better express the understanding to SQL statement; Simultaneously, express database manipulation authority meaning in succinct mode; And, a kind of expression of structurized SQL statement is provided.
The second, the database summary of extraction of the present invention can effectively be used to learn user right, the magnanimity SQL statement is carried out that merger is handled and to SQL statement field such as classify.
Description of drawings
Fig. 1 is the flow chart of steps of the disposal route embodiment of SQL statement of the present invention;
Fig. 2 is the flow chart of steps of another embodiment of disposal route of SQL statement of the present invention;
Fig. 3 is the flow chart of steps of another embodiment of disposal route of SQL statement of the present invention;
Fig. 4 is the structured flowchart of another embodiment of disposal system of SQL statement of the present invention;
Fig. 5 is the structured flowchart of another embodiment of disposal system of SQL statement of the present invention;
Fig. 6 is the structured flowchart of the disposal system embodiment of SQL statement of the present invention.
Embodiment
For above-mentioned purpose of the present invention, feature and advantage can be become apparent more, the present invention is further detailed explanation below in conjunction with the drawings and specific embodiments.
The disposal route embodiment of SQL statement
Embodiment one
With reference to Fig. 1, Fig. 1 comprises the steps: step S110 for the flow chart of steps of the disposal route embodiment of SQL statement of the present invention, makes up the SQL syntax tree; Step S120 by lexical analysis, extracts action type and database object, and it is right that each action type and database object are formed a meaning guest; Step S130, according to the order of carrying out to a plurality of meaning guests to sorting; Step S140 based on described database manipulation summary, comprises the study of user right and the magnanimity SQL statement is carried out the operation that merger is handled.
Below above-mentioned each step is further detailed.
In step S130, the order of execution is meant that SQL statement is by the order of the execution of the instruction after compiling in database.With reference to following Example ordering is understood.
The execution sequence of SELECT*FROM TABLE1 UNION SELECT * FROM TABLE2 is:
SELECT*FROM?TABLE1
SELECT*FROM?TABLE2
Below, illustrate in step S140, based on database manipulation summary study user right.
For example, through the statistics that the SQL to certain user in the Database Systems makes a summary, can draw the data of following form:
| update | delete | insert | select | |
| usertable | 2 | 0 | 2 | 45 |
| Table1 | 5 | 0 | 0 | 50 |
| Table2 | 6 | 0 | 0 | 60 |
| Table3 | 0 | 0 | 0 | 40 |
| Table4 | 6 | 3 | 0 | 34 |
If default set the rule of following authority (can visit in which way what table) at this user:
| update | delete | insert | select | |
| usertable | ○ | × | × | ○ |
| Table1 | ○ | × | × | ○ |
| Table2 | ○ | × | × | ○ |
| Table3 | × | × | × | ○ |
| Table4 | ○ | ○ | × | ○ |
So at SQL statement
INSERT?INTO?USERTABLE(NAME，AGE)?VALUES(“zhangsan”，24)
INSERT?INTO?USERTABLE(NAME，AGE)VALUES(“lisi”，23)
System can find that producing alarm in violation of rules and regulations does further processing.
That is to say that the effect of database manipulation summary is: (1) makes being structured into of SQL statement is possible, and the structure of having only generation to be similar to the database manipulation summary could generate relevant statistics.(2) structure of having only generation to be similar to the database manipulation summary could be judged the judgement at the authority of " can visit what table in which way ".
Below, illustrate in step S140, based on the database manipulation summary magnanimity SQL statement is carried out merger and handle.
What often face at the register system of the daily record of database manipulation is mass data, and the user often only is concerned about the mode of operation of database user and the object of operation, a plurality of thus database manipulations can corresponding a plurality of database manipulations, can alleviate the pressure of storage and retrieval.
Database manipulation for example
Sclcct?password?from?uscrtablc?Whcrc?uscrnamc-‘zhangsan’
Sclcct?password?from?uscrtablc?Whcrc?uscrnamc＝‘lisi’
Sclcct?password?from?uscrtablc?Whcrc?uscrnamc＝‘wangcrmazi’
Can correspond to:
SELECT?USERTABLE
SQL statement is classified.
Database manipulation
Sclcct?password?from?uscrtablc?Whcrc?uscmamc-‘zhangsan’
Sclcct?password?from?uscrtablc?Whcrc?uscmamc-？
Can correspond to the database manipulation summary: SELECT USERTABLE system can distribute unique ID to this database manipulation summary, and it is designated the classification of " user profile " and so on, embody professional meaning, for the further mining analysis to data lays the first stone.
Need to prove that core of the present invention is to obtain the database manipulation summary, after obtaining this summary, how to carry out the operation of follow-up data based on this database manipulation summary, is not core of the present invention.This embodiment listed, based on database manipulation summary the magnanimity SQL statement is carried out the study of merger processing or user right, only be exemplary, the database manipulation summary can also be applied in other occasions, the present invention does not limit at this.
Embodiment two
With reference to Fig. 2, Fig. 2 is the flow chart of steps of another embodiment of disposal route of SQL statement of the present invention, comprising: step S210, resolve and grammatical analysis by morphology, and carry out character string scanning; Step S220 obtains the key word of database manipulation type, with described key word as the database manipulation type; Step S230, the speech section of extracting the character string back is as database object; Step S240 after database manipulation type and the pairing of database object coupling, sorts by execution sequence.Step S250 based on described database manipulation summary, comprises the study of user right and the magnanimity SQL statement is carried out the operation that merger is handled.Certainly, being not limited to aforesaid operations, can also be other data processing that the application data base Action Summary carries out.
Below, the acquisition methods of giving one example to above-mentioned database summary is described in detail.
For example: a SQL statement " SELECTAA FROM TABLE1 ";
Can get access to database manipulation type " SELECT " as action type by lexical analysis tool to its scanning, scanning backward again, " AA " of back will be resolved to field by lexical analysis tool, " FROM " meeting is resolved to be the SQL key word, and " TABLE1 " can resolvedly be object (need depend on the configuration of lexical analyzer)." SELECT " " TABLE1 " made up to obtain database manipulation summary " (SELECTTABLE1) ".Like this, resolving has just been finished.
Embodiment three
With reference to Fig. 3, Fig. 3 is the flow chart of steps of another embodiment of disposal route of SQL statement of the present invention, comprising: step S310, determine to extract the information source of database SQL statement operation; Based on context step S320, resolves to database manipulation type and database object with SQL statement; Step S330 after database manipulation type and database object coupling, sorts by execution sequence.Step S340 based on described database manipulation summary, comprises the study of user right and the magnanimity SQL statement is carried out the operation that merger is handled.Certainly, being not limited to aforesaid operations, can also be other data processing that the application data base Action Summary carries out.
The information source of the SQL statement operation here is meant three class database journals:
1) self (file) daily record of database;
2) SQL statement in the databases; With
3) SQL statement that is resolved to of network bypass.
The disposal system embodiment of SQL statement
Embodiment four
With reference to Fig. 4, Fig. 4 is the structured flowchart of the disposal system embodiment of SQL statement of the present invention, comprising: the SQL syntax tree makes up module 42, morphology parsing module 44 and order module 46.Wherein, SQL syntax tree structure module 42 is used to make up the SQL syntax tree; Morphology parsing module 44 is used for resolving and grammatical analysis by morphology, extracts action type and database object, and it is right that each action type and database object are formed a meaning guest; Order module 46 according to the order of carrying out to a plurality of meaning guests to sorting.Application module 48 based on described database manipulation summary, comprises the study of user right and the magnanimity SQL statement is carried out the operation that merger is handled.Certainly, being not limited to aforesaid operations, can also be other data processing that the application data base Action Summary carries out.
Wherein, the order of execution is meant that SQL statement is by the order of the execution of the instruction after compiling in database.With reference to following Example ordering is understood.
The execution sequence of SELECT*FROM TABLE1 UNION SELECT * FROM TABLE2 is:
SELECT*FROM?TABLE1
SELECT*FROM?TABLE2
Embodiment five
With reference to Fig. 5, Fig. 5 comprises: character string scan module 52, action type acquisition module 54, object acquisition module 56 and order module 58 for the structured flowchart of the disposal system embodiment of SQL statement of the present invention.
Wherein, character string scan module 52 is used for resolving and grammatical analysis by morphology, carries out character string scanning; Action type acquisition module 54 is used to obtain the key word of database manipulation type, with described key word as the database manipulation type; Object acquisition module 56 is used to extract the speech section of character string back as database object; Order module 58 is used for sorting by execution sequence after database manipulation type and the pairing of database object coupling.Application module 59 is used for based on the database manipulation summary, comprises the study of user right and the magnanimity SQL statement is carried out the operation that merger is handled.Below, giving one example is described in detail said system.
For example: a SQL statement " SELECTAA FROM TABLE1 ":
Can get access to database manipulation type " SELECT " as action type by above-mentioned lexical analysis tool to its scanning, scanning backward again, " AA " of back will be resolved to field by lexical analysis tool, " FROM " meeting is resolved to be the SQL key word, and " TABLE1 " can resolvedly be object (need depend on the configuration of lexical analyzer)." SELECT " " TABLE1 " made up to obtain database manipulation summary " (SELECTTABLE1) ".Such resolving the simplest is finished.
Embodiment six
With reference to Fig. 6, Fig. 6 comprises: SQL statement information source determination module 62, context parsing module 64 and order module 66 for the structured flowchart of the disposal system embodiment of SQL statement of the present invention.Wherein, SQL statement information source determination module 62 is used for determining to extract the information source of database SQL statement operation; Based on context context parsing module 64 is used for, and SQL statement is resolved to database manipulation type and database object; Order module 66 with database manipulation type and database object coupling after, sort by execution sequence.Application module is used for based on the database manipulation summary, comprises the study of user right and the magnanimity SQL statement is carried out the operation that merger is handled.Certainly, being not limited to aforesaid operations, can also be other data processing that the application data base Action Summary carries out.
The information source of the SQL statement operation here is meant three class database journals:
1) self (file) daily record of database;
2) SQL statement in the databases; With
3) SQL statement that is resolved to of network bypass.
More than the disposal route and the system of a kind of SQL statement provided by the present invention described in detail, used specific embodiment herein principle of the present invention and embodiment are set forth, the explanation of above embodiment just is used for helping to understand method of the present invention and core concept thereof; Simultaneously, for one of ordinary skill in the art, according to thought of the present invention, part in specific embodiments and applications all can change.In sum, this description should not be construed as limitation of the present invention.
Claims (8)
1. the disposal route of a SQL statement is characterized in that, described method comprises:
Analyzing step resolves to the database manipulation summary with SQL statement, and described database manipulation summary is that database manipulation type and database object are formed the right ordered set of meaning guest; Wherein, described database manipulation type list shows the mode of database manipulation; Described database object table is shown an entity in the database.
2. the disposal route of SQL statement according to claim 1 is characterized in that,
Described analyzing step is:
Make up the SQL syntax tree, resolve and grammatical analysis by morphology, extract action type and database object, it is right to form the meaning guest, according to the rank order of carrying out.
3. the disposal route of SQL statement according to claim 1 is characterized in that,
Described analyzing step is:
By lexical analysis, carry out character string scanning, obtain the key word of database manipulation type, with described key word as the database manipulation type, speech section by extracting the character string back is as the database object part, after database manipulation type and the pairing of database object coupling, press the execution sequence ordering.
4. the disposal route of SQL statement according to claim 1 is characterized in that,
Described analyzing step is:
Determine to extract the information source of database SQL statement operation, based on context,
SQL statement is resolved to described database manipulation type and database object.
5. the disposal system of a SQL statement is characterized in that, comprising:
Parsing module is used for SQL statement is resolved to the database manipulation summary, and described database manipulation summary is that database manipulation type and database object are formed the right ordered set of meaning guest; Wherein, described database manipulation type list shows the mode of database manipulation; Described database object table is shown an entity in the database.
6. the disposal system of SQL statement according to claim 5 is characterized in that,
Described parsing module is used for:
Make up the SQL syntax tree, resolve and grammatical analysis by morphology, extract action type and database object, it is right to form the meaning guest, according to the rank order of carrying out.
7. the disposal system of SQL statement according to claim 5 is characterized in that,
Described parsing module is used for:
Carry out character string scanning, obtain the key word of database manipulation type, as the database manipulation type, the speech section by extracting the character string back is as the database object part with described key word, after database manipulation type and the pairing of database object coupling, press the execution sequence ordering.
8. the disposal system of SQL statement according to claim 5 is characterized in that,
Described parsing module is:
Determine to extract the information source of database SQL statement operation, based on context,
SQL statement is resolved to described database manipulation type and database object.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110094710 CN102156740B (en) | 2011-04-15 | 2011-04-15 | SQL (structured query language) statement processing method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110094710 CN102156740B (en) | 2011-04-15 | 2011-04-15 | SQL (structured query language) statement processing method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102156740A true CN102156740A (en) | 2011-08-17 |
| CN102156740B CN102156740B (en) | 2013-02-13 |
Family
ID=44438239
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 201110094710 Expired - Fee Related CN102156740B (en) | 2011-04-15 | 2011-04-15 | SQL (structured query language) statement processing method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102156740B (en) |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102426582A (en) * | 2011-09-29 | 2012-04-25 | 用友软件股份有限公司 | Data operation management device and data operation management method |
| CN103186541A (en) * | 2011-12-27 | 2013-07-03 | 阿里巴巴集团控股有限公司 | Generation method and device for mapping relationship |
| CN103778185A (en) * | 2013-12-27 | 2014-05-07 | 北京天融信软件有限公司 | SQL statement parsing method and system used for database auditing system |
| CN104391895A (en) * | 2014-11-12 | 2015-03-04 | 珠海世纪鼎利通信科技股份有限公司 | SQL (Structured Query Language) sentence processing system based on cloud computing |
| CN104424269A (en) * | 2013-08-30 | 2015-03-18 | 中国电信股份有限公司 | Data linage analysis method and device |
| CN104572638A (en) * | 2013-10-09 | 2015-04-29 | 腾讯科技（深圳）有限公司 | Data reading and writing method and device |
| CN107451149A (en) * | 2016-05-31 | 2017-12-08 | 北京京东尚科信息技术有限公司 | The monitoring method and its device of data on flows query task |
| CN107992766A (en) * | 2017-11-29 | 2018-05-04 | 北京安华金和科技有限公司 | A kind of multiple statement audit and control method based on SQLServer databases |
| CN108008947A (en) * | 2017-12-25 | 2018-05-08 | 上海达梦数据库有限公司 | A kind of intelligent prompt method of programmed statements, device, server and storage medium |
| US10073871B2 (en) | 2015-11-09 | 2018-09-11 | International Business Machines Corporation | Database entity analysis |
| WO2019161618A1 (en) * | 2018-02-24 | 2019-08-29 | 平安科技（深圳）有限公司 | Character string parsing method, apparatus and device, and computer-readable storage medium |
| CN110309171A (en) * | 2018-02-26 | 2019-10-08 | 华为技术有限公司 | Data base query method, server and system |
| CN110476159A (en) * | 2017-03-30 | 2019-11-19 | 日本电气株式会社 | Information processing system, characteristic value illustration method and characteristic value read-me |
| CN111259039A (en) * | 2020-02-12 | 2020-06-09 | 平安科技（深圳）有限公司 | Database operation method, device, equipment and computer readable storage medium |
| CN114238322A (en) * | 2021-12-10 | 2022-03-25 | 安徽兆尹信息科技股份有限公司 | Database sub-library and sub-table insertion method based on Sharding-JDBC kernel |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060248083A1 (en) * | 2004-12-30 | 2006-11-02 | Oracle International Corporation | Mandatory access control base |
| CN101075256A (en) * | 2007-06-08 | 2007-11-21 | 北京神舟航天软件技术有限公司 | System and method for real-time auditing and analyzing database |
| US20090144242A1 (en) * | 2007-12-03 | 2009-06-04 | Chartsource, Inc., A Delaware Corporation | Indexer for searching research data |
| CN101609493A (en) * | 2009-07-21 | 2009-12-23 | 国网电力科学研究院 | A kind of database SQL infusion protecting method based on self study |
| CN101901222A (en) * | 2009-05-27 | 2010-12-01 | 北京启明星辰信息技术股份有限公司 | Method and system for analyzing and matching SQLs (Structured Query Languages) |
-
2011
- 2011-04-15 CN CN 201110094710 patent/CN102156740B/en not_active Expired - Fee Related
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060248083A1 (en) * | 2004-12-30 | 2006-11-02 | Oracle International Corporation | Mandatory access control base |
| CN101075256A (en) * | 2007-06-08 | 2007-11-21 | 北京神舟航天软件技术有限公司 | System and method for real-time auditing and analyzing database |
| US20090144242A1 (en) * | 2007-12-03 | 2009-06-04 | Chartsource, Inc., A Delaware Corporation | Indexer for searching research data |
| CN101901222A (en) * | 2009-05-27 | 2010-12-01 | 北京启明星辰信息技术股份有限公司 | Method and system for analyzing and matching SQLs (Structured Query Languages) |
| CN101609493A (en) * | 2009-07-21 | 2009-12-23 | 国网电力科学研究院 | A kind of database SQL infusion protecting method based on self study |
Cited By (23)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102426582B (en) * | 2011-09-29 | 2016-03-30 | 用友软件股份有限公司 | Data manipulation management devices and data manipulation management method |
| CN102426582A (en) * | 2011-09-29 | 2012-04-25 | 用友软件股份有限公司 | Data operation management device and data operation management method |
| CN103186541A (en) * | 2011-12-27 | 2013-07-03 | 阿里巴巴集团控股有限公司 | Generation method and device for mapping relationship |
| CN103186541B (en) * | 2011-12-27 | 2016-08-24 | 阿里巴巴集团控股有限公司 | A kind of mapping relations generate method and device |
| CN104424269B (en) * | 2013-08-30 | 2018-01-30 | 中国电信股份有限公司 | data lineage analysis method and device |
| CN104424269A (en) * | 2013-08-30 | 2015-03-18 | 中国电信股份有限公司 | Data linage analysis method and device |
| CN104572638A (en) * | 2013-10-09 | 2015-04-29 | 腾讯科技（深圳）有限公司 | Data reading and writing method and device |
| CN104572638B (en) * | 2013-10-09 | 2019-03-26 | 腾讯科技（深圳）有限公司 | Data read-write method and device |
| CN103778185A (en) * | 2013-12-27 | 2014-05-07 | 北京天融信软件有限公司 | SQL statement parsing method and system used for database auditing system |
| CN104391895A (en) * | 2014-11-12 | 2015-03-04 | 珠海世纪鼎利通信科技股份有限公司 | SQL (Structured Query Language) sentence processing system based on cloud computing |
| US10901963B2 (en) | 2015-11-09 | 2021-01-26 | International Business Machines Corporation | Database entity analysis |
| US10073871B2 (en) | 2015-11-09 | 2018-09-11 | International Business Machines Corporation | Database entity analysis |
| CN107451149A (en) * | 2016-05-31 | 2017-12-08 | 北京京东尚科信息技术有限公司 | The monitoring method and its device of data on flows query task |
| CN110476159A (en) * | 2017-03-30 | 2019-11-19 | 日本电气株式会社 | Information processing system, characteristic value illustration method and characteristic value read-me |
| CN107992766A (en) * | 2017-11-29 | 2018-05-04 | 北京安华金和科技有限公司 | A kind of multiple statement audit and control method based on SQLServer databases |
| CN108008947B (en) * | 2017-12-25 | 2020-08-25 | 上海达梦数据库有限公司 | Intelligent prompting method and device for programming statement, server and storage medium |
| CN108008947A (en) * | 2017-12-25 | 2018-05-08 | 上海达梦数据库有限公司 | A kind of intelligent prompt method of programmed statements, device, server and storage medium |
| WO2019161618A1 (en) * | 2018-02-24 | 2019-08-29 | 平安科技（深圳）有限公司 | Character string parsing method, apparatus and device, and computer-readable storage medium |
| CN110309171A (en) * | 2018-02-26 | 2019-10-08 | 华为技术有限公司 | Data base query method, server and system |
| CN110309171B (en) * | 2018-02-26 | 2021-08-20 | 华为技术有限公司 | Database query method, server and system |
| CN111259039A (en) * | 2020-02-12 | 2020-06-09 | 平安科技（深圳）有限公司 | Database operation method, device, equipment and computer readable storage medium |
| CN114238322A (en) * | 2021-12-10 | 2022-03-25 | 安徽兆尹信息科技股份有限公司 | Database sub-library and sub-table insertion method based on Sharding-JDBC kernel |
| CN114238322B (en) * | 2021-12-10 | 2024-04-12 | 安徽兆尹信息科技股份有限公司 | Database sub-table insertion method based on Sharding-JDBC kernel |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102156740B (en) | 2013-02-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102156740B (en) | SQL (structured query language) statement processing method and system | |
| CN104636478A (en) | Information query method and device | |
| CN104424269A (en) | Data linage analysis method and device | |
| CN105718585B (en) | Document and label word justice correlating method and its device | |
| CN102279894A (en) | Method for searching, integrating and providing comment information based on semantics and searching system | |
| CN104268216A (en) | Data cleaning system based on internet information | |
| US20170109358A1 (en) | Method and system of determining enterprise content specific taxonomies and surrogate tags | |
| CN110659282A (en) | Data route construction method and device, computer equipment and storage medium | |
| CN104750496A (en) | Automatic checking method for change influence degree of model | |
| CN109558166A (en) | A kind of code search method of facing defects positioning | |
| CN116450908B (en) | Self-service data analysis method and device based on data lake and electronic equipment | |
| CN105095436A (en) | Automatic modeling method for data of data sources | |
| Petermann et al. | Graph mining for complex data analytics | |
| CN113157978B (en) | Data label establishing method and device | |
| CN112199488B (en) | Incremental knowledge graph entity extraction method and system for power customer service question and answer | |
| CN110874366A (en) | Data processing and query method and device | |
| CN110929509B (en) | Domain event trigger word clustering method based on louvain community discovery algorithm | |
| CN104750834A (en) | Rule storage method and matching method and device | |
| CN112416904A (en) | Electric power data standardization processing method and device | |
| CN110990423A (en) | SQL statement execution method, device, equipment and storage medium | |
| CN107633094B (en) | Method and device for data retrieval in cluster environment | |
| CN106682107B (en) | Method and device for determining incidence relation of database table | |
| CN110147396B (en) | Mapping relation generation method and device | |
| Jabeen et al. | Divided we stand out! Forging Cohorts fOr Numeric Outlier Detection in large scale knowledge graphs (CONOD) | |
| CN105573984A (en) | Socio-economic indicator identification method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: SQL (structured query language) statement processing method and system Effective date of registration: 20140807 Granted publication date: 20130213 Pledgee: Haidian Beijing science and technology enterprise financing Company limited by guarantee Pledgor: Captech Information Auditing System Technology (Beijing) Co., Ltd. Registration number: 2014990000640 |
|
| PLDC | Enforcement, change and cancellation of contracts on pledge of patent right or utility model | ||
| PC01 | Cancellation of the registration of the contract for pledge of patent right |
Date of cancellation: 20150928 Granted publication date: 20130213 Pledgee: Haidian Beijing science and technology enterprise financing Company limited by guarantee Pledgor: Captech Information Auditing System Technology (Beijing) Co., Ltd. Registration number: 2014990000640 |
|
| PLDC | Enforcement, change and cancellation of contracts on pledge of patent right or utility model | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20130213 Termination date: 20160415 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |