DDL Transaction Resumption via Data Block Segmentation

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing database systems face challenges in efficiently resuming and completing Data Definition Language (DDL) transactions after interruptions, leading to low success rates and high resource utilization costs, especially when dealing with large data volumes.

Innovation Solution

The method involves determining the last data block processed before an interruption in a DDL transaction and continuing execution from the next block, allowing for partial results to be retained and reducing the need for redoing the entire transaction, thereby improving success rates and resource utilization.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If a DDL transaction is interrupted during execution, then the transaction must be rolled back and re-executed from the beginning, but this leads to low success rates and high resource utilization costs

Engineering Contradiction:

ImproveDDL transaction success rateVSAvoidresource utilization cost

Core Design Contradiction:

ReliabilityVSUse of energy by moving object

Solution Approach 1:

The patent segments the DDL transaction execution process into multiple independent data blocks. Each data block can be processed independently and tracked separately. When an interruption occurs, only the unprocessed blocks need to be re-executed rather than the entire transaction, thereby improving success rates and reducing resource utilization costs by avoiding redundant processing of already-completed blocks.

Inventive Principle:

Principle #1Segmentation

2Productivity

If a DDL transaction processes large data volumes, then more data blocks are involved, but interrupting and re-executing the entire transaction increases time consumption and resource waste

Engineering Contradiction:

Improvetransaction execution efficiencyVSAvoidre-execution time

Core Design Contradiction:

ProductivityVSLoss of time

Solution Approach 1:

The patent implements preliminary tracking of processed data blocks during DDL transaction execution. The system maintains records of which blocks have been successfully processed before any interruption occurs. This preliminary action enables the system to resume execution from the first unprocessed block after an interruption, significantly reducing re-execution time and improving productivity for large data volume transactions.

Inventive Principle:

Principle #10Preliminary action

Data Source

PatentUS12164496B2Transaction execution method, computing device, and storage medium

Publication Date: 2024.12.10 TENCENT TECHNOLOGY (SHENZHEN) CO LTD

AI summary

A transaction execution method, performed by a computing device, includes: determining, in response to a data definition language (DDL) transaction in execution interruption satisfying a resumption condition, a last data block processed by the DDL transaction before the execution interruption; continuing, starting from a next data block following the last data block, executing the DDL transaction; and committing the DDL transaction after data blocks starting from the next data block operated by the DDL transaction are processed.