Advertisement

Databases and Data Warehouses for Decision Support

  • Rob Meredith
  • Peter O’Donnell
  • David Arnott
Part of the International Handbooks Information System book series (INFOSYS)

Abstract

The modern approach to the development of decision support systems (DSS) typically makes extensive use of integrated repositories of data known as a data warehouse. These are often large, complex systems that have unique design and operational requirements that are significantly different to other kinds of databases, despite generally using the same relational database technologies as other systems. This chapter provides an overview of the purpose and design requirements of data warehouses, including approaches to data modeling and structuring of the technical architecture, as well as current trends and practices in the field.

Keywords

Decision Support System Data Warehouse Business Intelligence Source System Enterprise Resource Planning System 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. .Ackoff, R., “Management Misinformation Systems,” Manage Sci, 14(4), 1967, 147-156.CrossRefGoogle Scholar
  2. Alter, S., Decision Support Systems: Current Practice and Continuing Challenges. Reading, Massachusetts: Addison-Wesley, 1980.Google Scholar
  3. Armstrong, R., Responding to Ralph: A Rebuttal to the Dimensional Modeling Manifesto (White Paper): NCR Corporation, 1997.Google Scholar
  4. Arnott, D., Data Warehouse and Business Intelligence Governance : An Empirical Study. Paper presented at the 2006 IFIP WG8.3 International Conference on DSS, 2006.Google Scholar
  5. Arnott, D. and G. Pervan, “A Critical Analysis of Decision Support Systems Research,” J Inform Technol, 20(2), 2005, 67-87.CrossRefGoogle Scholar
  6. Ashenfelter, J., “Data Warehousing with MySQL” [Electronic Version], 2006, Presentation at the 2006 MySQL Users Conference, 24 April, 2006 from http://www.transitionpoint.com/downloads/mysqluc2006.zip.Google Scholar
  7. Chen, P., “The Entity Relationship Model: Towards a Unified View of Data,” ACM TODS, 1(1), 1976, 9-36.CrossRefGoogle Scholar
  8. Computerworld, “Microsoft Aims High on Data Warehouses” [Electronic Version], 2006, Computerworld, retrieved 27th November, 2006 from http://www.computerworld.com/action/article.do?command= viewArticleBasic&taxonomyName=business_intelligence&articleId= 274454&taxonomyId=9&intsrc=kc_top.Google Scholar
  9. Davenport, T.H., R.G. Eccles and L. Prusak, “Information Politics,” Sloan Manage Rev, 34(1), 1992, 53-65.Google Scholar
  10. Dubin, R., Theory Building. New York: The Free Press, 1978.Google Scholar
  11. Gaskell, R., “The Data Warehouse Appliance Myth” [Electronic Version], 2005, DMReview from http://www.dmreview.com/editorial/newsletter_article.cfm?articleId=1029817.Google Scholar
  12. Gates, W., Business @ the Speed of Thought. New York: Warner Books Inc., 2000.Google Scholar
  13. Gibson, M. and D. Arnott, The Evaluation of Business Intelligence: A Case Study in a Major Financial Institution. Paper presented at the 2005 Australasian Conference on Information Systems, Sydney, Australia, 2005.Google Scholar
  14. Hillard, R., P. Blecher and P. A. O’Donnell, The Implications of Chaos Theory on the Management of a Data Warehouse. Paper presented at the 1999 International Society of Decision Support Systems Conference, Melbourne, Australia, 1999.Google Scholar
  15. Inmon, W.H., Building the Data Warehouse. New York: John Wiley & Sons, 1992.Google Scholar
  16. Inmon, W.H. and R.D. Hackathorn, Using the Data Warehouse. New York: John Wiley & Sons, 1994.Google Scholar
  17. Keen, P.G.W., “Adaptive Design for Decision Support Systems,” Data Base, 12, 1980, 15-25.Google Scholar
  18. Kimball, R., “Why Decision Support Fails and How to Fix It,” Datamation (June), 1994, 41-45.Google Scholar
  19. Kimball, R., The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouse s. New York: John Wiley & Sons, 1996.Google Scholar
  20. Kimball, R., “A Dimensional Modeling Manifesto” [Electronic Version], 1997, DBMS Magazine from http://www.dbmsmag.com/9708d15.html.Google Scholar
  21. Kimball, R., “Kimball Design Tip #18: Taking the Publishing Metaphor Seriously,” 2001, Retrieved 8th June, 2007, from http://kimballgroup.com/html/designtipsPDF/DesignTips2001/ KimballDT18Taking.pdf.Google Scholar
  22. Kimball, R., L. Reeves, M. Ross and W. Thorthwaite, The Data Warehouse Lifecycle Toolkit. New York: Wiley, 1998.Google Scholar
  23. Kotter, J.P., “What Effective Managers Really Do,” Harvard Bus Rev, 60(6), 156-167.Google Scholar
  24. Linstedt, D.E., “Active and Right-Time Data Warehousing Defined,” 2006, Blog: Dan E. Linstedt retrieved 10th January, 2007, from http://www.b-eye-network.com/blogs/linstedt/archives/2006/01/active_and_righ.php.Google Scholar
  25. McFadden, F.R., “Data Warehouse for EIS: Some Issues and Impacts,” in Nunamaker J.F. and Sprague R.H. (eds.), Proceedings of the 29th Hawaii International Conference on System Sciences (Vol. 2, pp. 120-129). IEEE Computer Science Press, 1996.Google Scholar
  26. Mintzberg, H., The Nature of Managerial Work. New York: Harper and Row, 1973.Google Scholar
  27. Moscato, D. and P. A. O’Donnell, “Delivering Warehouse Data Over The Web: A Case Study,” J Data Warehousing, 5(2), 2000, 46-53.Google Scholar
  28. Pervan, G. and D. Arnott, “Research in Data Warehousing and Business Intelligence,” in Adam F., Brezillon P., Carlsson S. and Humphreys P.C. (eds.), Creativity and Innovation in Decision Making and Decision Support (pp. 985-1003). London: Ludic Publishing, 2006.Google Scholar
  29. Russom, P., “Defining the Data Warehouse Appliance,” 2005, retrieved 10th January, 2007, from http://www.tdwi.org/publications/display.aspx?id=7784.Google Scholar
  30. Simon, H.A., The New Science of Management Decision (3rd Revised ed.). Englewood Cliffs, New Jersey, USA: Prentice Hall, 1977.Google Scholar
  31. Watson, H.J., C. Fuller and T. Ariyachandra, “Data Warehouse Governance: Best Practices at Blue Cross and Blue Shield of North Carolina,” Decis Support Syst, 38, 2004, 435-450.CrossRefGoogle Scholar
  32. Weldon, J.-L., “Managing Multidimensional Data: Harnessing the Power,” Database Program Design (August), 1995, 24-33.Google Scholar
  33. Wheatley, M., “The Myths of Open Source” [Electronic Version], 2004, CIO Magazine, retrieved 12th January, 2007 from http://www.cio.com/archive/030104/open.html.Google Scholar
  34. Winter Corporation, “TopTen Program,” 2006. Retrieved 12th December, 2006, from http://www.wintercorp.com/VLDB/2005_TopTen_Survey/TopTenProgram.html.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2008

Authors and Affiliations

  • Rob Meredith
    • 1
  • Peter O’Donnell
    • 1
  • David Arnott
    • 1
  1. 1.Centre for Decision Support and Enterprise Systems ResearchMonash UniversityClaytonAustralia

Personalised recommendations