DATABASE STATISTICAL HISTOGRAM FORECASTING

摘要

A method and system for forecasting a histogram in a database system is provided. The method includes determining that database table (408) statistics and historical statistical histograms associated with specified subject matter have been previously retrieved. The database table (408) statistics and historical statistical histograms are retrieved and determined to be frequency based histograms. Historical target values associated with the historical statistical histograms are identified and new target values associated with the historical target values are identified. A value identifying a number of occurrences for identified target values comprising the new target values and the historical target values is forecast and database table (408) histograms comprising the identified target values are stored.