CN106991116B - 数据库执行计划的优化方法和装置 - Google Patents
数据库执行计划的优化方法和装置 Download PDFInfo
- Publication number
- CN106991116B CN106991116B CN201710074396.8A CN201710074396A CN106991116B CN 106991116 B CN106991116 B CN 106991116B CN 201710074396 A CN201710074396 A CN 201710074396A CN 106991116 B CN106991116 B CN 106991116B
- Authority
- CN
- China
- Prior art keywords
- execution plan
- materialization
- tree
- late
- original
- 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
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/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 (8)
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 CN106991116A (zh) | 2017-07-28 |
CN106991116B true 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) |
Families Citing this family (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110858203A (zh) * | 2018-08-07 | 2020-03-03 | 阿里巴巴集团控股有限公司 | 向量化处理数据的方法及装置 |
CN113448967B (zh) * | 2021-07-20 | 2022-02-08 | 威讯柏睿数据科技(北京)有限公司 | 一种对数据库操作进行加速的方法和装置 |
CN115705322A (zh) * | 2021-08-13 | 2023-02-17 | 华为技术有限公司 | 一种数据库管理系统、数据处理方法及设备 |
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 |
---|
《Materialized View Selection for a Data Warehouse Using》;Mohammad Karim Sohrabi;《Journal of Computers》;20160331;第11卷(第2期);140-148 * |
《数据库物理结构优化技术》;崔跃生等;《软件学报》;20130117;第24卷(第4期);761-780 * |
Also Published As
Publication number | Publication date |
---|---|
CN106991116A (zh) | 2017-07-28 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US10817258B2 (en) | Clustering storage method and apparatus | |
CN110321344B (zh) | 关联数据的信息查询方法、装置、计算机设备及存储介质 | |
CN107301214B (zh) | 在hive中数据迁移方法、装置及终端设备 | |
US8108367B2 (en) | Constraints with hidden rows in a database | |
CN104714972B (zh) | 数据库分表建立及查询方法 | |
WO2017096892A1 (zh) | 索引构建方法、查询方法及对应装置、设备、计算机存储介质 | |
US11687546B2 (en) | Executing conditions with negation operators in analytical databases | |
JP2016532173A (ja) | 意味情報、キーワード拡張及びそれに関するキーワード検索の方法及びシステム | |
US10706077B2 (en) | Performance of distributed databases and database-dependent software applications | |
US9218394B2 (en) | Reading rows from memory prior to reading rows from secondary storage | |
CN109791543B (zh) | 执行多表连接操作的控制方法及对应装置 | |
CN109947804B (zh) | 数据集合查询的优化方法、装置、服务器和存储介质 | |
CN106991116B (zh) | 数据库执行计划的优化方法和装置 | |
US20200342029A1 (en) | Systems and methods for querying databases using interactive search paths | |
KR20160053933A (ko) | 스마트 검색 정제 기법 | |
US20130198218A1 (en) | Database Table Partitioning Allowing Overlaps Used in Full Text Query | |
CN110168532A (zh) | 数据更新方法和存储装置 | |
CN112883030A (zh) | 数据收集方法、装置、计算机设备和存储介质 | |
CN113918605A (zh) | 数据查询方法、装置、设备以及计算机存储介质 | |
TW201926081A (zh) | 資料轉移系統及方法 | |
CN110874366B (zh) | 数据处理、查询方法和装置 | |
US9430528B2 (en) | Grid queries | |
CN114428776A (zh) | 一种面向时序数据的索引分区管理方法和系统 | |
WO2023086322A1 (en) | Late materialization of queried data in database cache | |
US11157506B2 (en) | Multiform persistence abstraction |
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. |