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

Data synchronization generation method, apparatus, computer apparatus, and storage medium

A data synchronization and database technology, applied in the field of big data, can solve problems such as low work efficiency, achieve the effects of convenient viewing, expanding application fields, and shortening time consumption

Pending Publication Date: 2019-02-19
CHINA PING AN LIFE INSURANCE CO LTD
View PDF4 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The main purpose of this application is to provide a data synchronization generation method for synchronizing relational database data to a big data platform, aiming to solve the technical problems that manual participation is required when synchronizing a relational database to a big data platform, and the work efficiency is not high

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 synchronization generation method, apparatus, computer apparatus, and storage medium
  • Data synchronization generation method, apparatus, computer apparatus, and storage medium
  • Data synchronization generation method, apparatus, computer apparatus, and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0048] In order to make the purpose, technical solution and advantages of the present application clearer, the present application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present application, and are not intended to limit the present application.

[0049] refer to figure 1 , the data synchronization generation method of synchronizing relational database data to a big data platform according to an embodiment of the present application, including:

[0050] S1: Read the pre-configured table structure of the configuration table for synchronizing the relational database data to the big data platform in the relational database, so as to obtain each configuration information of the configuration table.

[0051] The relational database in this embodiment is a database built on the basis of a relational database model. It pr...

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 present application relates to a data resource, disclosing a data synchronization generation method, an apparatus, a computer device and a storage medium, wherein, the data synchronization generation method comprises the following steps: reading a table structure of a preconfigured configuration table synchronizing the data of the relational database to a large data platform in a relational database to obtain configuration information of the configuration table; Generating scheduling tasks, scripts and table building statements corresponding to the big data platform according to the configuration information; The scheduling task, the script and the table building statement are respectively transmitted to the designated position of the big data platform to schedule the designated data of the relational database to the big data platform. Sqoop data synchronization automatic generation tool is developed, which can automatically generate Sqoop data synchronization script files and build table statements, directly deploy (hang on another platform), and control the synchronization of script files through the platform. The script running platform is unified and centralized, which is convenient for operators to manage all the script running conditions.

Description

technical field [0001] The present application relates to the field of big data, and in particular relates to a data synchronization generation method, device, computer equipment and storage medium. Background technique [0002] The data in the existing relational database needs to be synchronized to the big data platform before it can be applied in different application fields and continuously expand the data volume of the big data platform so that the data in a specific relational database can be shared with other relational databases. Existing relational databases have relatively strict permissions, and other relational databases cannot directly obtain corresponding information from the specified relational database, and because the data types of each relational database are not compatible, other relational databases cannot directly identify the data in the specified relational database. Synchronize the relational database to the big data platform, and then share it, but ...

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/27G06F16/28G06F16/22
Inventor 席旭亮
Owner CHINA PING AN LIFE INSURANCE CO LTD
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