发明名称 |
ACCESS PLAN FOR A DATABASE QUERY |
摘要 |
A system and method of creating an access plan for a database query is disclosed. The system and method include identifying a first portion of a column of a table of a database. The first portion of the column may be in a select statement of the database query. The system and method include estimating a first statistical value for the column. The estimating may occur by analyzing a second portion of the column. The system and method include generating the access plan to predict a characteristic of a set of results for the database query. In generating the access plan, the first statistical value for the column may be used. |
申请公布号 |
US2015227585(A1) |
申请公布日期 |
2015.08.13 |
申请号 |
US201414288568 |
申请日期 |
2014.05.28 |
申请人 |
International Business Machines Corporation |
发明人 |
Braham Adam D.;Passe Andrew P. |
分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
1. A system for creating an access plan for a database query, the system comprising:
an analytics engine; and a query optimizer including an access plan module, the access plan module comprising:
an identifying module to identify a first portion of a column of a table of a database in a select statement of the database query;an estimating module to estimate, by analyzing a second portion of the column, a first statistical value for the column; anda generating module to generate, using the first statistical value for the column, the access plan to predict a characteristic of a set of results for the database query. |
地址 |
Armonk NY US |