Method for coping database data in heterogeneous environment

A database and environment technology, applied in the computer field, can solve problems such as system resource occupation and heterogeneity, save system resources and network bandwidth, and avoid index search time.

Inactive Publication Date: 2008-05-28
LANGCHAO ELECTRONIC INFORMATION IND CO LTD
View PDF0 Cites 40 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0012] The purpose of the present invention is to provide a database data replication method to solve the problems of heterogeneous platform support, system resource occupation and 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
  • Method for coping database data in heterogeneous environment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0031] The method of the present invention performs data replication at the database level, provides a logic-based transaction replication method for the database, and directly captures the transaction of the source database, and copies the change logic of the database to the target database to realize the source database and the target database. database data consistency,

[0032] During the replication process, when performing log analysis, for the update and insert statements, the rowid of the specific database data record executed by the statement is obtained at the same time. When these SQL statements are executed in the target database, the rowid recorded in the corresponding target database is directly recorded Execution on the host computer eliminates the need to perform complex positioning operations and minimizes the overhead of system resources.

[0033]First, log analysis is performed. The log analysis module reads the control file of the source database in real ti...

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 which realizes data reproduction of a database in an isomeric environment, which gains SQL sentences which cause changes of a source end database through analysis of journals of the source end database, and the SQL sentences are organized according to work, then the SQL sentences which are organized are transmitted to a target end database, and the SQL sentences are executed according to the sequence which is executed in the source end database in the target end database to realize reproduction of a database. The method can suit isomeric environments, and has no isomorphic requirements to storing devices, servers, operating systems, and database software of the source end and the target end, and the method has the advantages of excellent adaptability, which occupies little systematic resource and network bandwidth resource.

Description

1. Technical field [0001] The invention relates to the computer field, in particular to a method for realizing database data duplication in a heterogeneous environment. 2. Background technology [0002] With the construction of informatization, users pay more and more attention to data and have higher and higher requirements for business continuity. Generally, business systems are built on the basis of database software, and disaster recovery systems are established. In the disaster recovery system, the data of the production database needs to be copied to the backup database. At present, from the storage, SAN, operating system, to the business layer, each level has its own replication technology. [0003] 1) Storage-based replication technology [0004] At present, mainstream storage device manufacturers have disaster recovery solutions based on storage devices for their storage products, such as EMC's SRDF and IBM's PPRC. This solution is a physical mirror of data storag...

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): G06F11/14G06F17/30
Inventor 王守昊苑鸿剑
Owner LANGCHAO ELECTRONIC INFORMATION IND 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