Method and device for performing aggregation query in query database
A database and data technology, applied in the field of aggregated query, can solve the problems of data mismatch, inconsistent query result storage, background database cannot be incrementally modified and synchronized, etc.
Pending Publication Date: 2019-11-15
BEIJING OCEANBASE TECH CO LTD
View PDF3 Cites 7 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
However, the pre-computation results obtained by using Kylin are obtained by pre-aggregating and calculating all the data in the database, and the pre-calculation is based on the background database of the system. Due to the delay in the data synchronization of the background database, resulting in background The update of the database cannot be synchronized with the real-time incremental modification of the database. As a result, when there is an incremental modification of the data in the database, the database on which the pre-computation is based cannot be updated in a timely manner, so that the stored pre-computation results are consistent with those in the database. The data does not match, which leads to the inconsistency between the query result of the aggregation query and the actual storage of the database
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
[0035]The subject matter described herein will be discussed below with reference to example implementations. It should be understood that the discussion of these implementations is only to enable those skilled in the art to better understand and realize the subject matter described herein, and is not intended to limit the protection scope, applicability or examples set forth in the claims. Changes may be made in the function and arrangement of elements discussed without departing from the scope of the disclosure. Various examples may omit, substitute, or add various procedures or components as needed. Additionally, features described with respect to some examples may also be combined in other examples.
[0036] As used herein, the term "comprising" and its variants represent open terms meaning "including but not limited to". The term "based on" means "based at least in part on". The terms "one embodiment" and "an embodiment" mean "at least one embodiment." The term "anothe...
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 provides a method and device for performing aggregation query in a query database. The method comprises the steps: after an aggregation query request for querying a database is received,generating dynamic query data corresponding to an aggregation query type based on a dynamic data table; obtaining a static aggregation calculation result, wherein the static aggregation calculation result is obtained by performing aggregation calculation on the static data table according to an aggregation calculation method corresponding to the aggregation query type; performing aggregation calculation on the dynamic query data and the static aggregation calculation result according to an aggregation calculation method to obtain a data query result; and outputting data query results. By utilizing the method, the result of the aggregation query can be kept consistent with the actual situation of the database, so that the accuracy of the aggregation query is improved.
Description
technical field [0001] The present disclosure relates to the technical field of data storage, and in particular, to a method and a device for aggregate query in a query database. Background technique [0002] In databases such as Oracle and MySQL, a large amount of data is usually stored. In an existing database aggregation query, when an aggregation query (Aggregation Query) is performed on a database, all original data rows in the database are scanned, and the scanned data is aggregated to obtain a query result. In this query method, when the amount of data is large, the scanning time for the database will be longer, so that it takes a longer query time, thereby reducing the query efficiency. [0003] In order to improve the efficiency of aggregation query, another aggregation query solution is to use the query engine Kylin to perform aggregation query. In the aggregation query scheme, the query engine Kylin is used to pre-aggregate and calculate the data in the database...
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/2455G06F16/22G06F16/23
CPCG06F16/24556G06F16/2365G06F16/2282
Inventor 赵裕众
Owner BEIJING OCEANBASE TECH CO LTD