Database statistical histogram forecasting

A database system comprising a memory and a computer processor coupled to said memory, said memory comprising instructions that when executed by the computer processor implement a histogram forecasting method comprising:

• determining, by said computer processor, that a plurality of database table statistics and historical statistical histograms associated with specified subject matter have been previously retrieved, wherein said historical statistical histograms comprise frequency based histograms;
• retrieving, by said computer processor from a historical statistical histogram database, said plurality of database table statistics and said historical statistical histograms associated with said specified subject matter;
• determining, by said computer processor, that said historical statistical histograms comprise frequency based histograms;
• identifying, by said computer processor, historical target values associated with said historical statistical histograms;
• forecasting, by said computer processor, new target values associated with said historical target values;
• forecasting, by said computer processor, a value identifying a number of occurrences for identified target values comprising said new target values and said historical target values;
• and
• storing, by said computer processor within said database system, database table histograms comprising said identified target values;
• and
• executing, by said computer processor based on said database table histograms comprising said identified target values, a database partition scan providing accurate feedback to a data mining algorithm being executed for allocating optimized storage space of said database system with respect to partitions of said database system.

A computer program product, comprising a computer readable hardware storage device storing a computer readable program code, said computer readable program code comprising an algorithm that when executed by a computer processor of a database system server implements a histogram forecasting method, said method comprising:

• determining, by said computer processor, that a plurality of database table statistics and historical statistical histograms associated with specified subject matter have been previously retrieved;
• retrieving, by said computer processor from a historical statistical histogram database, said plurality of database table statistics and said historical statistical histograms associated with said specified subject matter;
• determining, by said computer processor, that said historical statistical histograms comprise frequency based histograms;
• identifying, by said computer processor, historical target values associated with said historical statistical histograms;
• forecasting, by said computer processor, new target values associated with said historical target values;
• forecasting, by said computer processor, a value identifying a number of occurrences for identified target values comprising said new target values and said historical target values;
• and
• storing, by said computer processor within said database system, database table histograms comprising said identified target values;
• and
• executing, by said computer processor based on said database table histograms comprising said identified target values, a database partition scan providing accurate feedback to a data mining algorithm being executed for allocating optimized storage space of said database system with respect to partitions of said database system.