CN106777076A - A kind of SQL limits inquiry clause generation method and combinational logic filter - Google Patents
A kind of SQL limits inquiry clause generation method and combinational logic filter Download PDFInfo
- Publication number
- CN106777076A CN106777076A CN201611145061.2A CN201611145061A CN106777076A CN 106777076 A CN106777076 A CN 106777076A CN 201611145061 A CN201611145061 A CN 201611145061A CN 106777076 A CN106777076 A CN 106777076A
- Authority
- CN
- China
- Prior art keywords
- filter
- combinational logic
- sql statement
- sql
- parameter value
- 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
- 238000000034 method Methods 0.000 title claims abstract description 91
- 239000011800 void material Substances 0.000 claims abstract description 47
- 241000208340 Araliaceae Species 0.000 claims description 2
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 claims description 2
- 235000003140 Panax quinquefolius Nutrition 0.000 claims description 2
- 235000008434 ginseng Nutrition 0.000 claims description 2
- 238000001914 filtration Methods 0.000 claims 1
- 230000009286 beneficial effect Effects 0.000 description 3
- 238000010276 construction Methods 0.000 description 3
- 230000015572 biosynthetic process Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000004744 fabric Substances 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 241000894007 species Species 0.000 description 1
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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
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
Inquiry clause generation method and combinational logic filter are limited the present invention relates to a kind of SQL.The method is applied to the combinational logic filter being made up of one or more basic data filters, wherein, basic data filter, including the GetParameters void methods for the value that gets parms and the GetSQL void methods for obtaining SQL statement.The method calls GetSQL void methods to obtain SQL statement, calls GetParameters void methods to get parms value, according to the SQL statement of the parameter value logical join acquisition for obtaining.The present invention calls GetSQL void methods to obtain SQL statement, calls GetParameters void methods to get parms value, and according to the SQL statement that the parameter value logical join for obtaining is obtained, the execution route of the restriction inquiry clause being spliced into is more excellent and realizes simply.
Description
Technical field
Inquiry clause generation method and group are limited the present invention relates to Distributed Calculation application field, more particularly to a kind of SQL
Logical filter.
Background technology
SQL (Structured Query Language, SQL) is a kind of programming language of specific purposes
Speech, is senior deproceduring programming language, it is allowed to which user works in high level data structure.It does not require that user specifies logarithm
According to deposit method, it is not required that user understands specific data location mode, so with entirely different fabric not
Same Database Systems, it is possible to use identical SQL is used as data input and the interface for managing.Meanwhile, SQL languages
Sentence can be with nesting, and this makes it have great flexibility and powerful function.Now it is widely used in access data and inquiry, more
New and administrative relationships Database Systems.
At present, the generation method of SQL restrictions query statement has two methods：
First way, takes the mode of string-concatenation, such as：There are NAME (title), ADDRESS (in user interface
Location) two fields querying condition, then the splicing of querying condition can be completed according to several different input states in a program：
When NAME inputs are not space-time, the condition relevant with NAME is spliced in query statement；Equally, when ADDRESS fields are input into
It is not space-time, then the condition relevant with ADDRESS is spliced in query statement.
Although this mode execution route is more excellent, programming process is complicated, specifically in querying condition when there is comparing to answer
During miscellaneous logical construction, then complexity is higher；
The second way, take OR (or) mode carry out, by taking ORACLE as an example, there is NAME, ADDRESS in user interface
During the querying condition of two fields, the WHERE clause of SQL can be written as：(:NAME IS NULL OR NAME LIKE:
NAME)AND(:ADDRESS IS NULL OR ADDRESS LIKE:ADDRESS)。
Although the second way can simplify program code, execution route can be allowed to become very bad, prevent index from
It is utilized effectively.
The content of the invention
(1) technical problem to be solved
In order to simple and preferably generation limits inquiry clause, the present invention provides a kind of SQL and limits inquiry clause generation side
Method and combinational logic filter, call GetSQL void methods to obtain SQL statement, call GetParameters void methods to obtain ginseng
Numerical value, according to the SQL statement that the parameter value logical join for obtaining is obtained, the execution route of the restriction inquiry clause being spliced into is more excellent
And realize simple.
(2) technical scheme
In order to achieve the above object, the main technical schemes that the present invention is used include：
A kind of SQL SQL limits the generation method of inquiry clause, and methods described is applied to combinational logic mistake
Filter, the combinational logic filter is made up of one or more basic data filters；The basic data filter, including
GetParameters void methods for the value that gets parms and the GetSQL void methods for obtaining SQL statement；
Methods described includes：
101, call the GetSQL void methods included by the basic data filter to obtain SQL statement；
102, call the void methods of the GetParameters included by the basic data filter to get parms value；
103, according to the SQL statement that the parameter value logical join for obtaining is obtained.
Alternatively, step 103 is specifically included：
103-1, according to the parameter value for obtaining, it is determined that the parameter value of the SQL statement |input paramete for obtaining；
103-2, the SQL statement of the parameter value non-NULL of logical join |input paramete.
Alternatively, the combinational logic filter is and logic filters；
Step 103-2 is specifically included：
Splice the SQL statement of the parameter value non-NULL of |input paramete with AND symbol.
Alternatively the combinational logic filter is or logic filters；
Step 103-2 is specifically included：
Splice the SQL statement of the parameter value non-NULL of |input paramete with OR symbols.
Alternatively, the basic data filter is SQL filters.
In addition, the main technical schemes that the present invention is used also include：
A kind of combinational logic filter, the combinational logic filter is made up of one or more basic data filters；
The basic data filter, including for the GetParameters void methods and for obtaining of the value that gets parms
The GetSQL void methods of SQL SQL statement；
The combinational logic filter, for calling the GetSQL void methods included by the basic data filter to obtain
SQL statement；The void methods of the GetParameters included by the basic data filter are called to get parms value；According to acquisition
Parameter value logical join obtain SQL statement.
Alternatively, the combinational logic filter, for according to the parameter value for obtaining, it is determined that the SQL statement input for obtaining
The parameter value of parameter；The SQL statement of the parameter value non-NULL of logical join |input paramete.
Alternatively, combinational logic filter is base class；The subclass of the combinational logic filter is and logic filters；
Described and logic filters, the SQL statement of the parameter value non-NULL for splicing |input paramete with AND symbol.
Alternatively, combinational logic filter is base class；The subclass of the combinational logic filter is or logic filters；
Described or logic filters, the SQL statement of the parameter value non-NULL for splicing |input paramete with OR symbols.
Alternatively, the basic data filter is base class, and the subclass of the basic data filter is SQL filters.
(3) beneficial effect
The beneficial effects of the invention are as follows：Call GetSQL void methods to obtain SQL statement, call GetParameters void sides
Method gets parms value, according to the SQL statement that the parameter value logical join for obtaining is obtained, the execution of the restriction inquiry clause being spliced into
Path is more excellent and realizes simple.
Brief description of the drawings
A kind of generation method flow chart of SQL restriction inquiry clauses that Fig. 1 is provided for one embodiment of the invention；
Fig. 2 illustrates intention for the species that one embodiment of the invention is provided；
The generation method flow chart of another SQL restriction inquiry clauses that Fig. 3 is provided for one embodiment of the invention.
Specific embodiment
In order to preferably explain the present invention, in order to understand, below in conjunction with the accompanying drawings, by specific embodiment, to this hair
It is bright to be described in detail.
The generation method that traditional SQL limits query statement has two methods：First way, takes string-concatenation
Mode.Although this mode execution route is more excellent, programming process is complicated, specifically more complicated when having in querying condition
During logical construction, then complexity is higher.The second way, take OR (or) mode carry out.Although the second way can be with letter
Change program code, but can allow the execution route to become very bad, prevent index from being utilized effectively.The present invention calls GetSQL
Empty method obtains SQL statement, calls GetParameters void methods to get parms value, according to the parameter value logical join of acquisition
The SQL statement of acquisition, the execution route of the restriction inquiry clause being spliced into is more excellent and realizes simple.
Referring to Fig. 1, the generation method that a kind of SQL limits inquiry clause is present embodiments provided, the method is applied to combination
Logic filters, the combinational logic filter is made up of one or more basic data filters；Basic data filter, including
GetParameters void methods for the value that gets parms and the GetSQL void methods for obtaining SQL statement；
The method includes：
101, call the GetSQL void methods included by basic data filter to obtain SQL statement.
102, call the void methods of the GetParameters included by basic data filter to get parms value.
103, according to the SQL statement that the parameter value logical join for obtaining is obtained.
Alternatively, step 103 is specifically included：
103-1, according to the parameter value for obtaining, it is determined that the parameter value of the SQL statement |input paramete for obtaining.
103-2, the SQL statement of the parameter value non-NULL of logical join |input paramete.
Alternatively, combinational logic filter is and logic filters；
Step 103-2 is specifically included：
Splice the SQL statement of the parameter value non-NULL of |input paramete with AND symbol.
Alternatively, combinational logic filter is or logic filters；
Step 103-2 is specifically included：
Splice the SQL statement of the parameter value non-NULL of |input paramete with OR symbols.
Alternatively, basic data filter is SQL filters.
The beneficial effects of the invention are as follows：Call GetSQL void methods to obtain SQL statement, call GetParameters void sides
Method gets parms value, according to the SQL statement that the parameter value logical join for obtaining is obtained, the execution of the restriction inquiry clause being spliced into
Path is more excellent and realizes simple.
The generation method that a kind of SQL that the present invention is provided limits inquiry clause is applied in the class formation shown in Fig. 2, such
Structure includes
1st, combinational logic filter (CompositeLogicFilter), is the base class of all logic filters, and it has individual
The aggregate attribute of one entitled ChildDataFilters, represents that combinational logic filter is by multiple basic data filters
(BaseDataFilter) constitute.
(1) AndLogicFilter, it is the subclass of CompositeLogicFilter, for reality to be and logic filters
The splicing with mode of the subclass of existing each basic data filter.
(2) OrLogicFilter, it is the subclass of CompositeLogicFilter, for realizing to be or logic filters
The splicing with mode of the subclass of each basic data filter.
2nd, BaseDataFilter, is the base class of all data filters.It includes following two empty methods, by
Each subclass of BaseDataFilter is voluntarily realized：
(1) GetParameters void method, all parameters for obtaining data filter.
(2) GetSQL void method, for obtaining SQL statement.
The subclass of BaseDataFilter is SQL filters (SqlFilter) and CompositeLogicFilter.
● for GetParameters void methods, that it is returned in SqlFilter is ParameterName.Its
In CompositeLogicFilter return be all ChildDataFilters GetParameters parallel connection after knot
Really；
● for GetSQL void methods, what it was returned in SqlFilter is SQL characteristics (attribute).
Returned in AndLogicalFilter be in ChildDataFilters all |input parametes for empty GetSQL methods are returned
The value spliced result of AND symbol.In OrLogicalFilter, it is institute in ChildDataFilters that the method is returned
It is not the empty GetSQL method return value spliced results of OR symbols to have |input paramete.
In addition, containing a filter clause in SqlFilter, and there is a ParameterName identification parameter
Title, this parameter name is corresponding with the parameter name in the parameterValues in GetSQL, if
ParameterName is can not find in parameterValues, is then believed that this SqlFilter should not be comprised in final
In SQL.
Based on the class figure shown in Fig. 2, SQL is performed with the subclass OrLogicFilter of CompositeLogicFilter and is limited
Illustrated again as a example by the process of the generation method for determining inquiry clause, referring to Fig. 3.
301, OrLogicFilter call the GetSQL void methods included by SqlFilter to obtain SQL statement.
302, OrLogicFilter call the GetParameters void methods included by SqlFilter to get parms value.
303, OrLogicFilter according to the parameter value for obtaining, it is determined that the parameter value of the SQL statement |input paramete for obtaining,
Splice the SQL statement of the parameter value non-NULL of |input paramete with OR symbols.
Below again based on the class figure shown in Fig. 2, with the subclass AndLogicalFilter of CompositeLogicFilter
Illustrated again as a example by the process for performing the generation method that SQL limits inquiry clause.
If following construction：
Then, when:NAME parameters have value,:ADDRESS is space-time, and ultimately generating restriction inquiry WHERE clause is：
NAME LIKE:NAME
When:NAME parameters are sky,:When ADDRESS has value, ultimately generating WHERE clause is：
ADDRESS LIKE:ADDRESS
When:NAME and:When ADDRESS has value, ultimately generating WHERE clause is：
(NAME LIKE:NAME)AND(ADDRESS LIKE:ADDRESS)
In the method that the present embodiment is provided, all filters being related to have two public methods：One is to get parms
List, for obtaining the parameter in data filter, one is the side that final WHERE clause is obtained according to the value of |input paramete
Method.The method provided by the present embodiment can be spliced into the SQL WHERE clauses that execution route optimizes.
The method call GetSQL void methods that the present embodiment is provided obtain SQL statement, call GetParameters void methods
Get parms value, according to the SQL statement that the parameter value logical join for obtaining is obtained, the execution road of the restriction inquiry clause being spliced into
Footpath is more excellent and realizes simple.
Based on same inventive concept, the present invention also provides a kind of combinational logic filter, and the combinational logic filter is by one
Individual or multiple basic data filter compositions；
Wherein, basic data filter, including for the GetParameters void methods and for obtaining of the value that gets parms
The GetSQL void methods of SQL SQL statement；
Combinational logic filter, for calling the GetSQL void methods included by basic data filter to obtain SQL statement；
The void methods of the GetParameters included by basic data filter are called to get parms value；According to the parameter value logic for obtaining
Splice the SQL statement for obtaining.
Alternatively, combinational logic filter, for according to the parameter value for obtaining, it is determined that the SQL statement |input paramete for obtaining
Parameter value；The SQL statement of the parameter value non-NULL of logical join |input paramete.
Alternatively, combinational logic filter is base class；The subclass of combinational logic filter is and logic filters；
With logic filters, the SQL statement of the parameter value non-NULL for splicing |input paramete with AND symbol.
Alternatively, combinational logic filter is base class；The subclass of combinational logic filter is or logic filters；
Or logic filters, the SQL statement of the parameter value non-NULL for splicing |input paramete with OR symbols.
Alternatively, basic data filter is base class, and the subclass of basic data filter is SQL filters, and basic number
It is combinational logic filter according to the subclass of filter.
The combinational logic filter that the present embodiment is provided calls GetSQL void methods to obtain SQL statement, calls
GetParameters void methods get parms value, according to the SQL statement of the parameter value logical join acquisition for obtaining, are spliced into
The execution route of restriction inquiry clause is more excellent and realizes simple.
Claims (10)
1. a kind of SQL SQL limits the generation method of inquiry clause, and methods described is applied to combinational logic filtering
Device, it is characterised in that the combinational logic filter is made up of one or more basic data filters；The basic data mistake
Filter, including the GetParameters void methods for the value that gets parms and the GetSQL void methods for obtaining SQL statement；
Methods described includes：
101, call the GetSQL void methods included by the basic data filter to obtain SQL statement；
102, call the void methods of the GetParameters included by the basic data filter to get parms value；
103, according to the SQL statement that the parameter value logical join for obtaining is obtained.
2. method according to claim 1, it is characterised in that step 103 is specifically included：
103-1, according to the parameter value for obtaining, it is determined that the parameter value of the SQL statement |input paramete for obtaining；
103-2, the SQL statement of the parameter value non-NULL of logical join |input paramete.
3. method according to claim 2, it is characterised in that the combinational logic filter is and logic filters；
Step 103-2 is specifically included：
Splice the SQL statement of the parameter value non-NULL of |input paramete with AND symbol.
4. method according to claim 2, it is characterised in that the combinational logic filter is or logic filters；
Step 103-2 is specifically included：
Splice the SQL statement of the parameter value non-NULL of |input paramete with OR symbols.
5. the method according to Claims 1-4 any claim, it is characterised in that the basic data filter is
SQL filters.
6. a kind of combinational logic filter, it is characterised in that the combinational logic filter is by one or more basic data mistakes
Filter is constituted；
The basic data filter, including for the GetParameters void methods and for obtaining structure of the value that gets parms
Change the GetSQL void methods of query language SQL statement；
The combinational logic filter, for calling the GetSQL void methods included by the basic data filter to obtain SQL
Sentence；The void methods of the GetParameters included by the basic data filter are called to get parms value；According to the ginseng for obtaining
The SQL statement that numerical value logical join is obtained.
7. combinational logic filter according to claim 6, it is characterised in that the combinational logic filter, for root
According to the parameter value for obtaining, it is determined that the parameter value of the SQL statement |input paramete for obtaining；The parameter value non-NULL of logical join |input paramete
SQL statement.
8. combinational logic filter according to claim 7, it is characterised in that combinational logic filter is base class；It is described
The subclass of combinational logic filter is and logic filters；
Described and logic filters, the SQL statement of the parameter value non-NULL for splicing |input paramete with AND symbol.
9. combinational logic filter according to claim 7, it is characterised in that combinational logic filter is base class；It is described
The subclass of combinational logic filter is or logic filters；
Described or logic filters, the SQL statement of the parameter value non-NULL for splicing |input paramete with OR symbols.
10. the combinational logic filter according to claim 1 to 9 any claim, it is characterised in that the basic number
Be base class according to filter, the subclass of the basic data filter is SQL filters, and the basic data filter subclass
It is the combinational logic filter.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611145061.2A CN106777076B (en) | 2016-12-13 | 2016-12-13 | SQL limited query clause generation method and combinational logic filter |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611145061.2A CN106777076B (en) | 2016-12-13 | 2016-12-13 | SQL limited query clause generation method and combinational logic filter |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106777076A true CN106777076A (en) | 2017-05-31 |
| CN106777076B CN106777076B (en) | 2020-05-05 |
Family
ID=58880766
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611145061.2A Active CN106777076B (en) | 2016-12-13 | 2016-12-13 | SQL limited query clause generation method and combinational logic filter |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106777076B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102222110A (en) * | 2011-06-28 | 2011-10-19 | 用友软件股份有限公司 | Data processing device and method |
| CN103093000A (en) * | 2013-02-25 | 2013-05-08 | 用友软件股份有限公司 | Database query modeling system and database query modeling method |
| CN103744891A (en) * | 2013-12-23 | 2014-04-23 | 大唐软件技术股份有限公司 | Method and system for data query |
| CN103902606A (en) * | 2012-12-28 | 2014-07-02 | 腾讯科技（深圳）有限公司 | Data processing method and system of database |
| CN104361040A (en) * | 2014-10-29 | 2015-02-18 | 中国建设银行股份有限公司 | Method and device for customized query |
-
2016
- 2016-12-13 CN CN201611145061.2A patent/CN106777076B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102222110A (en) * | 2011-06-28 | 2011-10-19 | 用友软件股份有限公司 | Data processing device and method |
| CN103902606A (en) * | 2012-12-28 | 2014-07-02 | 腾讯科技（深圳）有限公司 | Data processing method and system of database |
| CN103093000A (en) * | 2013-02-25 | 2013-05-08 | 用友软件股份有限公司 | Database query modeling system and database query modeling method |
| CN103744891A (en) * | 2013-12-23 | 2014-04-23 | 大唐软件技术股份有限公司 | Method and system for data query |
| CN104361040A (en) * | 2014-10-29 | 2015-02-18 | 中国建设银行股份有限公司 | Method and device for customized query |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106777076B (en) | 2020-05-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9317557B2 (en) | Answering relational database queries using graph exploration | |
| CN103761276B (en) | Methods of exhibiting and device that a kind of tree structure data compares | |
| CN109144997A (en) | Data correlation method, device and storage medium | |
| CN102254029B (en) | View-based data access system and method | |
| CN112115276B (en) | Intelligent customer service method, device, equipment and storage medium based on knowledge graph | |
| CN102780574B (en) | The collocation method of the office data of service-oriented, device and check method, device | |
| US11893026B2 (en) | Advanced multiprovider optimization | |
| US20130290292A1 (en) | Augmented Query Optimization by Data Flow Graph Model Optimizer | |
| CN110532280A (en) | SQL statement method for visualizing and device | |
| CN109906447A (en) | The affairs for the index key being not present in management requested database system | |
| Sarma et al. | Uncertainty in data integration and dataspace support platforms | |
| CN109597877A (en) | A kind of knowledge-based reasoning method and device | |
| CN108776678A (en) | Index creation method and device based on mobile terminal NoSQL databases | |
| CN107133243A (en) | A kind of data processing method and server | |
| US10831784B2 (en) | Integration of relational calculation views into a relational engine | |
| CN106445913A (en) | MapReduce-based semantic inference method and system | |
| Lipp et al. | Local editing of procedural models | |
| CN103617265B (en) | A kind of ontology query engine based on ontology semantic information optimizes system | |
| CN109918369A (en) | Date storage method and device | |
| WO2023278154A1 (en) | Apparatus and method for transforming unstructured data sources into both relational entities and machine learning models that support structured query language queries | |
| CN110175202A (en) | The method and system of the outer connection of table for database | |
| Silvescu et al. | Graph databases | |
| CN109344169A (en) | Data processing method and device | |
| CN109376546A (en) | Data packet auditing method, system, device and storage medium based on global rule | |
| CN107766519A (en) | A kind of method of visual configuration data structure |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20210119 Address after: 518000 Room 201, building A, No. 1, Qian Wan Road, Qianhai Shenzhen Hong Kong cooperation zone, Shenzhen, Guangdong (Shenzhen Qianhai business secretary Co., Ltd.) Patentee after: SHENZHEN JINFU TECHNOLOGY Co.,Ltd. Patentee after: GUANGDONG KAMFU TECHNOLOGY Co.,Ltd. Address before: 528200 area 4, 3rd floor, building 5, area a, Hantian science and Technology City, No.17, Guicheng Shenhai Road, Nanhai District, Foshan City, Guangdong Province Patentee before: GUANGDONG KAMFU TECHNOLOGY Co.,Ltd. |
|
| TR01 | Transfer of patent right | ||
| EE01 | Entry into force of recordation of patent licensing contract |
Application publication date: 20170531 Assignee: Guangdong Yaoda Financial Leasing Co.,Ltd. Assignor: GUANGDONG KAMFU TECHNOLOGY Co.,Ltd. Contract record no.: X2021980004499 Denomination of invention: A method of generating SQL restricted query clause and combinational logic filter Granted publication date: 20200505 License type: Exclusive License Record date: 20210608 |
|
| EE01 | Entry into force of recordation of patent licensing contract | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: A method of generating SQL restricted query clause and combinational logic filter Effective date of registration: 20210609 Granted publication date: 20200505 Pledgee: Guangdong Yaoda Financial Leasing Co.,Ltd. Pledgor: GUANGDONG KAMFU TECHNOLOGY Co.,Ltd. Registration number: Y2021980004556 |
|
| PE01 | Entry into force of the registration of the contract for pledge of patent right | ||
| PC01 | Cancellation of the registration of the contract for pledge of patent right |
Granted publication date: 20200505 Pledgee: Guangdong Yaoda Financial Leasing Co.,Ltd. Pledgor: GUANGDONG KAMFU TECHNOLOGY Co.,Ltd. Registration number: Y2021980004556 |
|
| PC01 | Cancellation of the registration of the contract for pledge of patent right | ||
| EC01 | Cancellation of recordation of patent licensing contract |
Assignee: Guangdong Yaoda Financial Leasing Co.,Ltd. Assignor: GUANGDONG KAMFU TECHNOLOGY Co.,Ltd. Contract record no.: X2021980004499 Date of cancellation: 20240809 |
|
| EC01 | Cancellation of recordation of patent licensing contract |