Making estimations or predictions about databases based on data trends

摘要

Data trends that are based on historical data of a database can be used to make estimations and/or predications about the database. In other words, historical trends of a database can be used to make estimation about the data of the database. By way of example, a prediction can be made regarding the data change in the data since the Statistics has been collected. An estimation about data in a database can be used instead of actual data that would have to be collected as Statistics for the database. As a result, Statistics can be collected less frequently but estimation and/or predictions about the database can be used to optimize the execution of queries of the database. Also, collection of Statistics for database can be altered by using estimation about the Statistics of the database by collecting Statistics less frequently or for longer periods of time.