PERFORMING PRE-AGGREGATION AND RE-AGGREGATION USING THE SAME QUERY LANGUAGE

摘要

A method includes: obtaining, at time intervals, subsets of data from a database using code of a query language; performing a pre-aggregation on the subsets of data to produce pre-aggregated data; storing the pre-aggregated data in the database; obtaining, in response to a query, at least some of the pre-aggregated data from the database, where the at least some of the pre-aggregated data is obtained using code from the query language used to obtain the subsets of data; and performing a re-aggregation on the pre- aggregated data to produce re-aggregated data.