Database data access method, system and device and readable storage medium of computer

Abstract

The invention discloses a database data access method, system and device and a readable storage medium of a computer. The method includes the following steps that a target row data recording corresponding to a access request is searched in a target data queue in a distributed type cache; the target row data recording is searched, and according to the access request and a target row data recordingblock corresponding to the target row data recording, a temporary index mark array of an index mark number corresponding to the access request is generated and stored; the temporary index mark array is compared with a target index mark array, and a comparison result is obtained; according to the comparison result, data in the distributed type cache and a database are synchronized. According to themethod, high-accessibility data is pre-cached in the distributed type cache, the row data is recorded and segmented, a corresponding index mark is assigned to each row data recording block, the hit rate of the access request in the cache is improved, the error that the database is directly inquired according to the access request is avoided, and the high-accessibility frequency of the data is reduced.

Description

technical field [0001] The invention relates to the field of cluster technology, in particular to a database data access method, system, device and computer-readable storage medium. Background technique [0002] With the rapid development of science and technology and the increasing penetration of Internet products in daily life, data stored in databases can often be accessed by massive requests. For highly accessible real-time hotspot data for a certain period of time, when a large number of network requests are concurrent, this requires the application system itself to have good disaster recovery capabilities and the ability to carry massive data requests. In particular, when a large number of users request to update the same data record in the application database, if the data does not set any current limit or lock operation, all subsequent requests will be queued up to wait for the previous data update processing to complete, occupying a large number of database connecti...

AI Technical Summary

Problems solved by technology

In particular, when a large number of users request to update the same data record in the application database, if the data does not set any current limit or lock operation, all subsequent requests will be queued up to wait for the previous data update processing to complete, occupying a large number of database connections. Links are full, user requests time out, application layer links are exhausted, and even server downtime and other problems follow one after another

[0003] At present, the high-accessibility real-time hotspot data update method mainly focuses on three aspects: front-end business layer processing, application layer processing and database layer processing. The main purpose is to limit data access traffic, reduce the number of database reads and writes, and improve database concurrency. ; The technical means to reduce database read and write operations and improve database concurrency capabilities mainly focus on adding a cache layer on the upper layer of the database, caching and processing high-frequency access data, and updating the database asynchronously at regular intervals. This type of method is fast in reading and writing. However, the cached data is unstable, and it is prone to abnormalities such as cache loss and direct hit to the database through the cache, resulting in unstable application systems, inconsistent data, and abnormal data.

Images