Access plan for a database query
AssigneeInternational Business Machines Corporation
InventorsAdam D. Braham, Andrew P. Passe
Life of this patent
Estimating the term…
Abstract
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.
Claims7
A system for creating an access plan for a database query, the system comprising:
- a memory;
- and
- a processor configured to:
- execute an analytics engine;
- execute a query optimizer, the 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, and
- a 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;
- and
- execute an interfacing module that is configured to:
- transmit, to an analytics engine, data from the table of the database,
- transmit, to the analytics engine for natural language processing, a specific query related to data from the table of the database,
- resolve, by the analytics engine using natural language processing, the specific query, wherein resolving the specific query includes comparing a corpus and data from the table of the database, and
- determine, by the analytics engine in response to resolving the specific query, the first statistical value for the column.
Dependencies are inferred from the claim text.