CN106874332B - 数据库访问方法和装置 - Google Patents
数据库访问方法和装置 Download PDFInfo
- Publication number
- CN106874332B CN106874332B CN201610653819.7A CN201610653819A CN106874332B CN 106874332 B CN106874332 B CN 106874332B CN 201610653819 A CN201610653819 A CN 201610653819A CN 106874332 B CN106874332 B CN 106874332B
- Authority
- CN
- China
- Prior art keywords
- execution result
- predicate
- execution
- predicates
- updating
- 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.)
- Active
Links
Images
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/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
-
- 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/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
- G06F16/24537—Query rewriting; Transformation of operators
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
- G06F16/24542—Plan optimisation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Operations Research (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
采样行 | 谓词1 | 谓词2 | 谓词3 | … | 谓词n |
行1 | T | F | F | … | F |
行2 | T | T | T | … | F |
… | … | … | … | … | … |
行9 | T | T | F | … | T |
Claims (12)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610653819.7A CN106874332B (zh) | 2016-08-10 | 2016-08-10 | 数据库访问方法和装置 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610653819.7A CN106874332B (zh) | 2016-08-10 | 2016-08-10 | 数据库访问方法和装置 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN106874332A CN106874332A (zh) | 2017-06-20 |
CN106874332B true CN106874332B (zh) | 2020-06-30 |
Family
ID=59238909
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610653819.7A Active CN106874332B (zh) | 2016-08-10 | 2016-08-10 | 数据库访问方法和装置 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106874332B (zh) |
Families Citing this family (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107506380B (zh) * | 2017-07-21 | 2019-03-26 | 北京金堤科技有限公司 | 一种更新企业数据的方法及服务器 |
CN107908791A (zh) * | 2017-12-12 | 2018-04-13 | 郑州云海信息技术有限公司 | 分布式存储***中数据缓存方法、装置、设备及存储介质 |
CN113626491B (zh) * | 2020-05-09 | 2023-08-04 | 杭州海康威视数字技术股份有限公司 | 一种数据查询方法、装置、分布式数据查询*** |
CN115827930B (zh) * | 2023-02-15 | 2023-05-05 | 杭州悦数科技有限公司 | 一种图数据库的数据查询优化方法、***和装置 |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101105802A (zh) * | 2007-06-08 | 2008-01-16 | 北京神舟航天软件技术有限公司 | 用基于小波的压缩直方图实现二维谓词选择率估计的方法 |
WO2009069882A1 (en) * | 2007-11-29 | 2009-06-04 | Electronics And Telecommunications Research Institute | Sensor network managing apparatus and method thereof |
CN102663114A (zh) * | 2012-04-17 | 2012-09-12 | 中国人民大学 | 面向并发olap的数据库查询处理方法 |
CN104216891A (zh) * | 2013-05-30 | 2014-12-17 | 国际商业机器公司 | 关系型数据库中的查询语句的优化方法和设备 |
US9262457B2 (en) * | 2013-08-13 | 2016-02-16 | Sybase, Inc. | On-demand hash index |
-
2016
- 2016-08-10 CN CN201610653819.7A patent/CN106874332B/zh active Active
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101105802A (zh) * | 2007-06-08 | 2008-01-16 | 北京神舟航天软件技术有限公司 | 用基于小波的压缩直方图实现二维谓词选择率估计的方法 |
WO2009069882A1 (en) * | 2007-11-29 | 2009-06-04 | Electronics And Telecommunications Research Institute | Sensor network managing apparatus and method thereof |
CN102663114A (zh) * | 2012-04-17 | 2012-09-12 | 中国人民大学 | 面向并发olap的数据库查询处理方法 |
CN104216891A (zh) * | 2013-05-30 | 2014-12-17 | 国际商业机器公司 | 关系型数据库中的查询语句的优化方法和设备 |
US9262457B2 (en) * | 2013-08-13 | 2016-02-16 | Sybase, Inc. | On-demand hash index |
Also Published As
Publication number | Publication date |
---|---|
CN106874332A (zh) | 2017-06-20 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107391692B (zh) | 一种推荐效果的评估方法及装置 | |
US9152691B2 (en) | System and method for performing set operations with defined sketch accuracy distribution | |
CN106874332B (zh) | 数据库访问方法和装置 | |
US20210319006A1 (en) | Method And System To Estimate The Cardinality Of Sets And Set Operation Results From Single And Multiple HyperLogLog Sketches | |
US8560509B2 (en) | Incremental computing for web search | |
CN109948036B (zh) | 一种分词词项权重的计算方法和装置 | |
EP2946527A2 (en) | Variable duration windows on continuous data streams | |
US20150234883A1 (en) | Method and system for retrieving real-time information | |
US11640382B2 (en) | Optimizing database performance through intelligent data partitioning orchestration | |
US10255325B2 (en) | Extreme value computation | |
CN113986933A (zh) | 物化视图的创建方法、装置、存储介质及电子设备 | |
WO2018149085A1 (zh) | 数据库***优化的方法、***、电子装置及存储介质 | |
CN110968802B (zh) | 一种用户特征的分析方法、分析装置及可读存储介质 | |
JP5367632B2 (ja) | 知識量推定装置及びプログラム | |
CN111737555A (zh) | 热点关键词的选取方法、设备和存储介质 | |
CN114661568A (zh) | 异常操作行为检测方法、装置、设备及存储介质 | |
CN111488736A (zh) | 自学习分词方法、装置、计算机设备和存储介质 | |
CN114238389A (zh) | 数据库查询优化方法、装置、电子设备、介质和程序产品 | |
CN110674387A (zh) | 用于数据搜索的方法、装置和计算机存储介质 | |
Sidney et al. | Performance prediction for set similarity joins | |
WO2018205391A1 (zh) | 信息检索准确性评估方法、***、装置及计算机可读存储介质 | |
CN110442616B (zh) | 一种针对大数据量的页面访问路径分析方法与*** | |
CN110569268A (zh) | 数据查询方法、***及计算机可读存储介质 | |
CN109213922B (zh) | 一种对搜索结果排序的方法和装置 | |
CN111382342A (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 | ||
TR01 | Transfer of patent right |
Effective date of registration: 20200921 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Patentee after: Innovative advanced technology Co.,Ltd. Address before: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Patentee before: Advanced innovation technology Co.,Ltd. Effective date of registration: 20200921 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Patentee after: Advanced innovation technology Co.,Ltd. Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands Patentee before: Alibaba Group Holding Ltd. |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20210210 Address after: 801-10, Section B, 8th floor, 556 Xixi Road, Xihu District, Hangzhou City, Zhejiang Province 310000 Patentee after: Ant financial (Hangzhou) Network Technology Co.,Ltd. Address before: Ky1-9008 Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands, ky1-9008 Patentee before: Innovative advanced technology Co.,Ltd. |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20210908 Address after: 100020 unit 02, 901, floor 9, unit 1, building 1, No.1, East Third Ring Middle Road, Chaoyang District, Beijing Patentee after: Beijing Aoxing Beisi Technology Co.,Ltd. Address before: 801-10, Section B, 8th floor, 556 Xixi Road, Xihu District, Hangzhou City, Zhejiang Province 310000 Patentee before: Ant financial (Hangzhou) Network Technology Co.,Ltd. |