Method and device for improving reliability of statistic information of data object in database

Abstract

The invention discloses a method and a device for improving the reliability of statistic information of a data object in a database. The method comprises the following steps of: receiving the data object, acquiring the absolute change amount and the relative change amount of the data object according to the received data object information and prestored data object information and storing the received data object and a data object name; judging whether the accumulated absolute change amount and the relative change amount of the data object exceed the preset change amount threshold of the data object, if so, calling the preset analysis strategy, reliably scanning the data object stored in the database and acquiring the data object having the same name as the stored data object name; and calling the analysis program to process the acquired data object and acquiring the statistic information of the data object and upgrading a system base table of the stored statistic information of the data object. By applying the invention, the maintenance cost of the database can be reduced and the query hit rate of the statistic information of the data object in the database can be improved.

Description

technical field [0001] The invention relates to database technology, in particular to a method and device for improving the reliability of statistical information of data objects in a database. Background technique [0002] The current database, whether used for data warehouse or operational data storage, contains a wealth of massive data object information. Therefore, on the one hand, it is a huge challenge to find and display the information users need in a timely manner. On the other hand, from massive data The reliability of the information found in the information search (database query quality) is also important for the user as well as for the database operator. The following takes the widely used oracle database as an example to briefly introduce the query process. [0003] figure 1 It is a schematic diagram of the execution flow of a Structured Query Language (SQL, Structured Query Language) statement in an existing oracle database, see figure 1 , the process incl...

AI Technical Summary

Problems solved by technology

However, with the rapid development of information technology, the amount of business data and information that the oracle database system needs to process is becoming larger and larger, the structural design of the application oracle database system is becoming more and more complex, and the scale of the oracle database is also increasing day by day. Standards such as the absolute change of business data set by the difference in the business logic of the data object. If the absolute change of the preset business data is small, frequent updates are required, which consumes a lot of system resources and high maintenance costs; if the preset business data The absolute amount of change is large. When the oracle database changes, for example, adding new data objects to the oracle database, or operating the data objects in the original oracle database so that the corresponding data object statistical information changes, this At this time, due to the inability to update the system base table in time, it is easy to cause information omissions and incorrect indexes. The oracle database queries the information input by the user based on the unupdated system base table, the query hit rate is low, and the statistical information of data objects is reliable. performance is low, increasing the time required for querying

Images