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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
.Ackoff, R., “Management Misinformation Systems,” Manage Sci, 14(4), 1967, 147-156.
Alter, S., Decision Support Systems: Current Practice and Continuing Challenges. Reading, Massachusetts: Addison-Wesley, 1980.
Armstrong, R., Responding to Ralph: A Rebuttal to the Dimensional Modeling Manifesto (White Paper): NCR Corporation, 1997.
Arnott, D., Data Warehouse and Business Intelligence Governance : An Empirical Study. Paper presented at the 2006 IFIP WG8.3 International Conference on DSS, 2006.
Arnott, D. and G. Pervan, “A Critical Analysis of Decision Support Systems Research,” J Inform Technol, 20(2), 2005, 67-87.
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.
Chen, P., “The Entity Relationship Model: Towards a Unified View of Data,” ACM TODS, 1(1), 1976, 9-36.
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.
Davenport, T.H., R.G. Eccles and L. Prusak, “Information Politics,” Sloan Manage Rev, 34(1), 1992, 53-65.
Dubin, R., Theory Building. New York: The Free Press, 1978.
Gaskell, R., “The Data Warehouse Appliance Myth” [Electronic Version], 2005, DMReview from http://www.dmreview.com/editorial/newsletter_article.cfm?articleId=1029817.
Gates, W., Business @ the Speed of Thought. New York: Warner Books Inc., 2000.
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.
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.
Inmon, W.H., Building the Data Warehouse. New York: John Wiley & Sons, 1992.
Inmon, W.H. and R.D. Hackathorn, Using the Data Warehouse. New York: John Wiley & Sons, 1994.
Keen, P.G.W., “Adaptive Design for Decision Support Systems,” Data Base, 12, 1980, 15-25.
Kimball, R., “Why Decision Support Fails and How to Fix It,” Datamation (June), 1994, 41-45.
Kimball, R., The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouse s. New York: John Wiley & Sons, 1996.
Kimball, R., “A Dimensional Modeling Manifesto” [Electronic Version], 1997, DBMS Magazine from http://www.dbmsmag.com/9708d15.html.
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.
Kimball, R., L. Reeves, M. Ross and W. Thorthwaite, The Data Warehouse Lifecycle Toolkit. New York: Wiley, 1998.
Kotter, J.P., “What Effective Managers Really Do,” Harvard Bus Rev, 60(6), 156-167.
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.
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.
Mintzberg, H., The Nature of Managerial Work. New York: Harper and Row, 1973.
Moscato, D. and P. A. O’Donnell, “Delivering Warehouse Data Over The Web: A Case Study,” J Data Warehousing, 5(2), 2000, 46-53.
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.
Russom, P., “Defining the Data Warehouse Appliance,” 2005, retrieved 10th January, 2007, from http://www.tdwi.org/publications/display.aspx?id=7784.
Simon, H.A., The New Science of Management Decision (3rd Revised ed.). Englewood Cliffs, New Jersey, USA: Prentice Hall, 1977.
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.
Weldon, J.-L., “Managing Multidimensional Data: Harnessing the Power,” Database Program Design (August), 1995, 24-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.
Winter Corporation, “TopTen Program,” 2006. Retrieved 12th December, 2006, from http://www.wintercorp.com/VLDB/2005_TopTen_Survey/TopTenProgram.html.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2008 Springer-Verlag Berlin Heidelberg
About this chapter
Cite this chapter
Meredith, R., O’Donnell, P., Arnott, D. (2008). Databases and Data Warehouses for Decision Support. In: Handbook on Decision Support Systems 1. International Handbooks Information System. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-48713-5_11
Download citation
DOI: https://doi.org/10.1007/978-3-540-48713-5_11
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-48712-8
Online ISBN: 978-3-540-48713-5
eBook Packages: Computer ScienceComputer Science (R0)