CN113448967A - 一种对数据库操作进行加速的方法和装置 - Google Patents
一种对数据库操作进行加速的方法和装置 Download PDFInfo
- Publication number
- CN113448967A CN113448967A CN202110818910.0A CN202110818910A CN113448967A CN 113448967 A CN113448967 A CN 113448967A CN 202110818910 A CN202110818910 A CN 202110818910A CN 113448967 A CN113448967 A CN 113448967A
- Authority
- CN
- China
- Prior art keywords
- execution
- hardware accelerator
- plan tree
- execution plan
- database
- 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
- 238000000034 method Methods 0.000 title claims abstract description 36
- 230000001133 acceleration Effects 0.000 claims abstract description 84
- 238000012545 processing Methods 0.000 claims abstract description 30
- 230000008520 organization Effects 0.000 claims abstract description 25
- 238000013507 mapping Methods 0.000 claims description 48
- 230000006870 function Effects 0.000 claims description 40
- 230000009471 action Effects 0.000 claims description 16
- 238000005457 optimization Methods 0.000 claims description 16
- 238000010606 normalization Methods 0.000 claims description 15
- 238000007781 pre-processing Methods 0.000 claims description 3
- 238000010586 diagram Methods 0.000 description 15
- 238000011161 development Methods 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 239000000835 fiber Substances 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000009466 transformation Effects 0.000 description 2
- 239000002699 waste material Substances 0.000 description 2
- 230000002776 aggregation Effects 0.000 description 1
- 238000004220 aggregation Methods 0.000 description 1
- 238000013473 artificial intelligence Methods 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000014509 gene expression Effects 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
- 230000002093 peripheral effect Effects 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 239000004065 semiconductor Substances 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
- G06F16/2246—Trees, e.g. B+trees
-
- 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/2365—Ensuring data consistency and integrity
-
- 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
- G06F16/24534—Query rewriting; Transformation
- G06F16/24542—Plan optimisation
-
- 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/2455—Query execution
- G06F16/24552—Database cache management
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Operations Research (AREA)
- Computer Security & Cryptography (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (10)
Priority Applications (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202110818910.0A CN113448967B (zh) | 2021-07-20 | 2021-07-20 | 一种对数据库操作进行加速的方法和装置 |
US18/267,215 US20240045868A1 (en) | 2021-07-20 | 2021-11-18 | Method and device for accelerating database operation |
PCT/CN2021/131504 WO2023000561A1 (zh) | 2021-07-20 | 2021-11-18 | 一种对数据库操作进行加速的方法和装置 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202110818910.0A CN113448967B (zh) | 2021-07-20 | 2021-07-20 | 一种对数据库操作进行加速的方法和装置 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN113448967A true CN113448967A (zh) | 2021-09-28 |
CN113448967B CN113448967B (zh) | 2022-02-08 |
Family
ID=77816840
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202110818910.0A Active CN113448967B (zh) | 2021-07-20 | 2021-07-20 | 一种对数据库操作进行加速的方法和装置 |
Country Status (3)
Country | Link |
---|---|
US (1) | US20240045868A1 (zh) |
CN (1) | CN113448967B (zh) |
WO (1) | WO2023000561A1 (zh) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2023000561A1 (zh) * | 2021-07-20 | 2023-01-26 | 威讯柏睿数据科技(北京)有限公司 | 一种对数据库操作进行加速的方法和装置 |
Citations (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20080189252A1 (en) * | 2006-08-25 | 2008-08-07 | Jeremy Branscome | Hardware accelerated reconfigurable processor for accelerating database operations and queries |
CN102436494A (zh) * | 2011-11-11 | 2012-05-02 | 中国工商银行股份有限公司 | 基于实践检验的执行计划优化的装置及方法 |
US20120117027A1 (en) * | 2010-06-29 | 2012-05-10 | Teradata Us, Inc. | Methods and systems for hardware acceleration of database operations and queries for a versioned database based on multiple hardware accelerators |
US20140032509A1 (en) * | 2012-07-24 | 2014-01-30 | International Business Machines Corporation | Accelerated row decompression |
CN104346433A (zh) * | 2013-08-07 | 2015-02-11 | 国际商业机器公司 | 用于数据库查询操作的可缩放加速的方法和系统 |
CN106991116A (zh) * | 2017-02-10 | 2017-07-28 | 阿里巴巴集团控股有限公司 | 数据库执行计划的优化方法和装置 |
CN107690622A (zh) * | 2016-08-26 | 2018-02-13 | 华为技术有限公司 | 实现硬件加速处理的方法、设备和系统 |
CN108038215A (zh) * | 2017-12-22 | 2018-05-15 | 上海达梦数据库有限公司 | 数据处理方法及系统 |
CN110688393A (zh) * | 2019-09-29 | 2020-01-14 | 星环信息科技(上海)有限公司 | 查询语句优化方法、装置、计算机设备及存储介质 |
CN111026776A (zh) * | 2019-11-06 | 2020-04-17 | 中科驭数(北京)科技有限公司 | 关系型数据库中的查询方法及装置 |
CN111625585A (zh) * | 2020-05-22 | 2020-09-04 | 中科驭数(北京)科技有限公司 | 硬件加速数据库的访问方法、装置、主机及存储介质 |
Family Cites Families (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US9424315B2 (en) * | 2007-08-27 | 2016-08-23 | Teradata Us, Inc. | Methods and systems for run-time scheduling database operations that are executed in hardware |
US10120902B2 (en) * | 2014-02-20 | 2018-11-06 | Citus Data Bilgi Islemleri Ticaret A.S. | Apparatus and method for processing distributed relational algebra operators in a distributed database |
CN105677683B (zh) * | 2014-11-21 | 2018-12-14 | 华为技术有限公司 | 批量数据查询方法和装置 |
CN104504018B (zh) * | 2014-12-11 | 2017-09-08 | 浙江大学 | 基于浓密树和自顶向下的大数据实时查询优化方法 |
CN107545015B (zh) * | 2016-06-29 | 2020-12-04 | 华为技术有限公司 | 一种查询故障的处理方法及处理装置 |
US11144548B2 (en) * | 2018-04-24 | 2021-10-12 | Dremio Corporation | Optimized data structures of a relational cache with a learning capability for accelerating query execution by a data system |
US10884795B2 (en) * | 2018-04-26 | 2021-01-05 | International Business Machines Corporation | Dynamic accelerator scheduling and grouping for deep learning jobs in a computing cluster |
US20190392002A1 (en) * | 2018-06-25 | 2019-12-26 | BigStream Solutions, Inc. | Systems and methods for accelerating data operations by utilizing dataflow subgraph templates |
US20200301898A1 (en) * | 2018-06-25 | 2020-09-24 | BigStream Solutions, Inc. | Systems and methods for accelerating data operations by utilizing dataflow subgraph templates |
CN110569257B (zh) * | 2019-09-16 | 2022-04-01 | 上海达梦数据库有限公司 | 数据处理方法、相应装置、设备及存储介质 |
US11275734B2 (en) * | 2020-05-05 | 2022-03-15 | Microsoft Technology Licensing, Llc | Data lake workload optimization through index modeling and recommendation |
CN113448967B (zh) * | 2021-07-20 | 2022-02-08 | 威讯柏睿数据科技(北京)有限公司 | 一种对数据库操作进行加速的方法和装置 |
-
2021
- 2021-07-20 CN CN202110818910.0A patent/CN113448967B/zh active Active
- 2021-11-18 US US18/267,215 patent/US20240045868A1/en active Pending
- 2021-11-18 WO PCT/CN2021/131504 patent/WO2023000561A1/zh active Application Filing
Patent Citations (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20080189252A1 (en) * | 2006-08-25 | 2008-08-07 | Jeremy Branscome | Hardware accelerated reconfigurable processor for accelerating database operations and queries |
US20120117027A1 (en) * | 2010-06-29 | 2012-05-10 | Teradata Us, Inc. | Methods and systems for hardware acceleration of database operations and queries for a versioned database based on multiple hardware accelerators |
CN102436494A (zh) * | 2011-11-11 | 2012-05-02 | 中国工商银行股份有限公司 | 基于实践检验的执行计划优化的装置及方法 |
US20140032509A1 (en) * | 2012-07-24 | 2014-01-30 | International Business Machines Corporation | Accelerated row decompression |
CN104346433A (zh) * | 2013-08-07 | 2015-02-11 | 国际商业机器公司 | 用于数据库查询操作的可缩放加速的方法和系统 |
US20150046428A1 (en) * | 2013-08-07 | 2015-02-12 | International Business Machines Corporation | Scalable acceleration of database query operations |
CN107690622A (zh) * | 2016-08-26 | 2018-02-13 | 华为技术有限公司 | 实现硬件加速处理的方法、设备和系统 |
CN106991116A (zh) * | 2017-02-10 | 2017-07-28 | 阿里巴巴集团控股有限公司 | 数据库执行计划的优化方法和装置 |
CN108038215A (zh) * | 2017-12-22 | 2018-05-15 | 上海达梦数据库有限公司 | 数据处理方法及系统 |
CN110688393A (zh) * | 2019-09-29 | 2020-01-14 | 星环信息科技(上海)有限公司 | 查询语句优化方法、装置、计算机设备及存储介质 |
CN111026776A (zh) * | 2019-11-06 | 2020-04-17 | 中科驭数(北京)科技有限公司 | 关系型数据库中的查询方法及装置 |
CN111625585A (zh) * | 2020-05-22 | 2020-09-04 | 中科驭数(北京)科技有限公司 | 硬件加速数据库的访问方法、装置、主机及存储介质 |
Non-Patent Citations (2)
Title |
---|
SHIN-CHI LAI等: "An efficient DCT-IV-based ECG compression algorithm and its hardware accelerator design", 《IEEE》 * |
苏童等: "基于CAM的数据库查询硬件加速方法", 《信息工程大学学报》 * |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2023000561A1 (zh) * | 2021-07-20 | 2023-01-26 | 威讯柏睿数据科技(北京)有限公司 | 一种对数据库操作进行加速的方法和装置 |
Also Published As
Publication number | Publication date |
---|---|
CN113448967B (zh) | 2022-02-08 |
WO2023000561A1 (zh) | 2023-01-26 |
US20240045868A1 (en) | 2024-02-08 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US8171047B2 (en) | Query execution and optimization utilizing a combining network in a parallel computer system | |
CN107247808B (zh) | 一种分布式NewSQL数据库系统及图片数据查询方法 | |
Li et al. | Hippogriffdb: Balancing i/o and gpu bandwidth in big data analytics | |
US9317554B2 (en) | SQL generation for assert, update and delete relational trees | |
Yan et al. | Blogel: A block-centric framework for distributed computation on real-world graphs | |
KR101621137B1 (ko) | 아파치 하둡을 위한 로우 레이턴시 쿼리 엔진 | |
CN103309958B (zh) | Gpu和cpu混合架构下的olap星型连接查询优化方法 | |
US8229918B2 (en) | Hardware accelerated reconfigurable processor for accelerating database operations and queries | |
US9298774B2 (en) | Changing the compression level of query plans | |
US10127275B2 (en) | Mapping query operations in database systems to hardware based query accelerators | |
WO2021254135A1 (zh) | 任务执行方法及存储设备 | |
CN105808323A (zh) | 一种虚拟机创建方法及系统 | |
CN114138776A (zh) | 图结构和图属性分离设计的方法、系统、装置和介质 | |
CN107562804B (zh) | 数据缓存服务系统及方法、终端 | |
CN108363741B (zh) | 大数据统一接口方法、装置、设备及存储介质 | |
CN113448967B (zh) | 一种对数据库操作进行加速的方法和装置 | |
CN110222410B (zh) | 一种基于Hadoop MapReduce的电磁环境仿真方法 | |
US20240037104A1 (en) | A system and method for hierarchical database operation accelerator | |
CN114443680A (zh) | 数据库管理系统、相关装置、方法和介质 | |
CN116775041B (zh) | 基于流计算和rete算法的实时决策引擎实现方法 | |
CN110781137A (zh) | 分布式系统的目录读取方法、装置、服务器和存储介质 | |
CN111221860A (zh) | 基于大数据的混合查询优化方法及装置 | |
CN112115150A (zh) | 嵌入式内存数据库的数据管理方法、终端设备及介质 | |
US11520781B2 (en) | Efficient bulk loading multiple rows or partitions for a single target table | |
Huang et al. | IObrain: An Intelligent Lightweight I/O Recommendation System based on Decision Tree |
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 | ||
CP03 | Change of name, title or address |
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 503, 5th floor, building 19, Wangjing Dongyuan seventh district, Chaoyang District, Beijing 100102 Patentee before: WEIXUN BORAY DATA TECHNOLOGY (BEIJING) Co.,Ltd. |
|
CP03 | Change of name, title or address | ||
TR01 | Transfer of patent right |
Effective date of registration: 20220620 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: 20210928 Assignee: Beijing birui Data Technology Co.,Ltd. Assignor: Hefei Shenwei Ruisi Information Technology Co.,Ltd. Contract record no.: X2022990000524 Denomination of invention: A method and apparatus for accelerating database operations Granted publication date: 20220208 License type: Common License Record date: 20220819 |
|
EE01 | Entry into force of recordation of patent licensing contract |