Database synchronization method and device, storage medium and terminal

A database and statement technology, applied in the field of database management, can solve problems such as inability to meet business needs, low efficiency, delay and real-time performance, and achieve the effect of reducing query overhead

Pending Publication Date: 2020-08-28
YGSOFT INC
View PDF4 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At present, relational databases are inefficient in relational query and statistical analysis of large-scale (for example: 100 million-level) data, which cannot meet business needs. Although big data technology has solved the problem of large-volume data query efficiency to a certain extent, it is still difficult for Insufficient processing capacity for frequent data changes
The current heterogeneous data synchronization technology usually has delay and real-time perfor

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
  • Database synchronization method and device, storage medium and terminal
  • Database synchronization method and device, storage medium and terminal
  • Database synchronization method and device, storage medium and terminal

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0042] In order to make the purpose, technical solution and advantages of the present application clearer, the embodiments of the present application will be further described in detail below in conjunction with the accompanying drawings.

[0043] When the following description refers to the accompanying drawings, the same numerals in different drawings refer to the same or similar elements unless otherwise indicated. The implementations described in the following exemplary embodiments do not represent all implementations consistent with this application. Rather, they are merely examples of apparatuses and methods consistent with aspects of the present application as recited in the appended claims.

[0044] In the description of the present application, it should be understood that the terms "first", "second" and so on are used for descriptive purposes only, and should not be understood as indicating or implying relative importance. Those of ordinary skill in the art can unde...

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

The embodiment of the invention discloses a database synchronization method and device, a storage medium and a terminal. According to the invention, when the archived log in the source database is updated, an incremental log record in the archived log file is obtained, a plurality of SQL statements are generated according to each incremental log record, the plurality of SQL statements are sent toa target database, then, the target database is operated based on the SQL statement; in order to solve the problem that in the prior art, the target database is overloaded due to the fact that the target database inquires the source database in a polling mode, the incremental log in the archived log file is obtained from the source database and sent to the source database on the basis of the incremental log, so that the inquiry expenditure of the source database is reduced.

Description

technical field [0001] The present application relates to the field of database management, in particular to a database synchronization method, device, storage medium and terminal. Background technique [0002] A relational database refers to a database that uses a relational model to organize data. It stores data in the form of rows and columns for easy understanding by users. A series of rows and columns in a relational database are called tables, and a group of tables constitutes a database. . A user retrieves data in a database through a query, which is an executable code used to limit certain areas in the database. The relational model can be simply understood as a two-dimensional table model, and a relational database is a data organization composed of two-dimensional tables and the relationships between them. At present, relational databases are inefficient in relational query and statistical analysis of large-scale (for example: 100 million-level) data, which canno...

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
IPC IPC(8): G06F16/27G06F16/2458G06F16/242G06F16/23G06F16/18
CPCG06F16/275G06F16/2433G06F16/2358G06F16/23G06F16/1815G06F16/2462
Inventor 关国川沙俊良
Owner YGSOFT INC
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap