CN106991116A - 数据库执行计划的优化方法和装置 - Google Patents
数据库执行计划的优化方法和装置 Download PDFInfo
- Publication number
- CN106991116A CN106991116A CN201710074396.8A CN201710074396A CN106991116A CN 106991116 A CN106991116 A CN 106991116A CN 201710074396 A CN201710074396 A CN 201710074396A CN 106991116 A CN106991116 A CN 106991116A
- Authority
- CN
- China
- Prior art keywords
- materialization
- attribute
- plan
- late period
- original execution
- 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
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/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
- G06F16/24542—Plan optimisation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Operations Research (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (10)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710074396.8A CN106991116B (zh) | 2017-02-10 | 2017-02-10 | 数据库执行计划的优化方法和装置 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710074396.8A CN106991116B (zh) | 2017-02-10 | 2017-02-10 | 数据库执行计划的优化方法和装置 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN106991116A true CN106991116A (zh) | 2017-07-28 |
CN106991116B CN106991116B (zh) | 2020-04-14 |
Family
ID=59414413
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710074396.8A Active CN106991116B (zh) | 2017-02-10 | 2017-02-10 | 数据库执行计划的优化方法和装置 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106991116B (zh) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110858203A (zh) * | 2018-08-07 | 2020-03-03 | 阿里巴巴集团控股有限公司 | 向量化处理数据的方法及装置 |
CN113448967A (zh) * | 2021-07-20 | 2021-09-28 | 威讯柏睿数据科技(北京)有限公司 | 一种对数据库操作进行加速的方法和装置 |
WO2023016537A1 (zh) * | 2021-08-13 | 2023-02-16 | 华为技术有限公司 | 一种数据库管理系统、数据处理方法及设备 |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7290214B2 (en) * | 2002-12-23 | 2007-10-30 | International Business Machines Corporation | Independent deferred incremental refresh of materialized views |
CN104063486A (zh) * | 2014-07-03 | 2014-09-24 | 四川中亚联邦科技有限公司 | 一种大数据分布式存储方法和系统 |
CN104462479A (zh) * | 2014-12-18 | 2015-03-25 | 杭州华为数字技术有限公司 | 跨节点的晚期物化方法和装置 |
CN104504018A (zh) * | 2014-12-11 | 2015-04-08 | 浙江大学 | 基于浓密树和自顶向下的大数据实时查询优化方法 |
-
2017
- 2017-02-10 CN CN201710074396.8A patent/CN106991116B/zh active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7290214B2 (en) * | 2002-12-23 | 2007-10-30 | International Business Machines Corporation | Independent deferred incremental refresh of materialized views |
CN104063486A (zh) * | 2014-07-03 | 2014-09-24 | 四川中亚联邦科技有限公司 | 一种大数据分布式存储方法和系统 |
CN104504018A (zh) * | 2014-12-11 | 2015-04-08 | 浙江大学 | 基于浓密树和自顶向下的大数据实时查询优化方法 |
CN104462479A (zh) * | 2014-12-18 | 2015-03-25 | 杭州华为数字技术有限公司 | 跨节点的晚期物化方法和装置 |
Non-Patent Citations (2)
Title |
---|
MOHAMMAD KARIM SOHRABI: "《Materialized View Selection for a Data Warehouse Using》", 《JOURNAL OF COMPUTERS》 * |
崔跃生等: "《数据库物理结构优化技术》", 《软件学报》 * |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110858203A (zh) * | 2018-08-07 | 2020-03-03 | 阿里巴巴集团控股有限公司 | 向量化处理数据的方法及装置 |
CN113448967A (zh) * | 2021-07-20 | 2021-09-28 | 威讯柏睿数据科技(北京)有限公司 | 一种对数据库操作进行加速的方法和装置 |
CN113448967B (zh) * | 2021-07-20 | 2022-02-08 | 威讯柏睿数据科技(北京)有限公司 | 一种对数据库操作进行加速的方法和装置 |
WO2023016537A1 (zh) * | 2021-08-13 | 2023-02-16 | 华为技术有限公司 | 一种数据库管理系统、数据处理方法及设备 |
Also Published As
Publication number | Publication date |
---|---|
CN106991116B (zh) | 2020-04-14 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US8108367B2 (en) | Constraints with hidden rows in a database | |
KR101278785B1 (ko) | 파일 시스템 모델의 데이터베이스 객체로의 맵핑을용이하게 하는 시스템 및 방법 | |
US10521460B2 (en) | Filtering data lineage diagrams | |
US9734201B2 (en) | Optimizing parallel queries using interesting distributions | |
CN110741354B (zh) | 呈现代码实体调用之间的差异 | |
US11334474B2 (en) | Fast change impact analysis tool for large-scale software systems | |
US11556534B2 (en) | Subquery predicate generation to reduce processing in a multi-table join | |
US20070156736A1 (en) | Method and apparatus for automatically detecting a latent referential integrity relationship between different tables of a database | |
US10545953B2 (en) | Modern spreadsheet arrays | |
US20070250517A1 (en) | Method and Apparatus for Autonomically Maintaining Latent Auxiliary Database Structures for Use in Executing Database Queries | |
CN112860777B (zh) | 数据处理方法、装置及设备 | |
US10645090B2 (en) | Access control for objects having attributes defined against hierarchically organized domains containing fixed number of values | |
CN110168532A (zh) | 数据更新方法和存储装置 | |
US20240004853A1 (en) | Virtual data source manager of data virtualization-based architecture | |
CN106991116A (zh) | 数据库执行计划的优化方法和装置 | |
CN109885585A (zh) | 支持存储过程、触发器与视图的分布式数据库系统和方法 | |
CN104537012B (zh) | 数据处理方法和装置 | |
CN112970011A (zh) | 记录查询优化中的谱系 | |
US20080082535A1 (en) | Method and system for automatically generating a communication interface | |
US11775517B2 (en) | Query content-based data generation | |
US11847121B2 (en) | Compound predicate query statement transformation | |
US11709814B2 (en) | Building of tries over sorted keys | |
US20200125361A1 (en) | Dynamic modeling for opaque code during static analysis | |
US7979393B2 (en) | Multiphase topology-wide code modifications for peer-to-peer systems | |
US20100131804A1 (en) | Method and apparatus for symmetry reduction in distributed model checking |
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 | ||
TR01 | Transfer of patent right |
Effective date of registration: 20200923 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Patentee after: Innovative advanced technology Co.,Ltd. Address before: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Patentee before: Advanced innovation technology Co.,Ltd. Effective date of registration: 20200923 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Patentee after: Advanced innovation technology Co.,Ltd. Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands Patentee before: Alibaba Group Holding Ltd. |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20210210 Address after: 801-10, Section B, 8th floor, 556 Xixi Road, Xihu District, Hangzhou City, Zhejiang Province 310000 Patentee after: Ant financial (Hangzhou) Network Technology Co.,Ltd. Address before: Ky1-9008 Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands, ky1-9008 Patentee before: Innovative advanced technology Co.,Ltd. |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20210909 Address after: 100020 unit 02, 901, floor 9, unit 1, building 1, No.1, East Third Ring Middle Road, Chaoyang District, Beijing Patentee after: Beijing Aoxing Beisi Technology Co.,Ltd. Address before: 801-10, Section B, 8th floor, 556 Xixi Road, Xihu District, Hangzhou City, Zhejiang Province 310000 Patentee before: Ant financial (Hangzhou) Network Technology Co.,Ltd. |