Implementing data cubes efficiently
SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
A general framework for the view selection problem for data warehouse design and evolution
Proceedings of the 3rd ACM international workshop on Data warehousing and OLAP
Physical Database Design for Data Warehouses
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
Selection of Views to Materialize in a Data Warehouse
ICDT '97 Proceedings of the 6th International Conference on Database Theory
Materialized Views Selection in a Multidimensional Database
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Efficient OLAP Operations in Spatial Data Warehouses
SSTD '01 Proceedings of the 7th International Symposium on Advances in Spatial and Temporal Databases
View materialization vs. indexing: balancing space constraints in data warehouse design
CAiSE'03 Proceedings of the 15th international conference on Advanced information systems engineering
Indexing of spatio-temporal telemetric data based on distributed mobile bucket index
PDCN'06 Proceedings of the 24th IASTED international conference on Parallel and distributed computing and networks
Modified R-MVB tree and BTV algorithm used in a distributed spatio-temporal data warehouse
PPAM'07 Proceedings of the 7th international conference on Parallel processing and applied mathematics
Calculation of density-based clustering parameters supported with distributed processing
DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
Answering range-aggregate queries over objects generating data streams
DASFAA'10 Proceedings of the 15th international conference on Database Systems for Advanced Applications - Volume Part II
Multi-dimensional dynamic bucket index based on mobile agent system architecture
DEXA'06 Proceedings of the 17th international conference on Database and Expert Systems Applications
Towards automatic Eps calculation in density-based clustering
ADBIS'06 Proceedings of the 10th East European conference on Advances in Databases and Information Systems
AEC algorithm: a heuristic approach to calculating density-based clustering Eps parameter
ADVIS'06 Proceedings of the 4th international conference on Advances in Information Systems
Multiversion spatio-temporal telemetric data warehouse
ADBIS'09 Proceedings of the 13th East European conference on Advances in Databases and Information Systems
| Hi-index | 0.00 |
In this paper we present a solution called Materialized Aggregate List designed for the efficient storing and processing of long aggregate lists. An aggregate list contains aggregates, calculated from the data stored in the database. In our approach, once created, the aggregates are materialized for further use. The list structure contains a table divided into pages. We present three different page-filling algorithms used when the list is browsed. We present test results and we use them for estimating the best combination of the configuration parameters: number of pages, size of a single page and number of available database connections. The Materialized Aggregate List can be applied on every aggregation level in various indexing structures, such as, an aR-tree.