CN106777076A - 一种sql限定查询子句生成方法和组合逻辑过滤器 - Google Patents
一种sql限定查询子句生成方法和组合逻辑过滤器 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
Description
Claims (10)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201611145061.2A CN106777076B (zh) | 2016-12-13 | 2016-12-13 | 一种sql限定查询子句生成方法和组合逻辑过滤器 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201611145061.2A CN106777076B (zh) | 2016-12-13 | 2016-12-13 | 一种sql限定查询子句生成方法和组合逻辑过滤器 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN106777076A true CN106777076A (zh) | 2017-05-31 |
CN106777076B CN106777076B (zh) | 2020-05-05 |
Family
ID=58880766
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201611145061.2A Active CN106777076B (zh) | 2016-12-13 | 2016-12-13 | 一种sql限定查询子句生成方法和组合逻辑过滤器 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106777076B (zh) |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102222110A (zh) * | 2011-06-28 | 2011-10-19 | 用友软件股份有限公司 | 数据处理装置和数据处理方法 |
CN103093000A (zh) * | 2013-02-25 | 2013-05-08 | 用友软件股份有限公司 | 数据库查询建模***和数据库查询建模方法 |
CN103744891A (zh) * | 2013-12-23 | 2014-04-23 | 大唐软件技术股份有限公司 | 一种数据查询方法和*** |
CN103902606A (zh) * | 2012-12-28 | 2014-07-02 | 腾讯科技(深圳)有限公司 | 一种数据库的数据处理方法和*** |
CN104361040A (zh) * | 2014-10-29 | 2015-02-18 | 中国建设银行股份有限公司 | 一种定制查询的方法及装置 |
-
2016
- 2016-12-13 CN CN201611145061.2A patent/CN106777076B/zh active Active
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102222110A (zh) * | 2011-06-28 | 2011-10-19 | 用友软件股份有限公司 | 数据处理装置和数据处理方法 |
CN103902606A (zh) * | 2012-12-28 | 2014-07-02 | 腾讯科技(深圳)有限公司 | 一种数据库的数据处理方法和*** |
CN103093000A (zh) * | 2013-02-25 | 2013-05-08 | 用友软件股份有限公司 | 数据库查询建模***和数据库查询建模方法 |
CN103744891A (zh) * | 2013-12-23 | 2014-04-23 | 大唐软件技术股份有限公司 | 一种数据查询方法和*** |
CN104361040A (zh) * | 2014-10-29 | 2015-02-18 | 中国建设银行股份有限公司 | 一种定制查询的方法及装置 |
Also Published As
Publication number | Publication date |
---|---|
CN106777076B (zh) | 2020-05-05 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US9317557B2 (en) | Answering relational database queries using graph exploration | |
CN107545046A (zh) | 一种多源异构数据的融合方法及装置 | |
CN103761276B (zh) | 一种树形结构数据比较的展示方法和装置 | |
CN102254029B (zh) | 一种基于视图的数据访问***及其方法 | |
CN109144997A (zh) | 数据关联方法、装置及存储介质 | |
US20130290292A1 (en) | Augmented Query Optimization by Data Flow Graph Model Optimizer | |
CN108369497B (zh) | 在示例编程中从输入模式中进行学习 | |
CN110532280A (zh) | Sql语句可视化方法以及装置 | |
US11893026B2 (en) | Advanced multiprovider optimization | |
CN109906447A (zh) | 管理请求数据库***中不存在的索引键的事务 | |
Sarma et al. | Uncertainty in data integration and dataspace support platforms | |
CN109597877A (zh) | 一种知识的推理方法及装置 | |
CN108776678A (zh) | 基于移动端NoSQL数据库的索引创建方法及装置 | |
CN112115276A (zh) | 基于知识图谱的智能客服方法、装置、设备及存储介质 | |
CN107133243A (zh) | 一种数据处理方法和服务器 | |
CN106445913A (zh) | 基于MapReduce的语义推理方法及*** | |
CN103617265B (zh) | 一种基于本体语义信息的本体查询引擎优化*** | |
CN106503217B (zh) | 基于业务驱动的数据交互装置及方法 | |
CN109918369A (zh) | 数据存储方法及装置 | |
US10831784B2 (en) | Integration of relational calculation views into a relational engine | |
CN111475511A (zh) | 基于树状结构的数据存储方法、访问方法、装置及设备 | |
CN110175202A (zh) | 用于数据库的表的外连接的方法和*** | |
Silvescu et al. | Graph databases | |
CN109344169A (zh) | 数据处理方法及装置 | |
CN109376546A (zh) | 基于全局规则的数据包审计方法、***、装置及存储介质 |
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 |