Invention Grant
- Patent Title: Database statistical histogram forecasting
-
Application No.: US16737277Application Date: 2020-01-08
-
Publication No.: US11263213B2Publication Date: 2022-03-01
- Inventor: Felipe G. Bortoletto , Reinaldo T. Katahira , Craig M. Trim
- Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Applicant Address: US NY Armonk
- Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee Address: US NY Armonk
- Agency: Schmeiser, Olsen & Watts
- Agent Nicholas L. Cadmus
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F16/2458

Abstract:
A method and system for forecasting a histogram in a database system is provided. The method includes determining that database table statistics and historical statistical histograms associated with specified subject matter have been previously retrieved. The database table 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 histograms comprising the identified target values are stored.
Information query