A foundation for vacuuming temporal databases
Data & Knowledge Engineering
Temporal and spatio-temporal aggregations over data streams using multiple time granularities
Information Systems - Special issue: Best papers from EDBT 2002
Stream Cube: An Architecture for Multi-Dimensional Analysis of Data Streams
Distributed and Parallel Databases
Specification-based data reduction in dimensional data warehouses
Information Systems
Schema Vacuuming in Temporal Databases
IEEE Transactions on Knowledge and Data Engineering
Multidimensional Data Stream Summarization Using Extended Tilted-Time Windows
WAINA '09 Proceedings of the 2009 International Conference on Advanced Information Networking and Applications Workshops
CAMS: OLAPing Multidimensional Data Streams Efficiently
DaWaK '09 Proceedings of the 11th International Conference on Data Warehousing and Knowledge Discovery
Granularity reduction in temporal document databases
Information Systems
Gradual data aggregation in multi-granular fact tables on resource-constrained systems
KES'10 Proceedings of the 14th international conference on Knowledge-based and intelligent information and engineering systems: Part III
Using a time granularity table for gradual granular data aggregation
ADBIS'10 Proceedings of the 14th east European conference on Advances in databases and information systems
Schema design alternatives for multi-granular data warehousing
DEXA'10 Proceedings of the 21st international conference on Database and expert systems applications: Part II
DOLAP 2011: overview of the 14th international workshop on data warehousing and olap
Proceedings of the 20th ACM international conference on Information and knowledge management
| Hi-index | 0.00 |
In order to keep more detailed data available for longer periods, old data has to be reduced gradually to save space and improve query performance, especially on resource-constrained systems with limited storage and query processing capabilities. In this regard, some hand-coded data aggregation solutions have been developed; however, their actual usage have been limited, for the reason that hand-coded data aggregation solutions have proven themselves too complex to maintain. Maintenance need to occur as requirements change frequently and the existing data aggregation techniques lack flexibility with regards to efficient requirements change management. This paper presents an effective rule-based tool for data reduction based on gradual granular data aggregation. With the proposed solution, data can be maintained at different levels of granularity. The solution is based on high-level data aggregation rules. Based on these rules, data aggregation code can be auto-generated. The solution is effective, easy-to-use and easy-to-maintain. In addition, the paper also demonstrates the use of the proposed tool based on a farming case study using standard database technologies. The results show productivity of the proposed tool-based solution in terms of initial development time, maintenance time and alteration time as compared to a hand-coded solution.