Unlock instant, AI-driven research and patent intelligence for your innovation.

Data real-time synchronization method and device for post-relational database, storage medium and terminal

A real-time synchronization and database technology, applied in the field of database processing, can solve the problem that the relational database cannot be directly copied to obtain the post-relational database data, and achieve the effect of convenient physical copying

Pending Publication Date: 2021-01-29
上海柯林布瑞信息技术有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The existing data physical replication of post-relational databases can only be realized between databases of the same type, and traditional relational databases cannot directly replicate the data stored in post-relational databases

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 real-time synchronization method and device for post-relational database, storage medium and terminal
  • Data real-time synchronization method and device for post-relational database, storage medium and terminal
  • Data real-time synchronization method and device for post-relational database, storage medium and terminal

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] As mentioned in the background art, there is no solution for physical data replication and real-time synchronization of post-relational databases in the prior art.

[0026] Furthermore, in the prior art, other types of databases cannot capture data change information in post-relational databases, such as time stamps of operational data. Specifically, if the post-relational database does not have a timestamp, or does not trigger a timestamp update when updating data, other types of databases cannot obtain data change information. In addition, the timestamp based on the trigger is very intrusive to the original database and affects performance. Finally, the change based on the timestamp can only be obtained to the last state of the pull time, and the data changes between the two acquisitions are not recorded.

[0027] In order to solve the above-mentioned technical problems, an embodiment of the present invention provides a real-time data synchronization method of a post-...

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 invention discloses a data real-time synchronization method and device for a post-relational database, a storage medium and a terminal, and the method comprises the steps: obtaining a log file ofthe post-relational database, wherein the log file records the operation information of data in the post-relational database in a historical preset time period; obtaining metadata information of the post-relational database, wherein the metadata information is used for describing the incidence relation among classes, fields and tables of the post-relational database; and for each log in the log file, converting the log into corresponding data according to the metadata information, the corresponding data being operated data in the post-relational database recorded by the log. Through the schemeof the invention, data physical replication of the post-relational database can be achieved, and transaction operation information of data in the post-relational database can be acquired in real time.

Description

technical field [0001] The invention relates to the technical field of database processing, in particular to a real-time data synchronization method and device, a storage medium, and a terminal of a post-relational database. Background technique [0002] Different from traditional relational databases, post-relational databases integrate object database access, high-performance Structured Query Language (SQL) access, and powerful multidimensional data access, and seamlessly and simultaneously based on these three methods access the same data. That is, data can be accessed by all three methods as long as it is described once in a single integrated data dictionary. [0003] This also causes the data storage method and log format of the post-relational database to be very different from the data storage method and log format of the traditional relational database. The existing data physical replication of post-relational databases can only be realized between databases of the...

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 Applications(China)
IPC IPC(8): G06F16/18G06F16/27G06F16/28
CPCG06F16/1815G06F16/275G06F16/284
Inventor 秦晓宏刘焕春
Owner 上海柯林布瑞信息技术有限公司