Abstract
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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Samtani, S., Mohania, M., Kumar, V., Kambayashi, Y.: Recent Advances and Research Problems in Data Warehousing. In: Kambayashi, Y., Lee, D.-L., Lim, E.-p., Mohania, M., Masunaga, Y. (eds.) ER Workshops 1998. LNCS, vol. 1552, pp. 81–92. Springer, Heidelberg (1999)
Kimball, R.: The Data Warehousing Toolkit. Wiley Computer Publishing, NY (2002)
Kimball Design, http://www.kimballgroup.com/html/designtipsPDF/KimballDT61HandlingAll.pdf
Shoshani, A.: Summarizability. Encyclopedia of Database Sys. 19, 2880–2884 (2009)
UTC, http://en.wikipedia.org/wiki/Coordinated_Universal_Time
Logical Table Design and Queries, http://www.cs.aau.dk/~nadeem/queries.htm
Zhang, D., Gunopulos, D., Tsotras, V.J., Seeger, B.: Temporal and Spatio-Temporal Aggregations over Data Streams using Multiple Time Granularities. Info. Sys. 28(1-2), 61–84 (2003)
Boly, A., Hébrail, G., Goutier, S.: Forgetting Data Intelligently in Data Warehouses. In: IEEE Conference on Research, Innovat. and Vision for the Future, pp. 220–227. IEEE Press, NY (2007)
Skyt, J., Jensen, C.S., Pedersen, T.B.: Specification-based Data Reduction in Dimensional Data Warehouses. Info. Sys. 33(1), 36–63 (2008)
Iftikhar, N.: Integration, Aggregation and Exchange of Farming Device Data: A High Level Perspective. In: 2nd IEEE Conf. on the Applications of Digital Info., pp. 14–19. IEEE Press, NY (2009)
Rozeva, A.: Dimensional Hierarchies: Implementation in Data Warehouse Logical Schema Design. In: International Conference on Computer Systems and Tech., article 46. ACM Press, NY (2007)
Papastefanatos, G., Vassiliadis, P., Simitsis, A., Vassiliou, Y.: Design Metrics for DW Evolution. In: Li, Q., Spaccapietra, S., Yu, E., Olivé, A. (eds.) ER 2008. LNCS, vol. 5231, pp. 440–454. Springer, Heidelberg (2008)
Rizzi, S., Abello, A., Lechtenborger, J., Trujillo, J.: Research in Data Warehouse Modeling and Design: Dead or Alive? In: 9th ACM Int. Workshop on DW and OLAP, pp. 3–10. ACM Press, NY (2006)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2010 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Iftikhar, N., Pedersen, T.B. (2010). Schema Design Alternatives for Multi-granular Data Warehousing. In: Bringas, P.G., Hameurlain, A., Quirchmayr, G. (eds) Database and Expert Systems Applications. DEXA 2010. Lecture Notes in Computer Science, vol 6262. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-15251-1_8
Download citation
DOI: https://doi.org/10.1007/978-3-642-15251-1_8
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-15250-4
Online ISBN: 978-3-642-15251-1
eBook Packages: Computer ScienceComputer Science (R0)