Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Multi-data-source database timing synchronization method and system

A timing synchronization and multi-data source technology, which is applied in the fields of electrical digital data processing, special data processing applications, digital data information retrieval, etc., can solve the problem that multiple data sources are difficult to synchronize to the corresponding database, and achieve the reduction of labor costs and large economy benefit effect

Pending Publication Date: 2021-07-23
山东健康医疗大数据有限公司
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the scenario of synchronizing data from multiple data sources to a database needs to be improved
Take the data synchronization from oracle data to mysql as an example. There are many syntaxes and data types in oracle that are different from the fields in mysql, such as the CLOB in oracle and the text type in mysql. Based on such scenarios, the present invention implements a method and system for timing synchronization of multiple data source databases, which solves the problem that multiple data sources are not easy to synchronize to corresponding 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
  • Multi-data-source database timing synchronization method and system
  • Multi-data-source database timing synchronization method and system
  • Multi-data-source database timing synchronization method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0039] A method for timing synchronization of multiple data source databases, the specific steps of the method include:

[0040] S1 is bound through data sources and data indicators;

[0041] S2 configures the data information of multiple data sources synchronously;

[0042] S3 configuration data index information;

[0043] S4 configures timing tasks to achieve data synchronization;

[0044] The invention realizes a multi-data source database timing synchronization method, which can be used for the synchronization of multiple data sources of medical data, and adopts the data source information, timing task and data index binding mode to realize the user's original multi-data source medical data in a timely manner Synchronization control; provides data source information configuration, data index configuration, and can provide the function of synchronizing data from multiple data sources at regular intervals after the configuration is successful;

[0045] First, bind the dat...

Embodiment 2

[0060] A system for timing synchronization of multiple data source databases, the system specifically includes a binding module, an information configuration module, an index configuration module and a timing synchronization module:

[0061] Binding module: binding through data sources and data indicators;

[0062] Information configuration module: synchronously configure the data information of multiple data sources;

[0063] Index configuration module: configure data index information;

[0064] Timing synchronization module: configure timing tasks to achieve data synchronization;

[0065] First, use the binding module to bind data sources and data indicators, and then use the information configuration module to synchronously configure the data information of multiple data sources. You can configure Mysql, Oracle, Kudu, and SqlServer databases. After configuring the data sources, the service can be used It is necessary to configure data indicators through the indicator config...

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 multi-data-source database timing synchronization method and system, and belongs to the field of data synchronization processing. The method comprises the following specific steps: S1, binding a data source and a data index; s2, performing synchronous configuration on the data information of the multiple data sources; s3, configuring data index information; s4, configuring a timed task to realize data synchronization. The invention provides a multi-data-source database timing synchronization method. Automatic timing data synchronization from multiple data sources to one database is achieved. According to the method, multiple data sources are configured firstly, connection of the multiple data sources is achieved, and the data sources are bound with corresponding data indexes to achieve timing data synchronization from a data source corresponding table.

Description

technical field [0001] The invention discloses a multi-data source database timing synchronization method and system, and relates to the technical field of data synchronization processing. Background technique [0002] With the vigorous development of information technology, "Internet + health care" has become a social hotspot, and medical data has also entered the era of data explosion. The demand for medical data interconnection is also increasing day by day. Data from different institutions may be stored in different types of storage devices. In databases such as mysql, oracle, and kudu, how to ensure timely synchronization of data from a large number of different data sources is one of the main problems faced by the interconnection of medical data. [0003] At present, there are many synchronization methods in the medical data synchronization industry, such as directly importing the same type of database into SQL, or directly performing database replication on a database...

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/178G06F16/242
CPCG06F16/178G06F16/2433
Inventor 彭浩罗宝利
Owner 山东健康医疗大数据有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products