Method and device for selecting dimension of aggregation table
A dimension and target selection technology, applied in the field of big data, can solve the problem of inaccurate selection of aggregate table dimensions, and achieve the effect of solving inaccurate dimension selection and reducing overhead.
Active Publication Date: 2020-07-31
BEIJING GRIDSUM TECH CO LTD
View PDF10 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0004] Embodiments of the present invention provide a method and device for selecting dimensions of aggregation tables to at least solve the technical problem of inaccurate selection of dimensions of aggregation tables
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
[0019] In order to enable those skilled in the art to better understand the solutions of the present invention, the following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only It is an embodiment of a part 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 making creative efforts shall fall within the protection scope of the present invention.
[0020] It should be noted that the terms "first" and "second" in the description and claims of the present invention and the above drawings are used to distinguish similar objects, but not necessarily used to describe a specific sequence or sequence. It is to be understood that the data so used are interchangeable under appropriate ...
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 an aggregation table dimension selection method and apparatus. The method comprises the steps of obtaining dimensions in a query record to obtain a first dimension set, whereinthe query record records the dimensions used by all historical queries; performing statistics on a query frequency of each dimension in the query record; establishing a second dimension set, whereinthe second dimension set is initially a null set; and according to the query frequency, selecting target dimensions from the first dimension set and adding the target dimensions to a second dimensionset, until a dimension quantity in the second dimension set reaches a target quantity, wherein the expansion rate of an aggregation table is controllable when the dimension quantity in the second dimension set is equal to the target quantity, the expansion rate of the aggregation table is uncontrollable when the dimension quantity in the second dimension set exceeds the target quantity, and the aggregation table is generated according to the dimensions in the second dimension set. The technical problem of insufficiently accurate aggregation table dimension selection is solved.
Description
technical field [0001] The invention relates to the field of big data, in particular to a method and device for selecting dimensions of an aggregation table. Background technique [0002] The aggregation table is a table containing summary information of the fact data table, which is generated by aggregating the fact data table based on a series of dimensions. Using aggregate tables is a popular technique for improving query response times. This technology calculates the result in advance and stores the result in the table, which reduces the running time of the operation and delivers the result to the user at a faster speed. Aggregate tables typically have fewer rows than fact tables and are therefore faster to process. In the prior art, the creation of the aggregation table is performed through human experience and judgment, and the dimension selection is not precise enough. [0003] For the above problems, no effective solution has been proposed yet. Contents of the i...
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 Patents(China)
IPC IPC(8): G06F16/22
CPCG06F16/2282
Inventor 洪超
Owner BEIJING GRIDSUM TECH CO LTD