Data merging method and system

A data and source data technology, which is applied in the field of cross-server cross-database association query, can solve problems such as low efficiency, long data synchronization delay, unfavorable maintenance, etc., and achieve the effect of reducing coupling and improving efficiency

Active Publication Date: 2014-12-24
ZICT TECH CO LTD
View PDF4 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Among them, the data synchronization method is inefficient, and the data synchronization delay is relatively long when there is a large amount of concurrent data, and it is easy to cause data inconsistency and other shortcomings.
As for the cross-database correlation query method, it uses the cross-database query function provided by the database, which is more efficient than the data synchronization method, and generally does not bring disadvantages such as data inconsistency; however, the cross-database correlation query method does not support heterogeneous databases Query, so its scalability is not strong, and at the same time, it forms a high coupling between databases, which is not conducive to maintenance

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 merging method and system
  • Data merging method and system
  • Data merging method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] The basic idea of ​​the present invention is: first determine the respective list names of each source data and target data respectively, and convert each said source data and said target data into unified composite data; then respectively determine each said source data and said target data The respective forward or reverse position indexes of the target data, and determine the merging rule expression; then merge each of the source data into the target data according to the merging rule expression and the position index; finally, clear Each of the source data, and returns the combined target data.

[0022] Here, composite data includes composite data objects, array data objects, and non-array data objects; the composite data, as a unified standard for data conversion, is an intermediary data type that is equivalent to and interchangeable between various types of data; specifically, Any type of data can be transformed into standard composite data through analytical equi...

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 a data merging method. The data merging method comprises the steps of respectively determining list names of source data and list names of target data, and converting the source data and the target data into unified composite data; respectively determining forward direction or reverse direction position indexes of the source data and the target data, and determining a merging rule expression; merging the source data into the target data according to the merging rule expression and the position indexes; clearing the source data, and returning the target data subjected to merging. The invention further provides a data merging system. By means of the data merging method and system, efficiency in data integration can be increased, and the coupling degree of the source data can be reduced.

Description

technical field [0001] The invention relates to cross-server and cross-database correlation query technology, in particular to a data merging method and system. Background technique [0002] Distributed Database System (DDBS) uses a computer network to disperse geographical locations, and management and control require different levels of concentration to connect multiple logical units to form a unified database system. The distributed database system is a kind of distributed file system, which corresponds to the traditional centralized database. [0003] In a distributed database system, there are two commonly used data integration methods: one is data synchronization, which uses data synchronization tools or programs to achieve data concentration, thereby realizing data integration between distributed systems; the other is cross-database Associative query method realizes data merging operation by performing associated query on databases distributed on the same server. Am...

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): G06F17/30
CPCG06F16/215G06F16/27
Inventor 张志红
Owner ZICT TECH CO LTD
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