主权项 |
1. 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, 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; 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, anddetermine, by the analytics engine in response to resolving the specific query, the first statistical value for the column. |