Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method for duplicating data of identical data table between two data bases

A data replication and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of cumbersome efficiency, unable to export only changed data, and data that cannot be copied, and achieve the effect of high pressure on the database

Inactive Publication Date: 2004-02-25
WONDERS INFORMATION
View PDF0 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Since the data replication between different databases is not an incremental replication, that is, every time the data is exported, all the data in the table to be copied must be exported, and only the changed data cannot be exported.
In this way, if the amount of data to be copied is large and the copying operation is frequent, then this method of full-disk copying is both cumbersome and inefficient, and in this way of file exchange, there is also a problem that if the file is damaged, all data will be lost. Hidden dangers of duplication

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 duplicating data of identical data table between two data bases
  • Method for duplicating data of identical data table between two data bases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0015] The present invention will be described in detail below with reference to the accompanying drawings and an embodiment.

[0016] The data replication of the same data table between two online databases applicable to the present invention occurs between the oracle personal database and the oracle enterprise database. Identify the oracle personal database as person, and the oracle enterprise database as enterprise. Person and enterprise each have a t_up table with the same structure and a t_down table with the same structure. Now you need to copy the t_up table in person to the t_up table in enterprise, and copy the t_down table in enterprise to the t_down table in person.

[0017] First, establish a data link named enterprise&repl connected to the enterprise library in the person library; create three triggers representing add, delete, and update operations on the t_up table in the person library, and t_down in the enterprise library Three triggers representing add, del...

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 present invention is aimed at resolving the problems of that its efficiency is low, operation is complex and its data are easily damaged which are existed in the data reproduction between two data bases with different versions, and utilizes the adoption of data base trigger technique and programmes the data reproduction software so as to implement large batch reproduction of data in non-file mode.

Description

technical field [0001] The invention relates to the data replication of the same data table between two databases, in particular to realizing the data replication of the same data table between two online databases in a non-file manner. Background technique [0002] In an information system, a large amount of data replication is often required between two databases. In the database system of the same version, data replication can be realized through the replication function of the database itself, and for data replication between databases of different versions, the existing method is to copy all the data in the table to be copied in the source database Export all, generate a file, delete all the records in the corresponding table of the target database, import the generated file into the target database, and complete the data replication between the two databases. [0003] Since the data replication between different databases is not an increme...

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/00G06F17/30
Inventor 王晴岗李光亚袁力靖矫成东金刚纪洁黄中慧刘继华周燕芳
Owner WONDERS INFORMATION
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

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