Temporal and spatio-temporal aggregations over data streams using multiple time granularities
Information Systems - Special issue: Best papers from EDBT 2002
Recent Advances and Research Problems in Data Warehousing
ER '98 Proceedings of the Workshops on Data Warehousing and Data Mining: Advances in Database Technologies
Research in data warehouse modeling and design: dead or alive?
DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
Specification-based data reduction in dimensional data warehouses
Information Systems
Dimensional hierarchies: implementation in data warehouse logical scheme design
CompSysTech '07 Proceedings of the 2007 international conference on Computer systems and technologies
Design Metrics for Data Warehouse Evolution
ER '08 Proceedings of the 27th International Conference on Conceptual Modeling
The Data Warehouse Lifecycle Toolkit
The Data Warehouse Lifecycle Toolkit
A rule-based tool for gradual granular data aggregation
Proceedings of the ACM 14th international workshop on Data Warehousing and OLAP
Incremental integration of data warehouses: the hetero-homogeneous approach
Proceedings of the ACM 14th international workshop on Data Warehousing and OLAP
Daisy: the center for data-intensive systems at Aalborg University
ACM SIGMOD Record
| Hi-index | 0.00 |
Data warehousing is widely used in industry for reporting and analysis of huge volumes of data at different levels of detail. In general, data warehouses use standard dimensional schema designs to organize their data. However, current data warehousing schema designs fall short in their ability to model the multi-granular data found in various real-world application domains. For example, modern farm equipment in a field produces massive amounts of data at different levels of granularity that has to be stored and queried. A study of the commonly used data warehousing schemas exposes the limitation that the schema designs are intended to simply store data at the same single level of granularity. This paper on the other hand, presents several extended dimensional data warehousing schema design alternatives to store both detail and aggregated data at different levels of granularity. The paper presents three solutions to design the time dimension tables and four solutions to design the fact tables. Moreover, each of these solutions is evaluated in different combinations of the time dimension and the fact tables based on a real world farming case study.