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

A stored procedure processing method and device

A storage procedure and processing method technology, applied in the field of storage procedure processing methods and devices, can solve problems such as affecting storage procedure performance, storing procedure errors, wasting system resources, etc.

Active Publication Date: 2021-10-01
HUAWEI TECH CO LTD
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If a single-partition stored procedure is run as a multi-partition stored procedure, it not only affects the performance of the stored procedure, but also wastes system resources
And if a multi-partition stored procedure is run as a single-partition stored procedure, it will cause a stored procedure error

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 stored procedure processing method and device
  • A stored procedure processing method and device
  • A stored procedure processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0048] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art with low precision without creative efforts fall within the protection scope of the present invention.

[0049] In order to better understand the technical solution of the present invention, the following briefly describes the applicable application scenarios of the stored procedure processing method provided by the embodiment of the present invention. Such as figure 2 as shown, figure 2 It is a typical application scenario diagram of a distributed database system provided by the embodiment of the present invention. The distributed database sys...

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

A method and device for processing a stored procedure, wherein the method includes: parsing the SQL statement in the stored procedure to be processed into a SQL basic block, and secondly, generating a predicate relationship analysis file based on the predicates in the SQL basic block, and analyzing the predicate relationship analysis The predicates in the file are derived from the derived predicates corresponding to the database tables in the predicate relationship analysis file. Finally, after judging that the database table is cooperatively partitioned, and the predicates corresponding to each partition table in the predicate relationship analysis file include predicates In the case of setting a predicate of parameter assignment type, the stored procedure to be processed is run on a specified partition in the database system. Through the above method, the database system can automatically identify the single partition type of the currently pending stored procedure, and run the pending stored procedure on the specified partition, which is beneficial to improve the overall performance and availability of the database system.

Description

technical field [0001] The present invention relates to the technical field of data storage, in particular to a storage process processing method and device Background technique [0002] A distributed database system refers to a logically unified database system composed of multiple physically dispersed database units connected by a computer network. Each connected database unit is usually called a node, also known as a partition. Tables in a distributed database system are usually divided into partitioned tables and replicated tables. A partitioned table refers to a table that is horizontally split and stored on partitions according to specific columns. A replicated table refers to a table that has complete data in each partition. surface. A tuple is a row in a database table. When tuples in the partition table set {R1, R2, ..., Rn} that contain the same partition column value are all assigned to the same partition, the partition table set is called cooperative partition...

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
IPC IPC(8): G06F16/22G06F16/242G06F16/27G06F16/28
CPCG06F16/00
Inventor 王国平朱俊华
Owner HUAWEI TECH CO LTD