CN114185934B - Indexing and query method and system based on Tiandun database column storage - Google Patents
Indexing and query method and system based on Tiandun database column storage 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 (en) | 2021-12-15 | 2021-12-15 | Indexing and query method and system based on Tiandun database column storage |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202111534161.5A CN114185934B (en) | 2021-12-15 | 2021-12-15 | Indexing and query method and system based on Tiandun database column storage |
Publications (2)
Publication Number | Publication Date |
---|---|
CN114185934A CN114185934A (en) | 2022-03-15 |
CN114185934B true CN114185934B (en) | 2022-10-14 |
Family
ID=80543928
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202111534161.5A Active CN114185934B (en) | 2021-12-15 | 2021-12-15 | Indexing and query method and system based on Tiandun database column storage |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN114185934B (en) |
Families Citing this family (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN116009775B (en) * | 2022-12-20 | 2024-04-02 | 广州辰创科技发展有限公司 | Database memory management system and method |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102156714A (en) * | 2011-03-22 | 2011-08-17 | 清华大学 | Method for realizing self-adaptive vertical divided relational database and system thereof |
CN107077480A (en) * | 2014-09-17 | 2017-08-18 | 华为技术有限公司 | The method and system of column storage database is adaptively built from the row data storage storehouse of current time based on query demand |
Family Cites Families (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP4076415B2 (en) * | 2002-09-19 | 2008-04-16 | 富士通株式会社 | SEARCH METHOD, SEARCH DEVICE, AND COMPUTER PROGRAM |
CN101727465B (en) * | 2008-11-03 | 2011-12-21 | 中国移动通信集团公司 | Methods for establishing and inquiring index of distributed column storage database, device and system thereof |
CN101751406B (en) * | 2008-12-18 | 2012-01-04 | 赵伟 | Method and device for realizing column storage based relational database |
US8468146B2 (en) * | 2010-04-13 | 2013-06-18 | Infosys Limited | System and method for creating search index on cloud database |
CN102890721B (en) * | 2012-10-16 | 2016-03-30 | 苏州迈科网络安全技术股份有限公司 | Based on database building method and the system of row memory technology |
CN105468642A (en) * | 2014-09-09 | 2016-04-06 | 杭州海康威视数字技术股份有限公司 | Data storage method and apparatus |
CN104881481B (en) * | 2015-06-03 | 2018-05-01 | 广东省机电设备招标有限公司 | A kind of method and device for accessing magnanimity time series data |
CN108427748A (en) * | 2018-03-12 | 2018-08-21 | 北京奇艺世纪科技有限公司 | Distributed data base secondary index querying method, device and server |
KR20190134115A (en) * | 2018-05-25 | 2019-12-04 | 주식회사 티맥스데이터 | Method and apparatus for providing efficient indexing and computer program included in computer readable medium therefor |
CN109086456B (en) * | 2018-08-31 | 2020-11-03 | 中国联合网络通信集团有限公司 | Data indexing method and device |
CN111078705A (en) * | 2019-12-20 | 2020-04-28 | 南京聚力云成电子科技有限公司 | Spark platform based data index establishing method and data query method |
-
2021
- 2021-12-15 CN CN202111534161.5A patent/CN114185934B/en active Active
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102156714A (en) * | 2011-03-22 | 2011-08-17 | 清华大学 | Method for realizing self-adaptive vertical divided relational database and system thereof |
CN107077480A (en) * | 2014-09-17 | 2017-08-18 | 华为技术有限公司 | The method and system of column storage database is adaptively built from the row data storage storehouse of current time based on query demand |
Also Published As
Publication number | Publication date |
---|---|
CN114185934A (en) | 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 (en) | How to query the structure of compressed data | |
US7263520B2 (en) | Fast aggregation of compressed data using full table scans | |
CN110162525B (en) | B+ tree-based read-write conflict resolution method, device and storage medium | |
CN103218365A (en) | SS Table file data processing method and system | |
US5742809A (en) | Database generic composite structure processing system | |
CN114185934B (en) | Indexing and query method and system based on Tiandun database column storage | |
EP0583108B1 (en) | Entity-relation database | |
US20200278980A1 (en) | Database processing apparatus, group map file generating method, and recording medium | |
CN111259017B (en) | Order retrieval method, computer device, and storage medium | |
CN113157692B (en) | Relational memory database system | |
US7870138B2 (en) | File storage and retrieval method | |
CN102567544A (en) | Database query method and database query device | |
US20060230054A1 (en) | On-line organization of data sets | |
CN114564501A (en) | Database data storage and query methods, devices, equipment and medium | |
CN104765656A (en) | Backup method and device for cold data | |
CN104834664A (en) | Optical disc juke-box oriented full text retrieval system | |
CN117290390B (en) | Method for memory mapping on big data retrieval based on special index | |
CN115809268B (en) | Adaptive query method and device based on fragment index | |
CN115827653B (en) | Pure column type updating method and device for HTAP and mass data |
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 |