DESIGN AND REPRESENTATION OF THE TIME DIMENSION IN ENTERPRISE DATA WAREHOUSES - A Business Related Practical Approach

Ahmed Hezzah, A Min Tjoa

2004

Abstract

A data warehouse provides a consistent view of business data over time. In order to do that data is represented in logical dimensions, with time being one of the most important dimensions. Representing time, however, is not always straightforward due to the complex nature of time issues and the strong dependence of the time dimension on the type of business. This paper addresses the specific issues encountered during the design of the time dimension for multidimensional data warehouses. It introduces design and modeling techniques for representing time in the data warehouse by the use of one or multiple time dimensions or database timestamps. It also discusses generic problems linked to the design and implementation of the time dimension which have to be considered for (global) business processes, such as representing holidays and fiscal periods, increasing the granularity of business facts, considering the observation of daylight saving time and handling different time zones. These problems seem to have wide application, and yet, more in-depth investigations need to be conducted in this field for real-world time-based analysis in enterprise-wide data warehouses.

References

  1. Bruckner, R., Tjoa A.M., 2001. Managing Time Consistency for Active Data Warehouse Environments, In Proc. of the Third International Conf on Data Warehousing and Knowledge Discovery (DaWaK 2001)
  2. Devlin, B., 1997. The Data Warehouse, from Architecture to Implementation, Addison Wesley Longman, Inc.
  3. Eder, J., Kappel, G., Tjoa, A.M., Wagner, R., 1987, BIER - The Behavior Integrated Entity Relationship
  4. Approach, in: S. Spaccapietra (ed.), Proceedings of the 5th Intenational Conference on Entity-Relationship Approach, North-Holland, Amsterdam
  5. Eder, J., Koncilia, C., 2002. Representing Temporal Data in Non-Temporal OLAP Systems, University of Klagenfurt
  6. Inmon, W., 1996. Building The Data Warehouse, John Wiley & Sons, Inc.
  7. Kimball, R., 1996. The Data Warehouse Toolkit, John Wiley & Sons, Inc.
  8. Kimball, R., 1997. It's Time for Time, DBMS Online
  9. Kimball, R., 1999. The Clickstream Data Mart in the Data Webhouse, Intelligent Enterprise
  10. Kimball, R., 2002. Tricky Time Spans, Intelligent Enterprise
  11. Lang, P., Obermair, W., Schrefl, M., 1997, Modeling Business Rules with Situation/Activation Diagrams, In: A. Gray, P. Larson (eds.): Proceedings of 13th International Conference on Data Engineering (ICDE 7897), Birmingham, U.K., IEEE Computer Society Press
  12. Nguyen, T., Tjoa, A.M., Wagner, R., 2000. An Object Oriented Multidimensional Data Model for OLAP, In Proc. of 1st Int. Conf. on Web-Age Information Management (WAIM 2000)
  13. Pedersen, P., 2001. e-Decisions Transcript, Norwegian School of Economics and Business Administration
  14. Ravat, F., Teste, O., 2000. A Temporal Object-Oriented Data Warehouse Model, DEXA'00
  15. Snodgrass, R., 2000. Developing Time-Oriented Database Applications in SQL, Morgan Kaufmann Publishers
  16. Vaisman, A., Mendelzon, A., Ruaro, W., Cymerman, S., 2002. Supporting Dimension Updates in an OLAP Server, CAiSE'02
  17. Wijsen, J., Ng, R.T., 1999 Temporal Dependencies Generalized for Spatial and Other Dimensions, Proc. Spatio-Temporal Database Management
  18. Wijsen, J., Bès A., 2003, On query optimization in a temporal SPC algebra, Data & Knowledge Engineering, Volume 44
  19. Yang, J., Widom, J., 2000. Temporal View SelfMaintenance in a Warehousing Environment, EDBT'00
Download


Paper Citation


in Harvard Style

Hezzah A. and Min Tjoa A. (2004). DESIGN AND REPRESENTATION OF THE TIME DIMENSION IN ENTERPRISE DATA WAREHOUSES - A Business Related Practical Approach . In Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 972-8865-00-7, pages 416-424. DOI: 10.5220/0002642604160424


in Bibtex Style

@conference{iceis04,
author={Ahmed Hezzah and A Min Tjoa},
title={DESIGN AND REPRESENTATION OF THE TIME DIMENSION IN ENTERPRISE DATA WAREHOUSES - A Business Related Practical Approach},
booktitle={Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2004},
pages={416-424},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002642604160424},
isbn={972-8865-00-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - DESIGN AND REPRESENTATION OF THE TIME DIMENSION IN ENTERPRISE DATA WAREHOUSES - A Business Related Practical Approach
SN - 972-8865-00-7
AU - Hezzah A.
AU - Min Tjoa A.
PY - 2004
SP - 416
EP - 424
DO - 10.5220/0002642604160424