Multi-dimensional range partition cutting method and device and storage medium
A range partitioning, multi-dimensional technology, applied in the field of database query optimization, can solve the problem of long time-consuming partition table scan, achieve the effect of complete and accurate partition cutting, shorten the scan time and narrow the scan range.
Active Publication Date: 2019-07-16
ALIBABA GRP HLDG LTD
View PDF5 Cites 1 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0007] In order to solve the time-consuming problem of multi-dimensional range partition table scanning, the embodiment of the present invention provides a multi-dimensional range partition pruning method, device and storage medium
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0039] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.
[0040] It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The present application will be described in detail below with reference to the accompanying drawings and embodiments.
[0041] figure 1 It is a schematic diagram of the syste...
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
Login to View More Abstract
The invention discloses a multi-dimensional range partition cutting method and device and a storage medium. The method comprises the steps of decomposing an expression used for cutting a data table into a plurality of sub expressions based on the fields of a plurality of dimensional ranges of the data table to be cut; obtaining a sub-range of the sub-expression in the data table; expanding the sub-ranges to generate a plurality of expanded ranges; cutting the data table based on each extension range to obtain each sub-region; and combining the sub-regions to obtain a combined region. Therefore, according to the embodiment of the invention, the multi-dimensional range partition cutting can be supported, the application range of partition cutting is expanded, more arrangement and combinationconditions can be processed, the partition cutting can be thorough and accurate, the subsequent scanning range can be reduced, the scanning time is shortened, and support can be provided for obtaining the accurate target data.
Description
technical field [0001] The present invention relates to the technical field of database query optimization, in particular to a multi-dimensional range partition pruning (Partition Pruning) method, device and storage medium. Background technique [0002] With the rapid development of network technology, the amount of data in the database has increased rapidly, and the era of big data has come. Typically data is stored in the database by region. At the logical layer, data can be divided into multiple partitions and stored in different partition tables; at the physical layer, data can be divided into multiple partitions and stored in different data files or distributed database nodes. In databases containing massive amounts of data, users can obtain target partitions by partition pruning. [0003] Wherein, the partition pruning is to prune the partitions according to the predicate expression, so as to prune those partitions that do not belong to the predicate expression, and ...
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
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/22
CPCG06F16/2264G06F16/2282
Inventor 汪龙重徐冬连杰红郑君正雷春蔚
Owner ALIBABA GRP HLDG LTD