A method for developing dimensional data marts

ABSTRACT

Decision-oriented dimensional data marts are fundamentally different than transaction-oriented relational databases. A distinctive methodology and a different set of tools are required for their effective development.

REFERENCES

• 1: Ackoff, R.L. Management misinformation systems. Management Science 14, 4 (Dec. 1967), B147--B156.
• 2: Gilheany, S. Projecting the cost of magnetic disk storage over the next 10 years. White paper 22011v039h. Archivebuilders.com. Manhattan Beach, CA, 2000; www.archivebuilders.com/whitepapers/22011v039h.html.
• 3: Kimball, R. The Data Warehouse Toolkit. John Wiley, New York, 1996.
• 4: Ralph Kimball, A dimensional modeling manifesto, DBMS, v.10 n.9, p.58-70, Aug. 1997
• 5: Fred R. McFadden , Mary B. Prescott , Jeffrey A. Hoffer, Modern Database Management, Addison-Wesley Longman Publishing Co., Inc., Boston, MA, 1998
• 6: Parkes, C. Data Warehousing: The economy isn't the only reason the data warehouse industry is stumbling. Enterprise Systems (Mar. 1, 2002); www.esj.com/Departments/article.asp?EditorialsID=51
• 7: Catherine M. Ricardo, Database Systems: Principles, Design and Implementation, Prentice Hall PTR, Upper Saddle River, NJ, 1990
• 8: Von Winterfeldt, D. and Edwards, W. Decision Analysis and Behavioral Research. Cambridge University Press, New York, 1986.

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.8 Database applications

Additional Classification:
  D. Software
  D.2 SOFTWARE ENGINEERING
      D.2.1 Requirements/Specifications
      D.2.2 Design Tools and Techniques