Automatic table data synchronization method and device, computer equipment and storage medium

Abstract

The invention discloses an automatic table data synchronization method and device, computer equipment and a storage medium, and the method comprises the steps: building a table object in a process memory, and setting a data change detection mode for a table; creating a data subscription request for requesting table data from a REDIS server through a REDIS client, sending the data subscription request to the REDIS client, and obtaining relay data needing to be updated to a table from a REDIS database by the REDIS client; updating the table data by utilizing the table object according to the relay data; and sending a data change notification to a table user according to a detection result of the data change detection mode. According to the method, the complexity of accessing the REDIS database by software developers can be reduced, and a user can complete interaction with the REDIS database according to a using method similar to a traditional two-dimensional table without knowing detailed REDIS commands. The consistency of data in a plurality of software units is ensured. The optional registration notification callback is convenient for a user to sense data change in time.

Description

technical field [0001] The invention relates to the technical field of memory database caching, and in particular to a table data automatic synchronization method, device, computer equipment and storage medium. Background technique [0002] With the rapid development of Internet technology and the continuous improvement of the distributed architecture system, users have put forward higher requirements for the response speed of the software and the overall performance of the system. Using the caching mechanism to solve the problem of high concurrent requests and hot data storage has become the preferred solution for the public. The cache mechanism uses the high-speed reading and writing characteristics of the memory to store data in the memory to improve the data access speed and reduce the performance loss of the system in the data reading and writing part. [0003] Redis (Remote Dictionary Server) is a non-relational memory database with Key-Value as the data model, open s...

AI Technical Summary

Problems solved by technology

[0008] In order to meet the above requirements, the first object of the present invention is to provide a method for automatically synchronizing table data. The object of the present invention is to realize a thread-safe distributed virtual two-dimensional table based on REDIS. When operating the REDIS database through the table , developers don’t need to learn REDIS-related technologies, don’t need to care about data storage details and underlying implementation, and don’t need to define field names and formats for the data to be stored in advance. They can access REDIS databases only through table row and column operations, which solves the cost of REDIS learning and use High, data uncoupling, difficult to understand

Images