CN102156740B - SQL (structured query language) statement processing method and system - Google Patents
SQL (structured query language) statement processing method and system Download PDFInfo
- Publication number
- CN102156740B CN102156740B CN 201110094710 CN201110094710A CN102156740B CN 102156740 B CN102156740 B CN 102156740B CN 201110094710 CN201110094710 CN 201110094710 CN 201110094710 A CN201110094710 A CN 201110094710A CN 102156740 B CN102156740 B CN 102156740B
- Authority
- CN
- China
- Prior art keywords
- database
- sql statement
- database manipulation
- type
- sql
- 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.)
- Expired - Fee Related
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
(such as the product of a lot of existing databases audits) all is 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, well negative relational matching 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 the 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 form 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, form meaning guest couple, according to the order ordering 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, word 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 form 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, form meaning guest couple, according to the order ordering 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, word 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, namely orderly meaning guest couple 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 for the study user right, the magnanimity SQL statement is carried out that merger is processed and to the 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 is the flow chart of steps of the disposal route embodiment of SQL statement of the present invention, comprises the steps: step S110, makes up the SQL syntax tree; Step S120 by lexical analysis, extracts action type and database object, and each action type and database object form a meaning guest couple; 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 processed.
The below is further detailed above-mentioned each step.
In step S130, the order of execution refers to the order of the execution of instruction in database after SQL statement is compiled.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 Action 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 access in which way what table) for this user:
| update | delete | insert | select | |
| usertable | ○ | × | × | ○ |
| Table1 | ○ | × | × | ○ |
| Table2 | ○ | × | × | ○ |
| Table3 | × | × | × | ○ |
| Table4 | ○ | ○ | × | ○ |
So for SQL statement
INSERT?INTO?USERTABLE(NAME，AGE)?VALUES(“zhangsan”，24)
INSERT?INTO?USERTABLE(NAME，AGE)VALUES(“lisi”，23)
System can find that producing alarm does further processing in violation of rules and regulations.
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 only having generation to be similar to the database manipulation summary could generate relevant statistics.(2) structure of only having generation to be similar to the database manipulation summary could be judged the judgement for the authority of " can access in which way what table ".
Below, illustrating in step S140, the based on database Action Summary carries out merger to the magnanimity SQL statement to be processed.
What often face for 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 database manipulations can corresponding a plurality of database manipulations thus, 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, the based on database Action Summary carries out the study of merger processing or user right to the magnanimity SQL statement, only is exemplary, database manipulation summary can also be applied in other occasions, the present invention is not construed as limiting 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 extracts the word section of character string back 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 processed.Certainly, being not limited to aforesaid operations, can also be that other data that the application data base Action Summary carries out are processed.
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, again backward scanning, " AA " of back will be resolved to field by lexical analysis tool, " FROM " can resolvedly be the SQL key word, and " TABLE1 " can resolvedly be object (need to 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 processed.Certainly, being not limited to aforesaid operations, can also be that other data that the application data base Action Summary carries out are processed.
The information source of the SQL statement operation here refers to 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, the SQL syntax tree makes up module 42 for making 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 each action type and database object form a meaning guest couple; 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 processed.Certainly, being not limited to aforesaid operations, can also be that other data that the application data base Action Summary carries out are processed.
Wherein, the order of execution refers to the order of the execution of instruction in database after SQL statement is compiled.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 is the structured flowchart of the disposal system embodiment of SQL statement of the present invention, comprising: character string scan module 52, action type acquisition module 54, object acquisition module 56 and order module 58.
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 for obtaining the key word of database manipulation type, with described key word as the database manipulation type; Object acquisition module 56 is used for extracting the word 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 the based on database Action Summary, comprises the study of user right and the magnanimity SQL statement is carried out the operation that merger is processed.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, again backward scanning, " AA " of back will be resolved to field by lexical analysis tool, " FROM " can resolvedly be the SQL key word, and " TABLE1 " can resolvedly be object (need to 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 is the structured flowchart of the disposal system embodiment of SQL statement of the present invention, comprising: SQL statement information source determination module 62, context parsing module 64 and order module 66.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 the based on database Action Summary, comprises the study of user right and the magnanimity SQL statement is carried out the operation that merger is processed.Certainly, being not limited to aforesaid operations, can also be that other data that the application data base Action Summary carries out are processed.
The information source of the SQL statement operation here refers to 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 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, all will change in specific embodiments and applications.In sum, this description should not be construed as limitation of the present invention.
Claims (2)
1. the disposal route of a SQL statement is characterized in that comprising:
Analyzing step resolves to the database manipulation summary with SQL statement, and described database manipulation summary is that database manipulation type and database object form the right ordered set of meaning guest, take ordered set as unit SQL statement is carried out merger and processes; Wherein, described database manipulation type list shows the mode of database manipulation; Described database object table is shown an entity in the database;
By making up the SQL syntax tree, resolve and grammatical analysis by morphology, extract action type and database object, form meaning guest couple, according to the order ordering of carrying out;
Take ordered set as unit to SQL statement carry out step that merger processes as:
The based on database Action Summary carries out merger to the magnanimity SQL statement to be processed;
For 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, the mode of operation of the database user that these users are concerned about and the object information of operation can correspond to the database manipulation summary, system distributes unique ID to this database manipulation summary, and it is designated the classification of " user profile " and so on, embody professional meaning;
Or 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, word 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;
Or 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.
2. the disposal system of a SQL statement is characterized in that comprising:
Parsing module resolves to the database manipulation summary with SQL statement, and described database manipulation summary is that database manipulation type and database object form the right ordered set of meaning guest, take ordered set as unit SQL statement is carried out merger and processes; Wherein, described database manipulation type list shows the mode of database manipulation; Described database object table is shown an entity in the database;
By making up the SQL syntax tree, resolve and grammatical analysis by morphology, extract action type and database object, form meaning guest couple, according to the order ordering of carrying out;
Take ordered set as unit to SQL statement carry out content that merger processes as:
The based on database Action Summary carries out merger to the magnanimity SQL statement to be processed;
For 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, the mode of operation of the database user that these users are concerned about and the object information of operation can correspond to the database manipulation summary, system distributes unique ID to this database manipulation summary, and it is designated the classification of " user profile " and so on, embody professional meaning;
Or described parsing module is used for:
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, word 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;
Or described parsing module is used for:
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 CN102156740A (en) | 2011-08-17 |
| CN102156740B true 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) |
Families Citing this family (15)
| 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 |
| 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 |
| 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 |
| US10073871B2 (en) | 2015-11-09 | 2018-09-11 | International Business Machines Corporation | Database entity analysis |
| CN107451149B (en) * | 2016-05-31 | 2020-11-24 | 北京京东尚科信息技术有限公司 | Monitoring method and device for flow data query task |
| WO2018180970A1 (en) * | 2017-03-30 | 2018-10-04 | 日本電気株式会社 | Information processing system, feature value explanation method and feature value explanation program |
| 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 |
| CN108388547A (en) * | 2018-02-24 | 2018-08-10 | 平安科技（深圳）有限公司 | Character string parsing method, apparatus, equipment and computer readable storage medium |
| 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 |
| CN114238322B (en) * | 2021-12-10 | 2024-04-12 | 安徽兆尹信息科技股份有限公司 | Database sub-table insertion method based on Sharding-JDBC kernel |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101075256A (en) * | 2007-06-08 | 2007-11-21 | 北京神舟航天软件技术有限公司 | System and method for real-time auditing and analyzing database |
| 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) |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7593942B2 (en) * | 2004-12-30 | 2009-09-22 | Oracle International Corporation | Mandatory access control base |
| US20090144242A1 (en) * | 2007-12-03 | 2009-06-04 | Chartsource, Inc., A Delaware Corporation | Indexer for searching research data |
-
2011
- 2011-04-15 CN CN 201110094710 patent/CN102156740B/en not_active Expired - Fee Related
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101075256A (en) * | 2007-06-08 | 2007-11-21 | 北京神舟航天软件技术有限公司 | System and method for real-time auditing and analyzing database |
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102156740A (en) | 2011-08-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102156740B (en) | SQL (structured query language) statement processing method and system | |
| CN104424269A (en) | Data linage analysis method and device | |
| CN105718585B (en) | Document and label word justice correlating method and its device | |
| CN102651013B (en) | Method and system for extracting area information from enterprise name data | |
| CN110597844B (en) | Unified access method for heterogeneous database data and related equipment | |
| CN104268216A (en) | Data cleaning system based on internet information | |
| CN110659282A (en) | Data route construction method and device, computer equipment and storage medium | |
| CN104756113A (en) | Method, apparatus and computer program for detecting deviations in data sources | |
| CN105095436A (en) | Automatic modeling method for data of data sources | |
| KR102345410B1 (en) | Big data intelligent collecting method and device | |
| CN110826299B (en) | General template log analysis method based on classification | |
| Petermann et al. | Graph mining for complex data analytics | |
| CN110688572A (en) | Method for identifying search intention in cold starting state | |
| CN113157978B (en) | Data label establishing method and device | |
| CN104750834A (en) | Rule storage method and matching method and device | |
| CN110990423B (en) | SQL statement execution method, device, equipment and storage medium | |
| CN105512270B (en) | Method and device for determining related objects | |
| CN110929509B (en) | Domain event trigger word clustering method based on louvain community discovery algorithm | |
| CN112241262A (en) | Software-defined satellite-oriented reusable code extracting, analyzing and retrieving method and device | |
| 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 | |
| CN105573984A (en) | Socio-economic indicator identification method and device | |
| CN113934430A (en) | Data retrieval analysis method and device, electronic equipment and storage medium | |
| CN110569243B (en) | Data query method, data query plug-in and data query server |
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 | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20130213 Termination date: 20160415 |