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

Table replication in a database environment

A database and table technology, applied in database distribution/replication, database update, structured data retrieval, etc., can solve problems such as adding complexity

Active Publication Date: 2021-12-28
SAP AG
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, a fully asynchronous protocol can add complexity to database systems

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
  • Table replication in a database environment
  • Table replication in a database environment
  • Table replication in a database environment

Examples

Experimental program
Comparison scheme
Effect test

example 1—

[0035] Example 1 - Overview

[0036]The following description is directed to techniques and solutions for performing replication of data (eg, database data). For example, efficient replication of database data can be performed using data manipulation (DML) statements and write logshipping. As used herein, a DML statement refers to any statement, command, message, or other instruction that specifies any manipulation of data (eg, insert, update, delete, select). In some implementations, the DML statement is executed (eg, at the first database system) and a write log is created that reflects the DML statement and transaction commit operations. In one example, a separate write log entry is created for each DML statement or transaction commit operation. In a specific example, a write log entry may include a DML statement and associated parameters and / or values ​​(eg, parameters and / or values ​​that may be required when the DML statement is executed at another database system). W...

example 2

[0043] Example 2 - Writing to a log

[0044] In any of the examples herein, a write log can be utilized to replicate a DML statement (eg, a DML structured query language (SQL) statement). For example, a write log format can be created that includes the DML statement with additional information associated with the DML statement (eg, additional information used when executing the DML statement). In some implementations, writing a log entry includes a single DML statement.

[0045] In some implementations, write log entries include transaction identifiers (IDs), DML statements, parameter values, and non-deterministic values. A transaction identifier identifies (eg, uniquely identifies) a DML replication transaction. For example, a transaction identifier may uniquely identify a DML replicated transaction occurring on the source system and one or more replica nodes on which the DML statement is to be executed.

[0046] A DML statement may be a statement for modifying (eg, adding...

example 3

[0056] Example 3—Using DML statements to provide a replicated environment

[0057] In any of the examples herein, techniques may be provided for more efficient replication (eg, replication of database information) utilizing DML statements and writing to a log. For example, DML statements may be executed at the source system and included into a write log for sending (shipping) to the replica system for execution to replicate data between the source system and the replica system for one or more database tables. In addition, DML replication can be applied to different types of storage engines, such as row storage, column storage, and so on.

[0058] In some implementations, the concept of DML replication with write log shipping (eg, DML synchronous replication) aims to perform replication across multiple nodes with minimal replication overhead. However, synchronous replication can result in longer response times because both the source and replica(s) are updated within the same ...

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

Techniques are described for performing replication of data within a database environment having source nodes and replica nodes. The source node performs a database operation on at least one database table stored by the source node. The source node sends this database operation asynchronously to the replica nodes. Prepare-to-commit requests are sent synchronously from the source node to the replica nodes. The source node receives sync pre-commit acknowledgments from the replica nodes. A pre-commit acknowledgment indicates that a database operation was performed at a replica node. The source node commits the transaction associated with that database operation.

Description

technical field [0001] This disclosure generally relates to the reproduction of information. Certain implementations relate to the replication of data between a source and a replica in a database environment. Background technique [0002] Database performance can be enhanced by creating a copy of the source table (replica). For example, the replicated table may be hosted on a different computing system than the source table, where the source host and the replica host have different processors. Having replicas available to service database read requests helps balance the computational load across multiple processors, improving system performance. In some cases, replicas may also be used for "high availability data" purposes, such as when the replica is able to take over one or more functions of the source table if the source table becomes unavailable. [0003] Challenges in replicated systems include maintaining consistency between source and replica tables. Replication c...

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): G06F16/27G06F16/23
CPCG06F16/27G06F16/2358G06F16/275G06F16/2379G06F16/273G06F11/1451G06F2201/80
Inventor J.李C.G.朴K.H.金H.J.那D.K.金J.Y.李
Owner SAP AG