Intelligent optimized data type synchronous fusion system

Abstract

The invention relates to an intelligent optimized data type synchronous fusion system, which belongs to the field of data fusion, and comprises a data adapter used for collecting field types and related information of a remote target end table and finally transmitting an execution statement to a target end according to an operation logic; the type ladder escape module comprises a type compatibility comparison table among the databases and is used for layering types; source end information is subjected to information conversion, and a new parameter set is transmitted to the data element analysis module; the data element analysis module is used for analyzing the data, judging the multi-dimensional information of the data type: judging whether a target end field specification needs to be redefined or not, and transmitting parameters into the data definition language compiling module; and the data definition language compiling module comprises a set of configuration files, and when the structure of the destination end needs to be adjusted, the relevant parameters and the data definition language configuration files are used to automatically generate a script language corresponding to the destination end table and the corresponding operation, and the script language is executed at the destination end.

Description

technical field [0001] The invention belongs to the field of data fusion, and relates to an intelligently optimized data type synchronization fusion system. Background technique [0002] During the construction of the data center of the group hospital, there is a need to aggregate multi-source data into a unified storage for data analysis and utilization. Within each organization, the unified production system has been changed due to business requirements, resulting in differences in the original consistent table structure of the same production system, such as adjusting the precision of floating-point fields and modifying the length of character fields. These differences often occur when data centers integrate data. The newly incorporated data source is incompatible with the existing stored data type, resulting in synchronization failure and data deadlock. In the traditional processing mode, one is to create tables at the destination When , artificially adjust the data typ...

AI Technical Summary

Problems solved by technology

However, this method cannot completely avoid hidden dangers. When an incompatibility occurs, it is still necessary to wait until the program reports an error or catches an exception, and then manually handles it; Fields are processed into highly compatible types, such as long text types or long string types; this processing method consumes storage, and most of the time, it will reduce data query performance

Images