CN114185934B - 一种基于天盾数据库列存储的索引及查询方法及*** - Google Patents
一种基于天盾数据库列存储的索引及查询方法及*** Download PDFInfo
- Publication number
- CN114185934B CN114185934B CN202111534161.5A CN202111534161A CN114185934B CN 114185934 B CN114185934 B CN 114185934B CN 202111534161 A CN202111534161 A CN 202111534161A CN 114185934 B CN114185934 B CN 114185934B
- Authority
- CN
- China
- Prior art keywords
- data
- database
- data file
- storage
- local
- 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 28
- 238000012163 sequencing technique Methods 0.000 claims abstract description 11
- 238000007781 pre-processing Methods 0.000 claims abstract description 4
- 230000006835 compression Effects 0.000 claims description 12
- 238000007906 compression Methods 0.000 claims description 12
- 230000005540 biological transmission Effects 0.000 claims description 6
- 238000000638 solvent extraction Methods 0.000 claims description 6
- 238000013459 approach Methods 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000004590 computer program Methods 0.000 description 2
- 238000013507 mapping Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
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/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2474—Sequence data queries, e.g. querying versioned data
-
- 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
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (9)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202111534161.5A CN114185934B (zh) | 2021-12-15 | 2021-12-15 | 一种基于天盾数据库列存储的索引及查询方法及*** |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202111534161.5A CN114185934B (zh) | 2021-12-15 | 2021-12-15 | 一种基于天盾数据库列存储的索引及查询方法及*** |
Publications (2)
Publication Number | Publication Date |
---|---|
CN114185934A CN114185934A (zh) | 2022-03-15 |
CN114185934B true CN114185934B (zh) | 2022-10-14 |
Family
ID=80543928
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202111534161.5A Active CN114185934B (zh) | 2021-12-15 | 2021-12-15 | 一种基于天盾数据库列存储的索引及查询方法及*** |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN114185934B (zh) |
Families Citing this family (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN116009775B (zh) * | 2022-12-20 | 2024-04-02 | 广州辰创科技发展有限公司 | 一种数据库内存管理***及方法 |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102156714A (zh) * | 2011-03-22 | 2011-08-17 | 清华大学 | 实现自适应垂直划分的关系型数据库的方法及*** |
CN107077480A (zh) * | 2014-09-17 | 2017-08-18 | 华为技术有限公司 | 基于查询需求自适应地从当前时间的行存储数据库中构建列存储数据库的方法和*** |
Family Cites Families (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP4076415B2 (ja) * | 2002-09-19 | 2008-04-16 | 富士通株式会社 | 検索方法、検索装置、及びコンピュータプログラム |
CN101727465B (zh) * | 2008-11-03 | 2011-12-21 | ***通信集团公司 | 分布式列存储数据库索引建立、查询方法及装置与*** |
CN101751406B (zh) * | 2008-12-18 | 2012-01-04 | 赵伟 | 一种实现基于列存储的关系型数据库的方法及装置 |
US8468146B2 (en) * | 2010-04-13 | 2013-06-18 | Infosys Limited | System and method for creating search index on cloud database |
CN102890721B (zh) * | 2012-10-16 | 2016-03-30 | 苏州迈科网络安全技术股份有限公司 | 基于列存储技术的数据库建立方法及*** |
CN105468642A (zh) * | 2014-09-09 | 2016-04-06 | 杭州海康威视数字技术股份有限公司 | 数据的存储方法及装置 |
CN104881481B (zh) * | 2015-06-03 | 2018-05-01 | 广东省机电设备招标有限公司 | 一种存取海量时间序列数据的方法及装置 |
CN108427748A (zh) * | 2018-03-12 | 2018-08-21 | 北京奇艺世纪科技有限公司 | 分布式数据库二级索引查询方法、装置以及服务器 |
KR20190134115A (ko) * | 2018-05-25 | 2019-12-04 | 주식회사 티맥스데이터 | 효율적인 인덱싱을 제공하기 위한 방법, 장치 및 컴퓨터-판독가능 매체에 포함된 컴퓨터 프로그램 |
CN109086456B (zh) * | 2018-08-31 | 2020-11-03 | 中国联合网络通信集团有限公司 | 数据索引方法及装置 |
CN111078705A (zh) * | 2019-12-20 | 2020-04-28 | 南京聚力云成电子科技有限公司 | 基于Spark平台建立数据索引方法及数据查询方法 |
-
2021
- 2021-12-15 CN CN202111534161.5A patent/CN114185934B/zh active Active
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102156714A (zh) * | 2011-03-22 | 2011-08-17 | 清华大学 | 实现自适应垂直划分的关系型数据库的方法及*** |
CN107077480A (zh) * | 2014-09-17 | 2017-08-18 | 华为技术有限公司 | 基于查询需求自适应地从当前时间的行存储数据库中构建列存储数据库的方法和*** |
Also Published As
Publication number | Publication date |
---|---|
CN114185934A (zh) | 2022-03-15 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US5560006A (en) | Entity-relation database | |
US5809494A (en) | Method for rapidly and efficiently hashing records of large databases | |
CA2941074C (en) | Managing storage of individually accessible data units | |
US6049804A (en) | Method and apparatus for segmenting a database | |
US5813000A (en) | B tree structure and method | |
US7689574B2 (en) | Index and method for extending and querying index | |
JP5342958B2 (ja) | 圧縮データの構造を問い合わせる方法 | |
CN107491487B (zh) | 一种全文数据库架构及位图索引创建、数据查询方法、服务器及介质 | |
US7263520B2 (en) | Fast aggregation of compressed data using full table scans | |
CN103218365A (zh) | 一种SSTable文件数据处理方法及其*** | |
US5742809A (en) | Database generic composite structure processing system | |
CN114185934B (zh) | 一种基于天盾数据库列存储的索引及查询方法及*** | |
EP0583108B1 (en) | Entity-relation database | |
US20200278980A1 (en) | Database processing apparatus, group map file generating method, and recording medium | |
CN111259017B (zh) | 订单检索方法、计算机设备和存储介质 | |
CN113157692B (zh) | 一种关系型内存数据库*** | |
US7870138B2 (en) | File storage and retrieval method | |
CN114564501A (zh) | 一种数据库数据存储、查询方法、装置、设备及介质 | |
CN114416741A (zh) | 基于多级索引的kv数据写入读取方法、装置及存储介质 | |
WO2006105206A2 (en) | On-line organization of data sets | |
CN104765656A (zh) | 一种冷数据的备份方法及装置 | |
CN104834664A (zh) | 面向光盘库的全文检索*** | |
CN117290390B (zh) | 一种基于特殊索引内存映射在大数据检索上的方法 | |
CN115809268B (zh) | 一种基于分片索引的自适应查询方法和装置 | |
US20240193142A1 (en) | Method of processing data in a database |
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: 20231009 Address after: 300000 Tianjin Binhai New Area Tianjin Pilot Free Trade Zone (Dongjiang Bonded Port Area), No. 6975 Asia Road, Financial and Trade Center South Zone, 1-1-2019 Patentee after: Haitong Hengxin International Finance Leasing (Tianjin) Co.,Ltd. Address before: 510640 0601, building 07, No. 235, Gaotang Road, Tianhe District, Guangzhou City, Guangdong Province (only for office use, not for plant) Patentee before: GUANGZHOU CHENCHUANG TECHNOLOGY DEVELOPMENT Co.,Ltd. |
|
TR01 | Transfer of patent right | ||
EE01 | Entry into force of recordation of patent licensing contract |
Application publication date: 20220315 Assignee: GUANGZHOU CHENCHUANG TECHNOLOGY DEVELOPMENT Co.,Ltd. Assignor: Haitong Hengxin International Finance Leasing (Tianjin) Co.,Ltd. Contract record no.: X2024980000618 Denomination of invention: A method and system for indexing and querying based on column storage in the Tiandun database Granted publication date: 20221014 License type: Exclusive License Record date: 20240112 |
|
EE01 | Entry into force of recordation of patent licensing contract |