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

A new intelligent transaction optimization method for distributed newsql database

An optimization method and database technology, applied in the field of database transactions, can solve problems such as low concurrency, achieve the effect of improving concurrency performance and data processing efficiency

Active Publication Date: 2022-06-07
SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
View PDF8 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] In order to solve the problem of low concurrency in the transaction writing and reading process existing in the existing distributed NewSQL database, the present invention proposes a novel distributed NewSQL database intelligent transaction optimization method

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
  • A new intelligent transaction optimization method for distributed newsql database
  • A new intelligent transaction optimization method for distributed newsql database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0073] The new distributed NEWSQL database intelligent transaction optimization method has achieved a pass rate of 100% in more than 50 designed scenarios. Here, the simplest and most classic scenarios will be described. The transaction scenarios are shown in the following table:

[0074] Table x.1 Read-write scenarios

[0075] Transaction 1 Transaction 2 (Downgrade) W(X)-Update R(X) Commit R(X)

[0076] This is a classic write-read scenario. In this scenario, transaction 1 performs a write operation on X, and transaction 2 performs a read operation. In the case of transaction downgrade, transaction 2 will be able to immediately read the data before the update of transaction 1. The old version of the data, when transaction 1 commits, transaction 2 will be able to read the new version. Before the transaction is downgraded, the first read operation of transaction 2 will be blocked until the transaction is committed, which will greatl...

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 particularly relates to a novel distributed NEWSQL database intelligent transaction optimization method. This new distributed NEWSQL database intelligent transaction optimization method is based on manually setting the switch to open the optimization scheme, and based on the data flow flow to transmit the switch state; when there is a write-read conflict transaction, first determine whether to optimize; if not optimized, start the original The SSI transaction executor, if optimized, starts the RC transaction executor, and after the transaction execution ends, starts the respective transaction submitters to submit or abort. This new distributed NewSQL database intelligent transaction optimization method solves the problem of low concurrency in the transaction writing and reading process existing in the existing distributed NewSQL database, and can significantly improve the data processing of the database without destroying the ACID characteristics of the database Efficiency improves the concurrency performance of write-read conflict scenarios and achieves the purpose of transaction degradation.

Description

technical field [0001] The invention relates to the technical field of database transactions, in particular to a novel distributed NEWSQL database intelligent transaction optimization method. Background technique [0002] A transaction is a program execution logic unit composed of a series of operations to access and update data in the system. Transactions have four characteristics, namely atomicity (Atomicity), consistency (Consistency), isolation (Isolation) and durability (Durability), referred to as the ACID characteristics of transactions. [0003] Among them, atomicity means that the transaction is an indivisible unit of work, and the operations in the transaction either all occur or none of them occur. Consistency means that the integrity of data before and after a transaction must remain consistent. Transaction isolation means that when multiple users access the database concurrently, the transaction opened by the database for each user cannot be interfered by the ...

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/2453G06F16/2458G06F16/22G06F16/23
CPCG06F16/2453G06F16/2471G06F16/2228G06F16/2365
Inventor 李欣泽高子奇樊文昌马伟科金越金亚杰史大义
Owner SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD