CN110019192B - 数据库的检索方法及装置 - Google Patents
数据库的检索方法及装置 Download PDFInfo
- Publication number
- CN110019192B CN110019192B CN201710862402.6A CN201710862402A CN110019192B CN 110019192 B CN110019192 B CN 110019192B CN 201710862402 A CN201710862402 A CN 201710862402A CN 110019192 B CN110019192 B CN 110019192B
- Authority
- CN
- China
- Prior art keywords
- index
- database
- value
- query
- data
- 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 41
- 238000001914 filtration Methods 0.000 claims description 80
- 238000012423 maintenance Methods 0.000 claims description 39
- 230000008569 process Effects 0.000 description 6
- 238000010586 diagram Methods 0.000 description 4
- 230000008859 change Effects 0.000 description 3
- 238000010276 construction Methods 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000000694 effects Effects 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 230000001360 synchronised effect Effects 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- 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)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (13)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710862402.6A CN110019192B (zh) | 2017-09-21 | 2017-09-21 | 数据库的检索方法及装置 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710862402.6A CN110019192B (zh) | 2017-09-21 | 2017-09-21 | 数据库的检索方法及装置 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN110019192A CN110019192A (zh) | 2019-07-16 |
CN110019192B true CN110019192B (zh) | 2023-10-31 |
Family
ID=67186347
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710862402.6A Active CN110019192B (zh) | 2017-09-21 | 2017-09-21 | 数据库的检索方法及装置 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110019192B (zh) |
Families Citing this family (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112069175B (zh) * | 2020-08-25 | 2024-03-29 | 北京五八信息技术有限公司 | 数据查询的方法、装置及电子设备 |
CN114416070B (zh) * | 2022-01-25 | 2023-03-24 | 重庆允丰科技有限公司 | 用于可视化配置触发器的节点组件及装置 |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101727465A (zh) * | 2008-11-03 | 2010-06-09 | 中国移动通信集团公司 | 分布式列存储数据库索引建立、查询方法及装置与系统 |
CN104965861A (zh) * | 2015-06-03 | 2015-10-07 | 上海新炬网络信息技术有限公司 | 一种数据访问监控装置 |
CN105975463A (zh) * | 2015-09-25 | 2016-09-28 | 武汉安天信息技术有限责任公司 | 一种基于MapReduce识别优化数据倾斜的方法及系统 |
CN106959963A (zh) * | 2016-01-12 | 2017-07-18 | 杭州海康威视数字技术股份有限公司 | 一种数据查询方法、装置及系统 |
-
2017
- 2017-09-21 CN CN201710862402.6A patent/CN110019192B/zh active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101727465A (zh) * | 2008-11-03 | 2010-06-09 | 中国移动通信集团公司 | 分布式列存储数据库索引建立、查询方法及装置与系统 |
CN104965861A (zh) * | 2015-06-03 | 2015-10-07 | 上海新炬网络信息技术有限公司 | 一种数据访问监控装置 |
CN105975463A (zh) * | 2015-09-25 | 2016-09-28 | 武汉安天信息技术有限责任公司 | 一种基于MapReduce识别优化数据倾斜的方法及系统 |
CN106959963A (zh) * | 2016-01-12 | 2017-07-18 | 杭州海康威视数字技术股份有限公司 | 一种数据查询方法、装置及系统 |
Non-Patent Citations (1)
Title |
---|
笔记-hive分区、桶、倾斜 (/blog/wulili/7747);liliwu;《https://ask.hellobi.com/blog/wulili/7747》;20170427;第1-3页 * |
Also Published As
Publication number | Publication date |
---|---|
CN110019192A (zh) | 2019-07-16 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110019218B (zh) | 数据存储与查询方法及设备 | |
CN107491487B (zh) | 一种全文数据库架构及位图索引创建、数据查询方法、服务器及介质 | |
CN106528787B (zh) | 一种基于海量数据多维分析的查询方法及装置 | |
US8924373B2 (en) | Query plans with parameter markers in place of object identifiers | |
CN106471501B (zh) | 数据查询的方法、数据对象的存储方法和数据系统 | |
CN104133867A (zh) | 分布式顺序表片内二级索引方法及系统 | |
US10552460B2 (en) | Sensor data management apparatus, sensor data management method, and computer program product | |
CN106649412B (zh) | 一种数据处理方法和设备 | |
CN103440245A (zh) | 数据库系统的行列混合存储方法 | |
CN102779138B (zh) | 实时数据的硬盘存取方法 | |
KR20020028208A (ko) | 데이터베이스 오브젝트 통계의 실시간 수집 방법 및 시스템 | |
CN110309233A (zh) | 数据存储的方法、装置、服务器和存储介质 | |
Liu et al. | DGFIndex for smart grid: Enhancing hive with a cost-effective multidimensional range index | |
CN112262379A (zh) | 存储数据项并且标识存储的数据项 | |
WO2015168988A1 (zh) | 一种数据索引创建方法、装置及计算机存储介质 | |
CN110019192B (zh) | 数据库的检索方法及装置 | |
CN116881287A (zh) | 一种数据查询方法及相关设备 | |
WO2020024798A1 (zh) | 一种时序数据的高效存储方法 | |
CN104408128A (zh) | 一种基于b+树异步更新索引的读优化方法 | |
CN114328601A (zh) | 数据降采样和数据查询方法、系统及存储介质 | |
CN111813773B (zh) | 一种电网抄表数据存储方法、上传方法、装置和存储装置 | |
CN110968555B (zh) | 维度数据处理方法和装置 | |
CN111639087A (zh) | 数据库中数据更新方法、装置和电子设备 | |
JP6904724B2 (ja) | 地図データベース作成装置及び地図データベース作成方法並びに地図データベース作成プログラム | |
CN108460067B (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 | ||
REG | Reference to a national code |
Ref country code: HK Ref legal event code: DE Ref document number: 40010958 Country of ref document: HK |
|
TA01 | Transfer of patent application right | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20210926 Address after: Room 508, floor 5, building 4, No. 699, Wangshang Road, Changhe street, Binjiang District, Hangzhou City, Zhejiang Province Applicant after: Alibaba (China) Co.,Ltd. Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands Applicant before: ALIBABA GROUP HOLDING Ltd. |
|
TA01 | Transfer of patent application right | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20211209 Address after: No.12 Zhuantang science and technology economic block, Xihu District, Hangzhou City, Zhejiang Province Applicant after: Aliyun Computing Co.,Ltd. Address before: 310052 room 508, 5th floor, building 4, No. 699 Wangshang Road, Changhe street, Binjiang District, Hangzhou City, Zhejiang Province Applicant before: Alibaba (China) Co.,Ltd. |
|
GR01 | Patent grant | ||
GR01 | Patent grant |