CN102687124A - 分析查询优化器性能的设备和方法 - Google Patents
分析查询优化器性能的设备和方法 Download PDFInfo
- Publication number
- CN102687124A CN102687124A CN201080059390XA CN201080059390A CN102687124A CN 102687124 A CN102687124 A CN 102687124A CN 201080059390X A CN201080059390X A CN 201080059390XA CN 201080059390 A CN201080059390 A CN 201080059390A CN 102687124 A CN102687124 A CN 102687124A
- Authority
- CN
- China
- Prior art keywords
- analysis
- executable instruction
- query
- optimizer
- analyze
- 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
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
-
- 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/0703—Error or fault processing not based on redundancy, i.e. by taking additional measures to deal with the error or fault not making use of redundancy in operation, in hardware, or in data representation
- G06F11/0706—Error or fault processing not based on redundancy, i.e. by taking additional measures to deal with the error or fault not making use of redundancy in operation, in hardware, or in data representation the processing taking place on a specific hardware platform or in a specific software environment
- G06F11/0709—Error or fault processing not based on redundancy, i.e. by taking additional measures to deal with the error or fault not making use of redundancy in operation, in hardware, or in data representation the processing taking place on a specific hardware platform or in a specific software environment in a distributed system consisting of a plurality of standalone computer nodes, e.g. clusters, client-server systems
-
- 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/0703—Error or fault processing not based on redundancy, i.e. by taking additional measures to deal with the error or fault not making use of redundancy in operation, in hardware, or in data representation
- G06F11/0766—Error or fault reporting or storing
- G06F11/0775—Content or structure details of the error report, e.g. specific table structure, specific error fields
-
- 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/0703—Error or fault processing not based on redundancy, i.e. by taking additional measures to deal with the error or fault not making use of redundancy in operation, in hardware, or in data representation
- G06F11/0766—Error or fault reporting or storing
- G06F11/0778—Dumping, i.e. gathering error/state information after a fault for later diagnosis
-
- 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/0703—Error or fault processing not based on redundancy, i.e. by taking additional measures to deal with the error or fault not making use of redundancy in operation, in hardware, or in data representation
- G06F11/0766—Error or fault reporting or storing
- G06F11/0784—Routing of error reports, e.g. with a specific transmission path or data flow
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3466—Performance evaluation by tracing or monitoring
- G06F11/3476—Data logging
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Preventing errors by testing or debugging software
- G06F11/362—Software debugging
- G06F11/366—Software debugging using diagnostics
-
- 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/21—Design, administration or maintenance of databases
- G06F16/217—Database tuning
-
- 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/24537—Query rewriting; Transformation of operators
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3409—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment for performance assessment
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/86—Event-based monitoring
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Quality & Reliability (AREA)
- Databases & Information Systems (AREA)
- Computer Hardware Design (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Health & Medical Sciences (AREA)
- Biomedical Technology (AREA)
- Computer Networks & Wireless Communication (AREA)
- Operations Research (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Debugging And Monitoring (AREA)
Abstract
Description
Claims (18)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510468387.8A CN105138597B (zh) | 2009-12-13 | 2010-12-13 | 分析查询优化器性能的设备和方法 |
Applications Claiming Priority (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US12/646,716 | 2009-12-23 | ||
US12/646,716 US8818991B2 (en) | 2009-12-23 | 2009-12-23 | Apparatus and method for analyzing query optimizer performance |
PCT/US2010/060154 WO2011078986A1 (en) | 2009-12-23 | 2010-12-13 | Apparatus and method for analyzing query optimizer performance |
Related Child Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510468387.8A Division CN105138597B (zh) | 2009-12-13 | 2010-12-13 | 分析查询优化器性能的设备和方法 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN102687124A true CN102687124A (zh) | 2012-09-19 |
CN102687124B CN102687124B (zh) | 2015-09-02 |
Family
ID=44152518
Family Applications (2)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510468387.8A Active CN105138597B (zh) | 2009-12-13 | 2010-12-13 | 分析查询优化器性能的设备和方法 |
CN201080059390.XA Active CN102687124B (zh) | 2009-12-13 | 2010-12-13 | 分析查询优化器性能的设备和方法 |
Family Applications Before (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510468387.8A Active CN105138597B (zh) | 2009-12-13 | 2010-12-13 | 分析查询优化器性能的设备和方法 |
Country Status (4)
Country | Link |
---|---|
US (2) | US8818991B2 (zh) |
EP (1) | EP2517108B1 (zh) |
CN (2) | CN105138597B (zh) |
WO (1) | WO2011078986A1 (zh) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108255477A (zh) * | 2018-01-15 | 2018-07-06 | 贵州易鲸捷信息技术有限公司 | 一种通过sql编译器模拟优化数据库性能的方法及系统 |
CN109690524A (zh) * | 2016-09-15 | 2019-04-26 | 甲骨文国际公司 | 分布式事件处理系统中的数据序列化 |
CN113168147A (zh) * | 2018-12-29 | 2021-07-23 | 阿里巴巴集团控股有限公司 | 使用硬件加速高效地扫描数据库的系统和方法 |
Families Citing this family (23)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8473484B2 (en) * | 2011-06-01 | 2013-06-25 | International Business Machines Corporation | Identifying impact of installing a database patch |
US9350733B2 (en) * | 2011-11-07 | 2016-05-24 | International Business Machines Corporation | Emergency server access for offline users |
US8938444B2 (en) * | 2011-12-29 | 2015-01-20 | Teradata Us, Inc. | Techniques for external application-directed data partitioning in data exporting from a database management system |
US9081898B1 (en) * | 2012-06-29 | 2015-07-14 | Emc Corporation | Automatic capture of minimal portable executable bug repros |
US9110949B2 (en) * | 2013-02-11 | 2015-08-18 | Oracle International Corporation | Generating estimates for query optimization |
US9471545B2 (en) | 2013-02-11 | 2016-10-18 | Oracle International Corporation | Approximating value densities |
US9135280B2 (en) | 2013-02-11 | 2015-09-15 | Oracle International Corporation | Grouping interdependent fields |
US9262457B2 (en) * | 2013-08-13 | 2016-02-16 | Sybase, Inc. | On-demand hash index |
WO2015167466A1 (en) * | 2014-04-29 | 2015-11-05 | Hewlett-Packard Development Company, L.P. | Query plan post optimization analysis and reoptimization |
WO2016003427A1 (en) * | 2014-06-30 | 2016-01-07 | Hewlett-Packard Development Company, Lp | Automatic generation of sub-queries |
US11016946B1 (en) * | 2015-03-31 | 2021-05-25 | EMC IP Holding Company LLC | Method and apparatus for processing object metadata |
US10318491B1 (en) * | 2015-03-31 | 2019-06-11 | EMC IP Holding Company LLC | Object metadata query with distributed processing systems |
US9418088B1 (en) | 2015-12-02 | 2016-08-16 | International Business Machines Corporation | Identification of storage system elements causing performance degradation |
CN106126402B (zh) * | 2016-06-14 | 2019-06-04 | 网易(杭州)网络有限公司 | 加速器异常的处理方法及装置 |
CN109313639B (zh) * | 2016-12-06 | 2021-03-05 | 华为技术有限公司 | Dbms中进行查询执行的系统和方法 |
US10671578B2 (en) | 2016-12-15 | 2020-06-02 | International Business Machines Corporation | System and method for dynamically estimating data classification job progress and execution time |
CN107844425A (zh) * | 2017-11-16 | 2018-03-27 | 中国银行股份有限公司 | 一种数据库语句检查方法和装置 |
CN108519949A (zh) * | 2018-04-12 | 2018-09-11 | 郑州云海信息技术有限公司 | 一种oracle数据库压力的测试方法、系统及装置 |
CN108763536B (zh) | 2018-05-31 | 2020-04-14 | 阿里巴巴集团控股有限公司 | 数据库访问方法及装置 |
CN109032912B (zh) * | 2018-07-25 | 2022-04-05 | 北京首汽智行科技有限公司 | 车载终端固件升级的压力测试方法 |
US11500837B1 (en) * | 2019-12-11 | 2022-11-15 | Amazon Technologies, Inc. | Automating optimizations for items in a hierarchical data store |
US11372860B2 (en) * | 2019-12-26 | 2022-06-28 | Snowflake Inc. | Processing techniques for queries where predicate values are unknown until runtime |
US10769150B1 (en) | 2019-12-26 | 2020-09-08 | Snowflake Inc. | Pruning indexes to enhance database query processing |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1670729A (zh) * | 2004-03-18 | 2005-09-21 | 微软公司 | 使用隐含谓词的改善的查询优化器 |
CN1825305A (zh) * | 2005-10-31 | 2006-08-30 | 北京神舟航天软件技术有限公司 | 基于谓词关键度分析的查询计划缓存方法及其系统 |
US20080059492A1 (en) * | 2006-08-31 | 2008-03-06 | Tarin Stephen A | Systems, methods, and storage structures for cached databases |
US20090100004A1 (en) * | 2007-10-11 | 2009-04-16 | Sybase, Inc. | System And Methodology For Automatic Tuning Of Database Query Optimizer |
Family Cites Families (23)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US4829427A (en) * | 1984-05-25 | 1989-05-09 | Data General Corporation | Database query code generation and optimization based on the cost of alternate access methods |
US6615222B2 (en) * | 1999-09-22 | 2003-09-02 | International Business Machines Corporation | System and process for evaluating the performance of a database system |
US7139749B2 (en) * | 2002-03-19 | 2006-11-21 | International Business Machines Corporation | Method, system, and program for performance tuning a database query |
US8161037B2 (en) * | 2004-06-03 | 2012-04-17 | International Business Machines Corporation | Method for autonomically generating a query implementation that meets a defined performance specification |
US7606791B2 (en) * | 2004-06-03 | 2009-10-20 | International Business Machines Corporation | Internal parameters (parameters aging) in an abstract query |
US7822741B2 (en) * | 2004-06-21 | 2010-10-26 | Microsoft Corporation | API for programmatic retrieval and replay of database trace |
US8010337B2 (en) | 2004-09-22 | 2011-08-30 | Microsoft Corporation | Predicting database system performance |
US8468152B2 (en) * | 2005-08-04 | 2013-06-18 | International Business Machines Corporation | Autonomic refresh of a materialized query table in a computer database |
GB0516400D0 (en) * | 2005-08-10 | 2005-09-14 | Ibm | A method and apparatus for testing software |
US20070061289A1 (en) | 2005-09-09 | 2007-03-15 | Douglas Brown | Validator and method for managing database system performance |
US7519527B2 (en) | 2005-10-31 | 2009-04-14 | International Business Machines Corporation | Method for a database workload simulator |
US20080005281A1 (en) | 2006-06-29 | 2008-01-03 | Microsoft Corporation | Error capture and reporting in a distributed computing environment |
US8452756B2 (en) * | 2006-11-09 | 2013-05-28 | International Business Machines Corporation | Database execution detail repository |
US8032573B2 (en) * | 2007-06-10 | 2011-10-04 | Philippe Richard | System and method for managing and updating data from a number of sources for a project |
US20090083215A1 (en) * | 2007-09-21 | 2009-03-26 | Louis Burger | System, method, and computer-readable medium for automated selection of sampling usage in a database system |
US7958114B2 (en) * | 2008-04-04 | 2011-06-07 | Microsoft Corporation | Detecting estimation errors in dictinct page counts |
US7937385B2 (en) | 2008-05-05 | 2011-05-03 | International Business Machines Corporation | Obtaining a plan for executing a query in a relational database |
US8352458B2 (en) * | 2008-05-07 | 2013-01-08 | Oracle International Corporation | Techniques for transforming and loading data into a fact table in a data warehouse |
US8190598B2 (en) * | 2008-10-30 | 2012-05-29 | Hewlett-Packard Development Company, L.P. | Skew-based costing for database queries |
US20100306188A1 (en) * | 2009-06-01 | 2010-12-02 | Microsoft Corporation | Persistent query plans |
US20100325124A1 (en) * | 2009-06-17 | 2010-12-23 | Sybase, Inc. | Tuning query execution performance of a database system |
US8732163B2 (en) * | 2009-08-04 | 2014-05-20 | Sybase, Inc. | Query optimization with memory I/O awareness |
US9953054B2 (en) * | 2013-04-22 | 2018-04-24 | Salesforce.Com, Inc. | Systems and methods for implementing and maintaining sampled tables in a database system |
-
2009
- 2009-12-23 US US12/646,716 patent/US8818991B2/en active Active
-
2010
- 2010-12-13 EP EP10839989.0A patent/EP2517108B1/en active Active
- 2010-12-13 CN CN201510468387.8A patent/CN105138597B/zh active Active
- 2010-12-13 CN CN201080059390.XA patent/CN102687124B/zh active Active
- 2010-12-13 WO PCT/US2010/060154 patent/WO2011078986A1/en active Application Filing
-
2014
- 2014-08-22 US US14/466,070 patent/US9275107B2/en active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1670729A (zh) * | 2004-03-18 | 2005-09-21 | 微软公司 | 使用隐含谓词的改善的查询优化器 |
CN1825305A (zh) * | 2005-10-31 | 2006-08-30 | 北京神舟航天软件技术有限公司 | 基于谓词关键度分析的查询计划缓存方法及其系统 |
US20080059492A1 (en) * | 2006-08-31 | 2008-03-06 | Tarin Stephen A | Systems, methods, and storage structures for cached databases |
US20090100004A1 (en) * | 2007-10-11 | 2009-04-16 | Sybase, Inc. | System And Methodology For Automatic Tuning Of Database Query Optimizer |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109690524A (zh) * | 2016-09-15 | 2019-04-26 | 甲骨文国际公司 | 分布式事件处理系统中的数据序列化 |
US11573965B2 (en) | 2016-09-15 | 2023-02-07 | Oracle International Corporation | Data partitioning and parallelism in a distributed event processing system |
US11657056B2 (en) | 2016-09-15 | 2023-05-23 | Oracle International Corporation | Data serialization in a distributed event processing system |
US11977549B2 (en) | 2016-09-15 | 2024-05-07 | Oracle International Corporation | Clustering event processing engines |
CN108255477A (zh) * | 2018-01-15 | 2018-07-06 | 贵州易鲸捷信息技术有限公司 | 一种通过sql编译器模拟优化数据库性能的方法及系统 |
CN113168147A (zh) * | 2018-12-29 | 2021-07-23 | 阿里巴巴集团控股有限公司 | 使用硬件加速高效地扫描数据库的系统和方法 |
Also Published As
Publication number | Publication date |
---|---|
US9275107B2 (en) | 2016-03-01 |
US20110153594A1 (en) | 2011-06-23 |
US8818991B2 (en) | 2014-08-26 |
CN105138597B (zh) | 2018-12-11 |
CN105138597A (zh) | 2015-12-09 |
EP2517108B1 (en) | 2020-02-05 |
EP2517108A1 (en) | 2012-10-31 |
CN102687124B (zh) | 2015-09-02 |
US20150081667A1 (en) | 2015-03-19 |
EP2517108A4 (en) | 2014-03-12 |
WO2011078986A1 (en) | 2011-06-30 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN102687124B (zh) | 分析查询优化器性能的设备和方法 | |
US11379348B2 (en) | System and method for performing automated API tests | |
US20200019494A1 (en) | Method and apparatus for performing test by using test case | |
US8473916B2 (en) | Method and system for providing a testing framework | |
US20190361686A1 (en) | Methods, systems, apparatuses and devices for facilitating change impact analysis (cia) using modular program dependency graphs | |
US10282197B2 (en) | Open application lifecycle management framework | |
US9430505B2 (en) | Automated data warehouse migration | |
US8386419B2 (en) | Data extraction and testing method and system | |
US9563538B2 (en) | Code path tracking | |
KR101083488B1 (ko) | 객체 모델의 영향 분석 | |
US8065323B2 (en) | Offline validation of data in a database system for foreign key constraints | |
US7933932B2 (en) | Statistics based database population | |
US20120124081A1 (en) | Method and system for providing data migration | |
CN107665171A (zh) | 自动回归测试方法及装置 | |
CN105144080A (zh) | 用于元数据管理的系统 | |
US11487742B2 (en) | Consistency checks between database systems | |
US6915313B2 (en) | Deploying predefined data warehouse process models | |
Fjällid | A comparative study of databases for storing sensor data | |
CN113626423B (zh) | 业务数据库的日志管理方法、装置、系统 | |
Che | Optimisation of the OTCM Application through Cloud Database Migration and Refactoring | |
CN116362230A (zh) | 参数校验方法、装置、计算机设备可存储介质 | |
CN117171129A (zh) | 数据处理方法、装置、电子设备及计算机可读存储介质 | |
CN115981639A (zh) | 基于元框架的数据定义与关系的孪生建模方法 | |
CN118069479A (zh) | 一种sql语句的性能评价方法、装置、设备及存储介质 | |
CN116361135A (zh) | 记录操作日志的方法、计算机设备及存储介质 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
ASS | Succession or assignment of patent right |
Owner name: GO BIWEITUO COMPANY Free format text: FORMER OWNER: EMC CORPORATION Effective date: 20141201 |
|
C41 | Transfer of patent application or patent right or utility model | ||
C53 | Correction of patent of invention or patent application | ||
CB02 | Change of applicant information |
Address after: California, USA Applicant after: Pivotal Software, Inc. Address before: California, USA Applicant before: Go Bi Weituo Co. |
|
COR | Change of bibliographic data |
Free format text: CORRECT: APPLICANT; FROM: GO BIWEITUO COMPANY TO: BIWEITUO SOFTWARE INC. |
|
TA01 | Transfer of patent application right |
Effective date of registration: 20141201 Address after: California, USA Applicant after: Go Bi Weituo Co. Address before: Massachusetts, USA Applicant before: EMC Corp. |
|
C14 | Grant of patent or utility model | ||
GR01 | Patent grant |