Incremental data real-time synchronizing device based on log management packet and incremental data real-time synchronizing method based on same

A technology of incremental data and real-time synchronization, applied in the field of data integration, can solve problems such as difficult implementation, overwhelmed enterprises, and impact on business system performance, and achieve simple, easy-to-implement, and high-reliability effects

Active Publication Date: 2012-06-20
YONYOU NETWORK TECH
View PDF3 Cites 44 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The disadvantages of this technology are: first, it cannot reflect real-time data and does not meet the needs of new business intelligence; make the business overwhelmed
This replication technology can only be limited between databases of the same type, and it is helpless for current business intelligence in OLAP data sources that tend to be open source data sources or columnar data storage with better performance than traditional row data storage.
[0006] 3. Use the trigger mechan

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
  • Incremental data real-time synchronizing device based on log management packet and incremental data real-time synchronizing method based on same
  • Incremental data real-time synchronizing device based on log management packet and incremental data real-time synchronizing method based on same
  • Incremental data real-time synchronizing device based on log management packet and incremental data real-time synchronizing method based on same

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] In order to understand the above-mentioned purpose, features and advantages of the present invention more clearly, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0030] In the following description, many specific details are set forth in order to fully understand the present invention, but the present invention can also be implemented in other ways different from those described here, therefore, the present invention is not limited to the specific embodiments disclosed below limit.

[0031] The following is the meaning of the English abbreviations appearing in the manual:

[0032] BI: Business Intelligence is the abbreviation of business intelligence.

[0033] DI: Data Integration, is the abbreviation of data integration.

[0034] OLTP data source: the database management system used to process transactional business in enterprise-level systems, representative of which are row-b...

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 provides an incremental data real-time synchronizing device based on a log management packet, which comprises a first synchronizing unit and a second synchronizing unit, wherein the first synchronizing unit is used for duplicating initial data in a first data source into a second data source; and the second synchronizing unit is used for obtaining data manipulation statements executed by the first source by the aid of the logo management packet of the first data source and applying the data manipulation statements into the second data source so as to realize real-time synchronization of incremental data between the first data source and the second data source. The log management packet includes a required storage process for analyzing logos of the first data source so as to obtain data manipulation information from the logos, the data manipulation information comprises markers, manipulation objects and belonging transactions of the data manipulation statements, and the logos record all manipulations on the first data source. The invention further provides an incremental data real-time synchronizing method based on the log management packet. By the aid of the device, synchronism of the incremental data between different data sources is realized.

Description

technical field [0001] The invention relates to the technical field of data integration, in particular to a device and method for real-time synchronization of incremental data based on a log management package. Background technique [0002] With the rapid development of science and technology represented by computer software / hardware, information technology represented by business intelligence has also developed rapidly. At present, management and operation informatization is already one of the key strategies to realize the leap-forward development of an enterprise. Modern enterprises have higher and higher requirements for business intelligence analysis of their business data; senior managers of enterprises are also increasingly Soberly realize how important the valuable information hidden in massive data is to improving the scientific decision-making and management level of enterprises, and the era of formulating policies after taking heads will be gone forever! In this e...

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): G06F17/30
Inventor 栗竹冉曾小青
Owner YONYOU NETWORK TECH
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