Invention Grant
- Patent Title: Estimating error propagation for database optimizers
- Patent Title (中): 估计数据库优化器的错误传播
-
Application No.: US13843657Application Date: 2013-03-15
-
Publication No.: US09251213B2Publication Date: 2016-02-02
- Inventor: Harpreet Singh
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Patterson & Sheridan, LLP
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Techniques are disclosed to determine error propagation for a query optimizer component of a database management system for a database. A database query is received that specifies one or more query conditions. Measures of actual and estimated selectivity of the one or more query conditions are determined. A measure of estimated deviation between the measures of actual and estimated selectivity is determined. A query execution plan is generated or selected based on the measure of estimated deviation.
Public/Granted literature
- US20140280280A1 ESTIMATING ERROR PROPAGATION FOR DATABASE OPTIMIZERS Public/Granted day:2014-09-18
Information query