CN103810300B - 用于非索引覆盖的数据查询方法和装置 - Google Patents
用于非索引覆盖的数据查询方法和装置 Download PDFInfo
- Publication number
- CN103810300B CN103810300B CN201410086556.7A CN201410086556A CN103810300B CN 103810300 B CN103810300 B CN 103810300B CN 201410086556 A CN201410086556 A CN 201410086556A CN 103810300 B CN103810300 B CN 103810300B
- Authority
- CN
- China
- Prior art keywords
- index
- nonclustered
- value
- key
- clusters
- 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
- 238000000034 method Methods 0.000 title claims abstract description 37
- 230000002776 aggregation Effects 0.000 claims abstract description 76
- 238000004220 aggregation Methods 0.000 claims abstract description 76
- 239000003016 pheromone Substances 0.000 claims abstract description 72
- 238000003860 storage Methods 0.000 claims description 23
- 238000000605 extraction Methods 0.000 claims description 10
- 239000000284 extract Substances 0.000 claims description 9
- 238000001914 filtration Methods 0.000 claims description 2
- 230000000694 effects Effects 0.000 abstract description 4
- 238000010586 diagram Methods 0.000 description 4
- 230000009471 action Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 238000003780 insertion Methods 0.000 description 3
- 230000037431 insertion Effects 0.000 description 3
- 230000009467 reduction Effects 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 230000008878 coupling Effects 0.000 description 2
- 230000008859 change Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 239000000700 radioactive tracer Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000004148 unit process Methods 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/24—Querying
- G06F16/245—Query processing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (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 |
---|---|---|---|
CN201410086556.7A CN103810300B (zh) | 2014-03-10 | 2014-03-10 | 用于非索引覆盖的数据查询方法和装置 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410086556.7A CN103810300B (zh) | 2014-03-10 | 2014-03-10 | 用于非索引覆盖的数据查询方法和装置 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN103810300A CN103810300A (zh) | 2014-05-21 |
CN103810300B true CN103810300B (zh) | 2017-08-01 |
Family
ID=50707070
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410086556.7A Active CN103810300B (zh) | 2014-03-10 | 2014-03-10 | 用于非索引覆盖的数据查询方法和装置 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN103810300B (zh) |
Families Citing this family (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105574031B (zh) | 2014-10-16 | 2019-01-04 | 国际商业机器公司 | 用于数据库索引的方法和系统 |
CN104408179B (zh) * | 2014-12-15 | 2018-11-06 | 北京国双科技有限公司 | 数据表中数据处理方法和装置 |
CN104392001B (zh) * | 2014-12-15 | 2017-11-14 | 北京国双科技有限公司 | 数据库查询方法和装置 |
CN107346317A (zh) * | 2016-05-06 | 2017-11-14 | 北京神州泰岳软件股份有限公司 | 一种数据查询方法和装置 |
CN106649544A (zh) * | 2016-10-27 | 2017-05-10 | 国家电网公司信息通信分公司 | 一种用电信息数据检索方法及装置 |
CN108268537B (zh) * | 2016-12-30 | 2020-11-06 | 北京国双科技有限公司 | 数据过滤方法及装置 |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2007077097A1 (en) * | 2005-12-30 | 2007-07-12 | International Business Machines Corporation | System and method for managing a hierarchy of databases |
CN101133388A (zh) * | 2005-01-25 | 2008-02-27 | 谷歌公司 | 基于多索引的信息检索系统 |
CN102117305A (zh) * | 2010-01-06 | 2011-07-06 | 中国移动通信集团公司 | 查询数据的系统、方法和数据管理系统 |
CN103348344A (zh) * | 2010-12-30 | 2013-10-09 | 脸谱公司 | 图形数据的复合语句索引 |
-
2014
- 2014-03-10 CN CN201410086556.7A patent/CN103810300B/zh active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101133388A (zh) * | 2005-01-25 | 2008-02-27 | 谷歌公司 | 基于多索引的信息检索系统 |
WO2007077097A1 (en) * | 2005-12-30 | 2007-07-12 | International Business Machines Corporation | System and method for managing a hierarchy of databases |
CN102117305A (zh) * | 2010-01-06 | 2011-07-06 | 中国移动通信集团公司 | 查询数据的系统、方法和数据管理系统 |
CN103348344A (zh) * | 2010-12-30 | 2013-10-09 | 脸谱公司 | 图形数据的复合语句索引 |
Also Published As
Publication number | Publication date |
---|---|
CN103810300A (zh) | 2014-05-21 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN103810300B (zh) | 用于非索引覆盖的数据查询方法和装置 | |
CN102339320B (zh) | 恶意网页的识别方法以及识别装置 | |
US8838608B2 (en) | Virtual R-tree mapped to an extendible-hash based file system | |
CA2484009A1 (en) | Managing expressions in a database system | |
US6389424B1 (en) | Insertion method in a high-dimensional index structure for content-based image retrieval | |
CN104199892B (zh) | 一种基于压缩合并异步更新的索引读写方法 | |
CN106708841B (zh) | 网站访问路径的聚合方法和装置 | |
CN106557499A (zh) | HBase二级索引创建方法和装置 | |
CN104298736A (zh) | 数据集合连接方法、装置及数据库系统 | |
CN104391978A (zh) | 用于浏览器的网页收藏处理方法及装置 | |
CN106649363A (zh) | 数据查询方法及装置 | |
CN108241692A (zh) | 数据的查询方法及装置 | |
CN107147947B (zh) | 关键帧识别方法及装置 | |
CN104933153B (zh) | 一种基于协作的固态盘存储系统性能提高方法 | |
CN106611031A (zh) | 数据查询方法及装置 | |
CN108334549A (zh) | 一种设备数据存储方法、提取方法、存储平台及提取平台 | |
CN106933927A (zh) | 数据表的连接方法和装置 | |
CN106933919A (zh) | 数据表的连接方法及装置 | |
CN104298570B (zh) | 数据处理方法和装置 | |
CN110555219B (zh) | 一种基于图像识别的三维cad模型相似性检索系统及方法 | |
CN107273389A (zh) | 庭审录像的查询方法和装置 | |
CN106933934A (zh) | 数据表的连接方法和装置 | |
CN103870460B (zh) | 一种靓号检索方法及系统 | |
CN115617846A (zh) | 基于大数据和区块链的信息筛选方法及系统 | |
WO2014061846A1 (ko) | 혼합 질의 처리를 위한 색인 생성 방법, 혼합 질의 처리 방법 및 색인 자료구조를 기록한 기록 매체 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: Method and device for inquiring non-index coverage data Effective date of registration: 20190531 Granted publication date: 20170801 Pledgee: Shenzhen Black Horse World Investment Consulting Co.,Ltd. Pledgor: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. Registration number: 2019990000503 |
|
PE01 | Entry into force of the registration of the contract for pledge of patent right | ||
CP02 | Change in the address of a patent holder |
Address after: 100083 No. 401, 4th Floor, Haitai Building, 229 North Fourth Ring Road, Haidian District, Beijing Patentee after: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. Address before: 100086 Beijing city Haidian District Shuangyushu Area No. 76 Zhichun Road cuigongfandian 8 layer A Patentee before: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. |
|
CP02 | Change in the address of a patent holder | ||
PP01 | Preservation of patent right |
Effective date of registration: 20240604 Granted publication date: 20170801 |
|
PP01 | Preservation of patent right |