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

oltp transaction combination rule and queue model improvement method based on oltpshare

A transaction and queue technology, applied in the field of OLTP transaction processing, can solve the problems of low efficiency of transaction combination and processing, queue model workload, etc., and achieve the effect of improving efficiency

Active Publication Date: 2021-07-23
哈尔滨汇拓投资中心(有限合伙)
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The purpose of the present invention is to solve the problem that the existing OLTP transaction combination rule has low efficiency of transaction combination and processing, and the queue model of the existing OLTPShare cannot cope with the constantly changing workload

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
  • oltp transaction combination rule and queue model improvement method based on oltpshare

Examples

Experimental program
Comparison scheme
Effect test

specific Embodiment approach 1

[0015] DETAILED DESCRIPTION figure 1 As shown, the OLTPSHARE-based OLTP transaction binding rule and the queue model is improved, and the method includes the following steps:

[0016] Step 1. When the new transaction arrives, the SE thread (SQLEXECUTOR, executive executor executing the SQL statement) checks if the new arrival transaction is a single declaration, if the check result is the new arrival transaction is not a single declaration, then new arrival The transaction is uncomfortable, and it is performed by business;

[0017] By transaction execution refers to the implementation of the traditional OLTP transaction method, a transaction execution;

[0018] If the result is a new arrival transaction is a single declaration transaction, the SE thread query the combination rule of the existing queue, and determines whether the newly arrived transaction is added to any queue in the existing queue;

[0019] Existing queue combined rules refers to: Artificial transaction combined r...

specific Embodiment approach 2

[0032] DETAILED DESCRIPTION OF THE INVENTION The present embodiment is a further defined of OLTPSHARE-based OLTP transaction binding rules described in the specific embodiment, and the judgment is judged to add newly reached transactions into any queue in existing. The specific process is:

[0033] The clustering method calculates the similarity of the newly arrived transaction and the existing queue to determine whether the newly arrived transaction is added to any queue in the existing queue.

[0034] First set the transaction feature to be compared, for example, if transaction is compared by 5 features, then use a five-dimensional vector to represent each transaction, x = {x 1 , X 2 , X 3 , X 4 , X 5 }, Then in the coordinate system, the transactions in each queue must be close to it, and it can be seen that obvious clusters (Cluster). Artificial setting a Y value, representing the maximum cluster radius, by calculating the center of each cluster, then calculating the distance ...

specific Embodiment approach 3

[0035] DETAILED DESCRIPTION OF THE INVENTION 3: The present embodiment is a further defined of OLTPSHARE-based OLTP transaction binding rules and queue model modifications to the queue model of one or two, which checks new arrival transactions is a single declaration transaction. It is specific:

[0036] Check if the new arrived transaction consists of only a SQL (SSQL statement, if only one SQL statement consists, the newly arrived transaction is a single declaration transaction, otherwise the newly arrived transaction is not a single declaration.

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 OLTP transaction combination rule and queue model improvement method based on OLTPShare belongs to the technical field of OLTP transaction processing. The invention solves the problems that the existing OLTP transaction combination rules have low efficiency of transaction combination and processing, and that the existing OLTPShare queue model cannot well deal with the constantly changing workload. The present invention abandons the way of manually adding transaction combining rules, and proposes combining rules based on machine learning clustering algorithms that can be automatically generated and dynamically adjusted at runtime, which can increase the efficiency of transaction combining and processing by more than 50%; and the present invention An appendable, mergeable queue model is proposed that automatically adjusts parameter settings at runtime to account for potential workload changes. The invention can be applied to the technical field of OLTP transaction processing.

Description

Technical field [0001] The present invention belongs to the field of OLTP transaction processing, and more particularly to OLTPSHARE-based OLTP (On-line Transaction Processing, online transaction process) transaction combined rules and queue model improvements. Background technique [0002] 89% of the workload required by the 89% CMDBAC open source online project is limited. Therefore, the OLTP workload share has huge application potential in reality. [0003] OLTPSHARE (ON-LINE Transaction Processing (Workloads) Share, OLTP Workload Sharing Technology provides a batch policy for OLTP workload, which makes all coming transactions based on queue-based batch, with the maximum Throughput. However, the transaction binding rules based on the current version of the OLTPSHARE batch before batch of OLTPSHARE are required to be manually developed, resulting in lower efficiency of transaction binding and processing. Moreover, in practical applications, the queue model of Oltpshare does not...

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): G06F9/46G06F9/54G06F16/242
CPCG06F9/466G06F9/546G06F2209/548G06F16/2433
Inventor 赵志强
Owner 哈尔滨汇拓投资中心(有限合伙)