Heterogeneous database copy method

A replication method and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problem of not supporting real-time performance, publishing server 1 and distribution server 2 are not portable, and cannot realize heterogeneous database data Replication and other issues, to achieve the effect of real-time data replication

Inactive Publication Date: 2006-05-10
北京神舟航天软件技术股份有限公司
View PDF0 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] 1) Data replication between arbitrary heterogeneous databases cannot be realized
[0007] The implementation of Publisher 1 and Distributor 2 is closely related to the database server. Each database manufacturer only develops Publisher 1 and Distributor 2 that match their own database products. That is to say, Publisher 1 and Distributor 2 are not portable. ; At present, only 3 or 4 or 5 subscribers can be suitable for heterogeneous databases at most. This is mainly through the sql (Struct Query Language, Structured Query Language) standard to shield the differences between different databases
[0008] 2) Does not support real-time performance

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
  • Heterogeneous database copy method
  • Heterogeneous database copy method
  • Heterogeneous database copy method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] Such as figure 2 As shown, the heterogeneous database replication method of the present invention involves the original database and the database to be replicated, comprising the following steps:

[0030] Step 10) set up heterogeneous database system general interface driver, described heterogeneous database system general interface driver comprises original database database system general interface driver and database database system general interface driver to be copied;

[0031] Step 20) judging whether the calling of the original database has changes to the original database;

[0032] Step 30) if the original database is changed, the call is delivered to the original database and the database system general interface driver of the database to be copied simultaneously and the database system general interface driver of the original database is called;

[0033] Step 40) calling the database system general interface driver of the database to be copied.

[0034] 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 method for copying database of different types which comprises steps ofú‘establishing general database interface driver which includes the original and target database systems general interface drivers; judging whether the calling of original database modify it or not; if the original database being modified, conveying the calling to both original database and database for copying and calling original database system interface driver; calling the general interface driver of database for copying.

Description

technical field [0001] The invention relates to the application field of database systems, in particular to a heterogeneous database duplication method. Background technique [0002] In the current environment where database systems are used, such as enterprise-level network environments, the phenomenon of heterogeneous databases coexisting is becoming more and more common. For example, within a company, its marketing department uses Microsoft's SQL Server database, its R&D department uses Shenzhou Software's OSCAR security database, and its general server uses Oracle's ORACLE database. Many system integration schemes and implementations are not uncommon, so the replication of data content between heterogeneous databases has become a common concern. [0003] At present, all major mainstream database products provide the function of replicating between their respective databases. Existing replication functions are generally implemented using a publish / subscribe model. Such...

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): 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