Database one-way synchronization method

A database, one-way technology, used in electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of heavy maintenance workload and difficulty in ensuring data consistency.

Inactive Publication Date: 2017-11-14
UNIONPAY INT CO LTD
View PDF6 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If each system needs to maintain these basic data, the workload of maintenance w

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
  • Database one-way synchronization method
  • Database one-way synchronization method
  • Database one-way synchronization method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0032] Introduced below are some of the various embodiments of the invention, intended to provide a basic understanding of the invention. It is not intended to identify key or critical elements of the invention or to delineate the scope of protection.

[0033] First, in the present invention, JDBC technology is adopted as the database access technology. JDBC can support commonly used database types, shield the underlying database differences, and provide a unified database access interface. Specifically, JDBC is a Java API for executing SQL statements that can provide unified access to various relational databases, and it consists of a set of classes and interfaces written in the Java language. JDBC provides a baseline from which higher-level tools and interfaces can be built to enable database developers to write database applications. Among them, JDBC is JavaDataBaseConnectivity, java database connection; SQL is StructuredQueryLanguage structured query language; API is App...

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 relates to a database one-way synchronization method for use among databases. The method comprises the following steps: inquiring data to be synchronized in a source database; checking whether a record to be synchronized exists in a target database or not, and performing an update operation or an insertion operation or not performing any synchronization operation according to a checking result; acquiring existing data in the target database; and checking whether data in the target database exist in the source database or not, and deleting the record or marking the record or not performing any synchronization operation according to a checking result. Through adoption of the database one-way synchronization method for use among databases disclosed by the invention, service decoupling can be realized, and one-way data synchronization among data of different types of databases and different structural tables can be realized through simple configuration.

Description

technical field [0001] The invention relates to a data synchronization method of a database, more specifically to a Spring JDBC-based configurable one-way synchronization method for a heterogeneous relational database. Background technique [0002] Regarding database synchronization, major database vendors have their own dedicated products. Such as Oracle's Data Guard, Golden Gate. But they are mainly used in situations where the data in the database table structure is consistent. Data synchronization between databases with different table structures cannot be realized. Common code implementations are often linked to business logic and do not have versatility and flexibility. [0003] In enterprise applications, there is often a situation where a piece of basic data is used by different systems. If each system needs to maintain these basic data, the workload of maintenance will become very heavy, and the consistency of data is difficult to be guaranteed. In order to red...

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
IPC IPC(8): G06F17/30
CPCG06F16/275
Inventor 梁亮
Owner UNIONPAY INT CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap