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

Rapid synchronization and control method of json data and system device

A data synchronization and data technology, applied in relational databases, database models, structured data retrieval, etc., can solve problems such as reducing development efficiency and increasing code redundancy, and achieve the effect of improving development efficiency

Inactive Publication Date: 2018-06-05
武汉优品楚鼎科技有限公司
View PDF0 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Every time you do this kind of development, you need to write the code of the synchronization process separately for the actual json data form, and if there are multiple similar data synchronizations, you need to write them separately, which greatly increases the code redundancy and reduces the development efficiency

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
  • Rapid synchronization and control method of json data and system device
  • Rapid synchronization and control method of json data and system device
  • Rapid synchronization and control method of json data and system device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0039] Such as figure 1 As shown, a method for quick synchronization and control of json data, the method includes:

[0040] Step 101, the configuration file editing module obtains the synchronization requirement file of the synchronization data, including the configuration file of json data source file information, target database information and field relationship mapping;

[0041] Step 102, the configuration file parsing module reads the configuration file, analyzes and identifies the json data source and unique target database of each synchronous data according to the parsed configuration file, and establishes a database connection;

[0042] Step 103, the json data reading module obtains the parsed json data source to read the json data, and generates batch-synchronized SQL statements according to the data field mapping relationship in the configuration;

[0043] Step 104, the relational database writing module writes json data in batches to the target database according ...

Embodiment 2

[0046] Such as figure 2 As shown, the configuration file contains the following content:

[0047] 1. Original json data source file information, such as file type (filetype), file path (path), file encoding format (charset), etc.;

[0048] 2. The information of the target database to be synchronized mainly includes the database type identification dbtype (mainly Oracle, Microsoft SQL Server, MySql, etc.) and the host (host), port number (port), and username (username) of the target database to be synchronized , password (password), encoding format (charset), database (database) and other connection information and write data table (datatable).

[0049] 3. The data mapping relationship mainly includes the one-to-one mapping between each sub-property (property) of the json data object and the corresponding data table field (field) in the relational database.

[0050] The method and the system can perform multiple data synchronization tasks at the same time. The json data sou...

Embodiment 3

[0052] Such as image 3As shown, the present invention provides a system for fast synchronization and control of json data, and the system includes:

[0053] The configuration file editing module is used to edit and modify the configuration file. After the modification, restart the synchronization system to take effect;

[0054] The configuration file parsing module is used to automatically read the configuration file, perform accurate parsing, identify the source data and target database of each synchronous data, and establish a connection;

[0055] The json data reading module is used to automatically read the json data source, and generate batch-synchronized SQL statements according to the data field mapping relationship of the configuration file;

[0056] A relational database writing module, configured to write json data in batches to the target database according to the database connection;

[0057] The data synchronization process control module is used to control the...

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 rapid synchronization and control method of json data and a system device. The method includes steps that a configuration file editing module acquires a synchronization demand file of synchronization data; a configuration file analysis module reads the configuration file, analyzes and identifies the json data source and the sole target database of every synchronization data, and builds up a database connection; a json data reading module acquires the analyzed json data source and reads the json data, and generates SQL sentences synchronized in batch according to the data field mapping relationship in configuration; a relationship type database write-in module writes json data to the target database in batch according to the database connection. The method can flexibly and rapidly edit and modify the configuration file, automatically carry out data synchronization according to the configuration file, control the synchronization process, record the synchronization log, and monitor the synchronization progress and count the synchronization result. The method is convenient and flexible, rapid and high efficient to synchronize the json data to the relationshipdatabase, thus the development efficiency is greatly improved.

Description

technical field [0001] The invention relates to the field of computer program development, in particular to a data synchronization method and system for synchronizing data in json format to a relational database. Background technique [0002] JSON is a lightweight data format based on a subset of ECMAScript. Its flexible data organization method is favored by developers, so it is widely used in program development. [0003] The feature of relational database storage data is usually that a database contains several data tables, each data table contains several data fields, and each field represents an attribute of the current data entity. [0004] During the development process, it is often encountered when it is necessary to synchronize json data to a relational database. Every time you do this kind of development, you need to write the code of the synchronization process separately for the actual json data form, and if there are multiple similar data synchronizations, you ...

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): G06F8/73G06F17/30
CPCG06F8/73G06F16/275G06F16/284
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com