Unlock instant, AI-driven research and patent intelligence for your innovation.

Data bidirectional replication method based on database session variables

A replication method and database technology, applied in the database field, can solve problems such as low efficiency and inflexible database application operation, and achieve the effect of avoiding incremental cycles and being convenient to use.

Active Publication Date: 2014-12-31
北京人大金仓信息技术股份有限公司
View PDF1 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, the existing control methods all have certain limitations, see figure 2 As shown, for example, during the synchronization process, it is necessary to shield triggers, restrict users from operating the database or must log in to the database as a specific user to operate, etc., which makes the application operation of the database very inflexible and inefficient

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
  • Data bidirectional replication method based on database session variables
  • Data bidirectional replication method based on database session variables
  • Data bidirectional replication method based on database session variables

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] image 3 Shown is a flow chart of the bidirectional data replication method based on database session variables in the present invention. A kind of data two-way duplication method based on database session variable provided by the present invention, at least comprises the following steps:

[0026] Step S101, searching for session variables existing in the database;

[0027] Step S102, check the default value of the session variable in the database and the value allowed to be set, and set the session variable value;

[0028] Step S103, establishing triggers that can determine triggers in each database according to the set session variable values;

[0029] Step S104, defining the session variable in the replication tool as a session variable whose value has been set;

[0030] Step S105, run the copy tool to copy the generated incremental data; and

[0031] Step S106, mark or delete the copied incremental data.

[0032] Specifically, in step S101, the session variable...

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 data bidirectional replication method based on database session variables, which at least includes the following steps: searching the session variables existing in databases, checking default values and allowed setting values of the session variables in the databases, setting session variable values, respectively establishing triggers capable of judging triggering in each database according to set session variable values, defining session variables in a duplication tool as session variables with set session variable values, operating the duplication tool, duplicating generated incremental data, and marking or deleting the duplicated incremental data. The data bidirectional replication method utilizes the session variables defined by the databases to judge whether incremental recording is performed so as to guarantee correct replication of data among the databases, thereby avoiding incremental circulation.

Description

technical field [0001] The invention relates to a data bidirectional duplication method based on database session variables, belonging to the technical field of databases. Background technique [0002] In the actual application of the database, many occasions require the data of both databases to be replicated. Replication is to copy and distribute data or database objects from one database to another database, and to synchronize the data so that the source database and the target database are consistent. . In this process, incremental management and acquisition are the key factors of the entire synchronization. Since trigger recording of changed data is currently the most efficient implementation method, it is widely used. For example, the Oracle CDC synchronization mode is mainly in the form of triggering Make incremental records. [0003] However, using such methods cannot avoid the problem of loop increments in synchronous applications, such as figure 1 As shown, when...

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 北京人大金仓信息技术股份有限公司