Method for realizing synchronization of data in heterogeneous database

A data synchronization and database technology, which is used in electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of inability to achieve heterogeneous database data synchronization, poor real-time performance, and other databases.

Active Publication Date: 2013-07-31
天津神舟通用数据技术有限公司
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] 1. Data synchronization between heterogeneous databases cannot be realized
[0009] The implementation of the publishing server and distribution server is closely related to the database server (because the data changes on the database server need the support of the database itself), each database manufacturer can only develop the publishing server and distribution server that matches its own database products, and currently the most Only the subscription database can be other databases, which mainly uses the sql standard to shield the differences between different databases
[0010] 2. The real-time support is not good enough
[0011] The distribution server checks the changes of the publishing database according to the set cycle, and then writes to the subscription database, which usually has a delay of several seconds, and the real-time performance is not good enough

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
  • Method for realizing synchronization of data in heterogeneous database
  • Method for realizing synchronization of data in heterogeneous database
  • Method for realizing synchronization of data in heterogeneous database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] Next, the present invention further illustrates how to realize data synchronization of heterogeneous databases through specific embodiments.

[0029] First, the specific principles of the embodiments of the present invention are described.

[0030] All database systems support some standard database access interfaces (ODBC, JDBC, OLEDB, etc.), and the real-time synchronization technology based on heterogeneous databases uses these standard interfaces. Taking the JDBC interface as an example, the basic principle is: suppose there are heterogeneous databases A and B, A is the database used by the user application, the database access interface uses JDBC, and B is the target database for data synchronization, it is necessary to develop a JDBC driver AB that conforms to the SUN specification, which includes the JDBC driver package of A and the JDBC of B Driver package; In terms of implementation, the user’s function calls on the AB driver are passed to the JDBC driver of th...

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 method for realizing the synchronization of data in a heterogeneous database, wherein the heterogeneous database comprises a database A and a database B. The database A is a database applied by the user, an access interface of the database adopts a JDBC (Java Database Connection) interface, and the database B is a target database performing the data synchronization. The heterogeneous database further comprises a JDBC driver AB (Address Bus) matching the SUN standard. The driver AB comprises a JDBC drive packet of the database A and a JDBC drive packet of the databaseB. Function calls of the driver AB are changelessly transmitted to a JDBC driver of the database A, function calls changing the database are mapped and converted by sql syntax and then transmitted toa JDBC driver of the database B.

Description

technical field [0001] The invention relates to a method for realizing data synchronization of a database system, in particular to a method for realizing data synchronization of heterogeneous databases. Background technique [0002] In the enterprise-level network environment, the phenomenon of heterogeneous databases coexisting is becoming more and more common. For example, Microsoft SQL Server database is used in the marketing department, domestic Shentong database is used in the research and development department, and the enterprise's general server uses ORACLE database. The simultaneous use of heterogeneous databases is not uncommon in many system integration schemes and implementations, so the synchronization of data content between different databases has become a common concern. At present, all major mainstream database products provide the function of synchronizing between their respective databases. Existing synchronization functions are generally implemented usin...

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 Patents(China)
IPC IPC(8): G06F17/30
Inventor 周宇徐岩何清法冯柯顾云苏蒋志勇李阳谢卫平孟勃荣关刚
Owner 天津神舟通用数据技术有限公司
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