Method and device for reading data based on data cache

Abstract

The invention discloses a method and a device for reading data based on data cache. The method comprises the steps of: receiving read access request information (of a user) for obtaining data input, and extracting a generated key word; determining a data key value corresponding to a key word which is not subjected to cache generation in a cache databank, and initializing a mark value of data to be obtained; or determining a data key value corresponding to a key word which is subjected to cache generation in the cache databank, wherein the data included in the cached data key value is invalid, and setting the mark value of the data to be obtained as the mark value included in the obtained data key value; reading and checking a sub-bank of the databank so as to obtain data corresponding to the generated key word; obtaining time stamp information of the sub-bank of the databank, setting data key value information of key value pairs according to the set mark of the data to be obtained, the read time stamp information of the sub-bank of the databank and the data to be obtained, and updating the cache databank; and outputting the data obtained through checking. With the adoption of the method and the device, the cache efficiency of the data is improved, and the comprehensive property in data cache is optimized.

Description

technical field [0001] The invention relates to cache database technology, in particular to a method for reading data based on data cache. Background technique [0002] In today's information society, database technology and software have been widely used in various business units. For example, banking system, taxation system, ticketing system, financial system, personnel system, etc. In the web era, caching database technology is currently the only feasible solution for managing vast technical data such as user information, product information, and social information. [0003] However, when the amount of data in the database containing technical information is calculated in units of T and P, disk IO, that is, the application program accessing the physical data source becomes an insurmountable gap in database access efficiency. On the one hand, it is necessary to use a database to store large amounts of technical information; on the other hand, inefficient disk IO operation...

AI Technical Summary

Problems solved by technology

[0007] However, once the database reads and writes frequently, because the database master database and the database slave database cannot be updated synchronously in real time, the inconsistency between the database master database and the database slave database will often occur, and the inconsistent time is highly dependent on the server load (setting The cached data is valid for a certain period of time) and cannot be measured, so that the phenomenon of inconsistency between the cached data and the physical data in the database often occurs; further, within the validity period of the cached data, or before the next write access to the inconsistent data in the database main library , the data obtained by the user accessing the cache database through the cache mechanism is inconsistent with the data written in the database main database, and the consistency is poor; and if the cache data expiration time is set shorter, although the data consistency can be improved, but Due to the frequent failure of data in the cache database, the cache hit rate is reduced, which affects the efficiency of the cache.

Images