Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data processing method, server, client, device and readable storage medium

A data processing and server-side technology, applied in the field of data processing, can solve problems such as long operation cycle, high synchronous refresh, and low business reliability, and achieve the effect of improving efficiency and ensuring consistency

Active Publication Date: 2021-11-09
WUHAN DOUYU NETWORK TECH CO LTD
View PDF10 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, this method of synchronous refresh is limited to scenarios with fewer in-memory databases, and developers need to know which clients use the data in the relational database
When this synchronous refresh method is applied to multiple distributed in-memory databases, since these distributed in-memory databases all cache the data in the relational database, it is necessary for developers to synchronously refresh the data one by one. The operation period is long, and there is a high delay in synchronous refresh, which leads to low service reliability

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Data processing method, server, client, device and readable storage medium
  • Data processing method, server, client, device and readable storage medium
  • Data processing method, server, client, device and readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0057] refer to figure 1 , the following introduces a data processing method of the embodiment of the present invention from the perspective of the server, which is applied to a relational database system. The relational database system includes a server and a plurality of clients, and the server includes at least one relational database system. database. The methods include:

[0058] S101: The server determines updated data in the relational database.

[0059] Before step S101, the method may further include:

[0060] The server determines relational databases cached by multiple clients, and registers nodes corresponding to each relational database on the relational databases. That is, the server also needs to define a unique primary key field for each database table in the relational database, for example, the primary key field can be an auto-increment id. It is also necessary to register each cached database table with a node on ZooKeeper. Taking the name of the databas...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

Embodiments of the present invention provide a data processing method, a server, a client, a device, and a readable storage medium. The method includes: the server determines the updated data in the relational database, writes the identifier of the updated data into the relational database, and sends a notification message to the client, the notification message is used to indicate that updated data. The client then determines the identifier of the updated data according to the notification message, obtains the data value corresponding to the identifier of the updated data from the relational database corresponding to the identifier of the updated data, and stores the corresponding data respectively The value is updated to the instance's cached data. By adopting this solution, the client can update the cached data in the instance in time to ensure data consistency.

Description

technical field [0001] The present invention relates to the technical field of software, in particular to a data processing method, server, client, device and readable storage medium. Background technique [0002] In the field of software engineering, there is a large flow of data access. In order to improve data retrieval efficiency and reduce request response time, data in relational databases is generally cached in memory databases to improve data throughput and excellent query performance. However, it is necessary to ensure the consistency of the data cached in the memory database and the data in the relational database. If the data is inconsistent, business problems may occur. [0003] In order to achieve the purpose of data consistency, when the server writes to the relational database, the cache of the memory database is refreshed synchronously, thereby achieving data consistency. However, this method of synchronous refresh is limited to scenarios with fewer memory d...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/2455G06F16/28
Inventor 张振铎陈少杰张文明
Owner WUHAN DOUYU NETWORK TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products