Supercharge Your Innovation With Domain-Expert AI Agents!

Relational database data exchange system

A data exchange and database technology, applied in the database field, can solve the problems of manual operations, insufficient automation, and low efficiency, and achieve the effect of ensuring safety and avoiding misoperation or data leakage

Pending Publication Date: 2020-05-08
CETC CHINACLOUD INFORMATION TECH CO LTD
View PDF9 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

It can be seen that the traditional method is insufficiently automated, with many manual operations and low 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
  • Relational database data exchange system
  • Relational database data exchange system
  • Relational database data exchange system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] According to one or more embodiments, a Kettle-based relational database data exchange system includes data exchange rule configuration and data exchange. Use SpringBoot to develop a web interface, on which you can configure database connection information, data tables and other information, and then create a corresponding kettle job based on the information filled in the interface. The method of data exchange includes using Kettle as the underlying engine, executing a kettle job through the kitchen.sh script provided by Kettle, using the JDBC protocol to transfer data, and importing data from a specified table in one database into a specified table in another database. Users only need to configure the rule configuration of the exchange, and the data between different databases will be exchanged automatically.

[0020] According to one or more embodiments, the Kettle-based relational database data exchange method includes: 1. The connection information of the configurab...

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 relational database data exchange system, which comprises a Web interface, and is characterized in that a user configures data exchange rules of a database on the interface,and the data exchange rules comprise connection information and data table information; and the bottom engine transmits data by using a JDBC protocol and imports the specified table data of one database into the specified table of the other database; the bottom layer engine is realized by executing the kettle operation through a kettle. Sh script provided by the kettle. A user accesses a WEB interface to configure a data exchange rule, and when the system detects a time trigger point, a kettle bottom engine is operated, kettle operation is scheduled to operate, and the database data is exchanged, wherein the Web interface is developed on the basis of SpringBoot.

Description

technical field [0001] The invention belongs to the technical field of databases, in particular to a relational database data exchange system. Background technique [0002] In the data age, data sharing and breaking down data islands have become an indispensable and important step in data construction. Data is the support of a smart society. Only by opening and sharing data in a timely manner and fully mining the "treasure mine" of data resources can we maximize the benefits. However, how to exchange data quickly, conveniently, periodically, incrementally, and in full amount between databases of different manufacturers has become an urgent problem to be solved. In the past, the traditional method was generally to manually export the data of the database into a text file, and then manually import the text data into the database. It can be seen that the traditional method has insufficient automation, many manual operations, and low efficiency. Contents of the invention ...

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/25
CPCG06F16/254
Inventor 杨开睿龚昕陈峰徐博杨飞柏银曾俊
Owner CETC CHINACLOUD INFORMATION TECH CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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