Data synchronization method, device, equipment and computer readable storage medium
A data synchronization and computer program technology, applied in the database field, can solve problems such as reducing user experience and business process freezes, and achieve the effects of improving data synchronization efficiency, avoiding business freezes, and improving user experience
Active Publication Date: 2019-10-22
INFINITUS (CHINA) CO LTD
View PDF10 Cites 11 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0004] However, the existing data synchronization method based on Informatica CDC software has a serious data delay problem. Specifically, CDC software is not suitable for updating data information that requires additional conversion processing, so it needs to be combined with other processing components. Realize data conversion processing, which will result in a data delay exceeding 20 seconds. When conversion information needs to be obtained from massive data tables, the data delay will exceed 1 minute
Furthermore, in actual business scenarios, such as the data synchronization process between the OLTP database and the OLAP database, in order to improve the overall processing capability of the OLTP database, the OLAP database is often used to share the query requirements of real-time analysis reports, and in order to ensure For real-time analysis, the data synchronization delay target between OLAP database and OLTP database needs to be less than 10 seconds, but the data synchronization method of InformaticaCDC software in the existing technology is difficult to overcome this problem, resulting in business process freezes and poor user experience
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0046] The core of this application is to provide a data synchronization method, which can effectively improve the efficiency of data synchronization between databases, solve the problem of stalling in actual business processes, and greatly improve user experience; another aspect of this application A core is to provide a data synchronization device, equipment, and computer-readable storage medium, which also have the above beneficial effects.
[0047] In order to make the purposes, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments It is a part of the embodiments of this application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in ...
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
Login to View More Abstract
The invention discloses a data synchronization method. The data synchronization method comprises the following steps: starting Informica CDC according to a received data synchronization instruction; capturing change log record information of a source database in real time through the Informica CDC; judging whether target data corresponding to the change log record information needs to be subjectedto data conversion processing or not; if so, carrying out data conversion on the target data by utilizing an Oracle PL / SQL technology to obtain converted data information; the converted data information is sent to the target database, and data synchronization is completed. According to the data synchronization method, the data synchronization efficiency between the databases can be effectively improved. The problem of jamming in the actual business process is solved. The user experience is greatly improved. The invention further discloses a data synchronization device, equipment and a computer readable storage medium, which all have the above beneficial effects.
Description
technical field [0001] The present application relates to the technical field of databases, in particular to a data synchronization method, and also to a data synchronization device, device, and computer-readable storage medium. Background technique [0002] Data synchronization technology is mainly to solve the data exchange processing technology between different databases. The data synchronization processing scheme is generally determined by the type of source database and target database, the frequency of data exchange, data format, data capacity and other factors. [0003] At present, for real-time data synchronization processing between massive databases, CDC software is a common implementation method. Informatica CDC software provides a conventional real-time data synchronization processing method based on a general database. Specifically, taking OLTP database (transaction database) and OLAP database (report database) as examples, please refer to figure 1 , figure 1...
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
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/27
CPCG06F16/27
Inventor 郭世亮许广雄方立华
Owner INFINITUS (CHINA) CO LTD