A database and corresponding method and equipment

Abstract

The purpose of this application is to provide a database and corresponding method and equipment. Compared with the prior art, this application generates the data occurrence time and row identifier corresponding to the data object in the data table when writing the data object into the data table, and stores the data where the data object is located The table identifier of the table and the row identifier of the data object are stored in the global table, and the data entry time corresponding to the row identifier is generated in the global table. Further, by obtaining the specified data occurrence time and the specified data entry time database time, and according to the specified data occurrence time and specified data storage time, query in the data table and the global table respectively, and determine the target data object that matches the specified data occurrence time and specified data storage time. In this way, by distinguishing the data generation time and data storage time, accurate playback of data objects can be achieved even in the case of large database delays.

Description

technical field [0001] This application relates to the field of computer technology, in particular to a database technology. Background technique [0002] In existing databases, the time when the data is stored in the database is generally recorded by recording the time when the data is stored in the database. When analyzing the data by time, the data will be analyzed according to the time when the data is stored in the database. , However, because there is usually a system delay in the database, for example, the camera of the traffic department recorded a traffic accident at eleven o'clock, and it is assumed that this record was transmitted to the database of the management platform at half past eleven. That is, the data storage time is 11:30, because the existing database system only has data storage time, which leads to the inability to achieve accurate playback of data when it is necessary to focus on analyzing traffic accidents at 11:00. [0003] For another example, i...

AI Technical Summary

Problems solved by technology

[0002] In existing databases, the time when the data is stored in the database is generally recorded by recording the time when the data is stored in the database. When analyzing the data by time, the data will be analyzed according to the time when the data is stored in the database. , However, because there is usually a system delay in the database, for example, the camera of the traffic department recorded a traffic accident at eleven o'clock, and it is assumed that this record was transmitted to the database of the management platform at half past eleven. That is, the data storage time is 11:30, because the existing database system only has data storage time, which leads to the inability to achieve accurate playback of data when it is necessary to pay attention to the analysis of traffic accidents at 11:00

[0003] For another example, in the financial industry, the stock market changes rapidly, and a huge price fluctuation occurs at ten o'clock, but due to the delay of the database system, it is only entered into the database at half past ten, and because traders cannot realize the stock price in time Price fluctuations will lead to transaction losses, and then when analyzing, because the existing database system only has data storage time, it is impossible to accurately replay the actual fluctuations of the stock

[0004] Therefore, in the existing database, due to the time delay of data warehousing, it will lead to inconsistency with the actual state of the data during data playback

Images