Reconsidering Multi-Dimensional schemas

ABSTRACT

This paper challenges the currently popular "Data Warehouse is a Special Animal" philosophy and advocates that practitioners adopt a more conservative "Data Warehouse=Database" philosophy. The primary focus is the relevancy of Multi-Dimensional logical schemas. After enumerating the advantages of such schemas, a number of caveats to the presumed advantages are identified. The paper concludes with guidelines and commentary on implications for data warehouse design methodologies.

REFERENCES

• 1: C. J. Date, An introduction to database systems (7th ed.), Addison-Wesley Longman Publishing Co., Inc., Boston, MA, 1999
• 2: Matteo Golfarelli , Stefano Rizzi, A methodological framework for data warehouse design, Proceedings of the 1st ACM international workshop on Data warehousing and OLAP, p.3-9, November 02-07, 1998, Washington, D.C., United States [doi>10.1145/294260.294261]
• 3: Hellerstein, Stonebraker, and Caccia, "Independent, Open Enterprise Data Integration," Bulletin of IEEE Committee on Data Engineering, 1999.
• 4: Matthias Jarke , Maurizio Lenzerini , Yannis Vassiliou , Y. Vassiliou , M. Lenzerini , P. Vassiliadis , Panos Vassiliadis, Fundamentals of Data Warehouses, Springer-Verlag New York, Inc., Secaucus, NJ, 2001
• 5: Kimball, R., <u>The Data Warehouse Toolkit</u>, Wiley, 1996.
• 6: Kimball and Ross, <u>The Data Warehouse Toolkit (2nd ed.)</u>, Wiley, 2002.
• 7: Spencer, T. and Loukas, T., "From Star to Snowflake to ERD: Comparing Data Warehouse Design Approaches," Enterprise Systems Journal, 10/99.
• 8: Panos Vassiliadis , Timos Sellis, A survey of logical models for OLAP databases, ACM SIGMOD Record, v.28 n.4, p.64-69, Dec.1999 [doi>10.1145/344816.344869]
• 9: Thomas Zurek , Markus Sinnwell, Datawarehousing Has More Colours Than Just Black & White, Proceedings of the 25th International Conference on Very Large Data Bases, p.726-729, September 07-10, 1999
• 10: A longer version of this paper, with a short case study, can be obtained at www.rh.edu/~martyn/warehouse.