CN113901069A - 一种分布式数据库的数据存储方法和装置 - Google Patents
一种分布式数据库的数据存储方法和装置 Download PDFInfo
- Publication number
- CN113901069A CN113901069A CN202111488732.6A CN202111488732A CN113901069A CN 113901069 A CN113901069 A CN 113901069A CN 202111488732 A CN202111488732 A CN 202111488732A CN 113901069 A CN113901069 A CN 113901069A
- Authority
- CN
- China
- Prior art keywords
- data
- columns
- copies
- column
- row
- 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.)
- Granted
Links
- 238000013500 data storage Methods 0.000 title claims abstract description 22
- 238000000034 method Methods 0.000 title claims abstract description 19
- 230000008859 change Effects 0.000 claims description 10
- 238000012217 deletion Methods 0.000 claims description 6
- 230000037430 deletion Effects 0.000 claims description 6
- 238000012545 processing Methods 0.000 abstract description 20
- 238000013467 fragmentation Methods 0.000 abstract description 5
- 238000006062 fragmentation reaction Methods 0.000 abstract description 5
- 230000008901 benefit Effects 0.000 abstract description 2
- 238000010586 diagram Methods 0.000 description 10
- 239000011159 matrix material Substances 0.000 description 8
- 230000003993 interaction Effects 0.000 description 2
- 238000011084 recovery Methods 0.000 description 2
- 230000001133 acceleration Effects 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 238000013473 artificial intelligence Methods 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000005192 partition Methods 0.000 description 1
- 230000001681 protective effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012360 testing method 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/23—Updating
- G06F16/2379—Updates performed during online database operations; commit processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
-
- 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/221—Column-oriented storage; Management thereof
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Computing Systems (AREA)
- Software Systems (AREA)
- Quality & Reliability (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (10)
Priority Applications (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202111488732.6A CN113901069B (zh) | 2021-12-08 | 2021-12-08 | 一种分布式数据库的数据存储方法和装置 |
US18/276,361 US12086156B2 (en) | 2021-12-08 | 2022-06-14 | Method and device for storing data in a distributed database |
PCT/CN2022/081884 WO2023103213A1 (zh) | 2021-12-08 | 2022-06-14 | 一种分布式数据库的数据存储方法和装置 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202111488732.6A CN113901069B (zh) | 2021-12-08 | 2021-12-08 | 一种分布式数据库的数据存储方法和装置 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN113901069A true CN113901069A (zh) | 2022-01-07 |
CN113901069B CN113901069B (zh) | 2022-03-15 |
Family
ID=79025651
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202111488732.6A Active CN113901069B (zh) | 2021-12-08 | 2021-12-08 | 一种分布式数据库的数据存储方法和装置 |
Country Status (3)
Country | Link |
---|---|
US (1) | US12086156B2 (zh) |
CN (1) | CN113901069B (zh) |
WO (1) | WO2023103213A1 (zh) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN115964445A (zh) * | 2023-02-23 | 2023-04-14 | 合肥申威睿思信息科技有限公司 | 一种分布式数据库的多副本实现方法和装置 |
WO2023103213A1 (zh) * | 2021-12-08 | 2023-06-15 | 合肥申威睿思信息科技有限公司 | 一种分布式数据库的数据存储方法和装置 |
CN117216068A (zh) * | 2023-11-07 | 2023-12-12 | 本原数据(北京)信息技术有限公司 | 支持数据库混合负载的数据存储方法、装置及存储介质 |
Citations (14)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20150261805A1 (en) * | 2014-03-14 | 2015-09-17 | Juchang Lee | Multi-version concurrency control across row store and column store |
CN105095247A (zh) * | 2014-05-05 | 2015-11-25 | 中国电信股份有限公司 | 符号数据分析方法和系统 |
US20160042019A1 (en) * | 2010-03-08 | 2016-02-11 | Microsoft Technology Licensing, Llc | Columnar Storage of a Database Index |
US20160078079A1 (en) * | 2014-09-17 | 2016-03-17 | Futurewei Technologies, Inc. | Statement based migration for adaptively building and updating a column store database from a row store database based on query demands using disparate database systems |
CN106557494A (zh) * | 2015-09-25 | 2017-04-05 | 北京国双科技有限公司 | 更新列存储表的方法及装置 |
CN106716409A (zh) * | 2014-09-17 | 2017-05-24 | 华为技术有限公司 | 基于查询需求从行存储数据库自适应地构建和更新列存储数据库的方法和系统 |
CN107977285A (zh) * | 2017-12-19 | 2018-05-01 | 郑州云海信息技术有限公司 | 一种纠删码存储机制的数据修改方法、装置及介质 |
CN108959587A (zh) * | 2018-07-10 | 2018-12-07 | 上海达梦数据库有限公司 | 基于列存储的数据更新方法、装置、服务器及存储介质 |
CN110347344A (zh) * | 2019-07-19 | 2019-10-18 | 北京计算机技术及应用研究所 | 一种基于分布式存储系统的自动配置块存储方法 |
CN110515541A (zh) * | 2019-07-29 | 2019-11-29 | 西安交通大学 | 分布式存储中纠删码非对齐数据更新方法 |
CN110618895A (zh) * | 2019-09-29 | 2019-12-27 | 北京天融信网络安全技术有限公司 | 一种基于纠删码的数据更新方法、装置和存储介质 |
CN111625394A (zh) * | 2020-05-27 | 2020-09-04 | 成都信息工程大学 | 基于纠删码的数据恢复方法、装置、设备及存储介质 |
CN112835743A (zh) * | 2021-01-25 | 2021-05-25 | 中央财经大学 | 分布式账本数据存储优化方法、装置、电子设备及介质 |
CN113064919A (zh) * | 2021-03-31 | 2021-07-02 | 北京达佳互联信息技术有限公司 | 数据处理方法、数据存储系统、计算机设备及存储介质 |
Family Cites Families (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101840377A (zh) | 2010-05-13 | 2010-09-22 | 上海交通大学 | 基于rs纠删码的数据存储方法 |
US9836507B2 (en) * | 2014-09-17 | 2017-12-05 | Futurewei Technologies, Inc. | Method and system for adaptively building a column store database from a temporal row store database based on query demands |
US10331384B2 (en) * | 2015-03-31 | 2019-06-25 | International Business Machines Corporation | Storing data utilizing a maximum accessibility approach in a dispersed storage network |
US11669546B2 (en) * | 2015-06-30 | 2023-06-06 | Pure Storage, Inc. | Synchronizing replicated data in a storage network |
WO2022089749A1 (en) * | 2020-10-29 | 2022-05-05 | Telefonaktiebolaget Lm Ericsson (Publ) | Checking state consistency in a log replication configuration |
CN113901069B (zh) * | 2021-12-08 | 2022-03-15 | 威讯柏睿数据科技(北京)有限公司 | 一种分布式数据库的数据存储方法和装置 |
-
2021
- 2021-12-08 CN CN202111488732.6A patent/CN113901069B/zh active Active
-
2022
- 2022-06-14 US US18/276,361 patent/US12086156B2/en active Active
- 2022-06-14 WO PCT/CN2022/081884 patent/WO2023103213A1/zh active Application Filing
Patent Citations (15)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20160042019A1 (en) * | 2010-03-08 | 2016-02-11 | Microsoft Technology Licensing, Llc | Columnar Storage of a Database Index |
US20150261805A1 (en) * | 2014-03-14 | 2015-09-17 | Juchang Lee | Multi-version concurrency control across row store and column store |
CN105095247A (zh) * | 2014-05-05 | 2015-11-25 | 中国电信股份有限公司 | 符号数据分析方法和系统 |
CN107077479A (zh) * | 2014-09-17 | 2017-08-18 | 华为技术有限公司 | 使用分立数据库系统基于查询需求从行存储数据库自适性建立并更新列存储数据库的基于语句的迁移 |
CN106716409A (zh) * | 2014-09-17 | 2017-05-24 | 华为技术有限公司 | 基于查询需求从行存储数据库自适应地构建和更新列存储数据库的方法和系统 |
US20160078079A1 (en) * | 2014-09-17 | 2016-03-17 | Futurewei Technologies, Inc. | Statement based migration for adaptively building and updating a column store database from a row store database based on query demands using disparate database systems |
CN106557494A (zh) * | 2015-09-25 | 2017-04-05 | 北京国双科技有限公司 | 更新列存储表的方法及装置 |
CN107977285A (zh) * | 2017-12-19 | 2018-05-01 | 郑州云海信息技术有限公司 | 一种纠删码存储机制的数据修改方法、装置及介质 |
CN108959587A (zh) * | 2018-07-10 | 2018-12-07 | 上海达梦数据库有限公司 | 基于列存储的数据更新方法、装置、服务器及存储介质 |
CN110347344A (zh) * | 2019-07-19 | 2019-10-18 | 北京计算机技术及应用研究所 | 一种基于分布式存储系统的自动配置块存储方法 |
CN110515541A (zh) * | 2019-07-29 | 2019-11-29 | 西安交通大学 | 分布式存储中纠删码非对齐数据更新方法 |
CN110618895A (zh) * | 2019-09-29 | 2019-12-27 | 北京天融信网络安全技术有限公司 | 一种基于纠删码的数据更新方法、装置和存储介质 |
CN111625394A (zh) * | 2020-05-27 | 2020-09-04 | 成都信息工程大学 | 基于纠删码的数据恢复方法、装置、设备及存储介质 |
CN112835743A (zh) * | 2021-01-25 | 2021-05-25 | 中央财经大学 | 分布式账本数据存储优化方法、装置、电子设备及介质 |
CN113064919A (zh) * | 2021-03-31 | 2021-07-02 | 北京达佳互联信息技术有限公司 | 数据处理方法、数据存储系统、计算机设备及存储介质 |
Non-Patent Citations (3)
Title |
---|
徐晓锦 等: "基于列存储机制下多维数据仓库模型的优化与研究", 《计算机应用与软件》 * |
林轩 等: "GRC:一种适用于多节点失效的高容错低修复成本纠删码", 《计算机研究与发展》 * |
金国栋 等: "HDFS存储和优化技术研究综述", 《软件学报》 * |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2023103213A1 (zh) * | 2021-12-08 | 2023-06-15 | 合肥申威睿思信息科技有限公司 | 一种分布式数据库的数据存储方法和装置 |
US12086156B2 (en) | 2021-12-08 | 2024-09-10 | Hefei Swaychip Information Technology Inc. | Method and device for storing data in a distributed database |
CN115964445A (zh) * | 2023-02-23 | 2023-04-14 | 合肥申威睿思信息科技有限公司 | 一种分布式数据库的多副本实现方法和装置 |
CN115964445B (zh) * | 2023-02-23 | 2024-03-05 | 合肥申威睿思信息科技有限公司 | 一种分布式数据库的多副本实现方法和装置 |
CN117216068A (zh) * | 2023-11-07 | 2023-12-12 | 本原数据(北京)信息技术有限公司 | 支持数据库混合负载的数据存储方法、装置及存储介质 |
Also Published As
Publication number | Publication date |
---|---|
US12086156B2 (en) | 2024-09-10 |
WO2023103213A1 (zh) | 2023-06-15 |
US20240037119A1 (en) | 2024-02-01 |
CN113901069B (zh) | 2022-03-15 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN113901069B (zh) | 一种分布式数据库的数据存储方法和装置 | |
Maity et al. | Robust gradient descent via moment encoding and LDPC codes | |
US10560270B2 (en) | Optimal data storage configuration in a blockchain | |
CN110750382A (zh) | 用于提高数据修复性能的最小存储再生码编码方法及系统 | |
CN104052576B (zh) | 一种云存储下基于纠错码的数据恢复方法 | |
CN113973021B (zh) | 一种图式区块链的网络传输优化装置及方法 | |
US11520778B2 (en) | Merkle tree storage of big data | |
CN106484559A (zh) | 一种校验矩阵的构造方法及水平阵列纠删码的构造方法 | |
CN110427156B (zh) | 一种基于分片的mbr的并行读方法 | |
CN103746774B (zh) | 一种高效数据读取的容错编码方法 | |
CN107003933B (zh) | 部分复制码的构建方法、装置及其数据修复的方法 | |
CN111831223B (zh) | 提高数据去重系统可扩展性的容错编码方法、装置及系统 | |
CN112835738B (zh) | 一种条带数据存储结构的构建方法 | |
CN107357689B (zh) | 一种存储节点的故障处理方法及分布式存储系统 | |
CN110389848B (zh) | 基于分块构造的部分重复码构造方法及故障节点修复方法 | |
CN107153661A (zh) | 一种基于hdfs系统的数据的存储、读取方法及其装置 | |
CN103838649A (zh) | 一种降低二进制编码存储系统中计算量的方法 | |
US20150227425A1 (en) | Method for encoding, data-restructuring and repairing projective self-repairing codes | |
CN105007286A (zh) | 解码方法和装置及云存储方法和系统 | |
CN115686382B (zh) | 一种数据存储及读取方法 | |
Iliadis | Reliability evaluation of erasure coded systems under rebuild bandwidth constraints | |
CN111224747A (zh) | 可降低修复带宽和磁盘读取开销的编码方法及其修复方法 | |
CN116760661A (zh) | 数据存储方法、装置、计算机设备、存储介质和程序产品 | |
CN116303789A (zh) | 多分片多副本数据库并行同步方法、装置及可读介质 | |
Zhao et al. | G-update: A group-based update scheme for heterogenous erasure-coded storage systems |
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 | ||
CP01 | Change in the name or title of a patent holder |
Address after: Room 701, floor 7, building 3, courtyard 6, lizexi street, Chaoyang District, Beijing 100102 Patentee after: Beijing birui Data Technology Co.,Ltd. Address before: Room 701, floor 7, building 3, courtyard 6, lizexi street, Chaoyang District, Beijing 100102 Patentee before: WEIXUN BORAY DATA TECHNOLOGY (BEIJING) Co.,Ltd. |
|
CP01 | Change in the name or title of a patent holder | ||
TR01 | Transfer of patent right |
Effective date of registration: 20220616 Address after: 231283 room 207, building F1, phase II, Hefei Innovation Industrial Park, No. 2800, innovation Avenue, high tech Zone, China (Anhui) pilot Free Trade Zone, Hefei, Anhui Patentee after: Hefei Shenwei Ruisi Information Technology Co.,Ltd. Address before: Room 701, floor 7, building 3, courtyard 6, lizexi street, Chaoyang District, Beijing 100102 Patentee before: Beijing birui Data Technology Co.,Ltd. |
|
TR01 | Transfer of patent right | ||
EE01 | Entry into force of recordation of patent licensing contract |
Application publication date: 20220107 Assignee: Beijing birui Data Technology Co.,Ltd. Assignor: Hefei Shenwei Ruisi Information Technology Co.,Ltd. Contract record no.: X2022990000524 Denomination of invention: Data storage method and device for distributed database Granted publication date: 20220315 License type: Common License Record date: 20220819 |
|
EE01 | Entry into force of recordation of patent licensing contract |