Improved Data Warehousing: Lessons Learnt from the Systems Approach

Authors: Roelien Goede

Abstract:

Data warehousing success is not high enough. User dissatisfaction and failure to adhere to time frames and budgets are too common. Most traditional information systems practices are rooted in hard systems thinking. Today, the great systems thinkers are forgotten by information systems developers. A data warehouse is still a system and it is worth investigating whether systems thinkers such as Churchman can enhance our practices today. This paper investigates data warehouse development practices from a systems thinking perspective. An empirical investigation is done in order to understand the everyday practices of data warehousing professionals from a systems perspective. The paper presents a model for the application of Churchman-s systems approach in data warehouse development.

Keywords: Data warehouse development, Information systemsdevelopment, Interpretive case study, Systems thinking

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1078577

References:

[1] J. Mingers and L. White, "A review of the recent contribution of systems thinking to operational research and management science," European Journal of Operational Research, vol. 207, pp. 1147-1161, 2010.
[2] K. Ramamurthy, A. Sen, and A.P. Sinha. "Datawarehousing, fusion and organizational effectiveness." IEEE Transactions on Systems. Man, and Cybernetics - Part A: Systems and Humans, Vol. 38, no. 4, July 2008.
[3] E. Mallach, Decision support systems and data warehousing. Boston, MA: McGraw-Hill. 2000.
[4] J. Han and M. Kamber, Data mining: Concepts and techniques. San Francisco, CA: Morgan Kaufmann. 2001.
[5] A. Sen and A.P. Sinha, "A comparison of datawarehouse methodologies." Communications of the ACM, Vol. 48, no. 3, March 2005.
[6] W.H. Inmon, Building the data warehouse. 2nd ed. New York, NY: Wiley. 1996.
[7] F.R. McFadden, J.A. Hoffer, and M.P. Prescot, Modern database management. 5th ed. Reading, MA: Addison-Westley. 1999.
[8] R. Kimball, L. Reeves, M. Ross, and W. Thornthwaite, The data warehouse lifecycle toolkit. New York, NY: Wiley. 1998.
[9] P. Checkland, Systems thinking, systems practice. Chichester: Wiley. 1981.
[10] R.L. Ackoff, Redesigning the future: A systems approach to societal problems. New York, NY: Wiley. 1974.
[11] G.M. Weinberg, An introduction to general systems thinking. New York, NY: Wiley. 1975.
[12] N.J.T.A. Kramer and J. De Smit, Systems thinking: Concepts and notions. Leiden: Martinus Nijhoff. 1977.
[13] W. Ulrich, "In memory of C. West Churchman (1913-2004) Reminiscences, retrospectives, and reflections," Journal of Organisational Transformation and Social Change, vol. 1, no. 2-3, 2004.
[14] W. Ulrich, "Obituary: C West Churchman, 1913-2004," The Journal of the Operational Research Society, vol. 55, no. 11, pp.1123-1129, Nov. 2004.
[15] H.G. Nelson, "The Legacy of C. West Churchman: A Framework for Social Systems Assessments," Systems Research and Behavioral Science, vol 20, pp. 463-473, 2003.
[16] G. Midgley, Systemic intervention: Philosophy, methodology and practice (contemporary systems thinking). New York, NY: Kluwer Academic/Plenum. 2000.
[17] B. Dahlbom and L. Mathiassen, Computers in context: The philosophy and practice of systems design. Oxford: NCC Blackwell. 1993.
[18] M.C. Jakcson, Systems methodology for the management sciences. New York, NY: Plenum. 1991.
[19] R. Goede, A framework for the explicit use of specific systems thinking methodologies in data-driven decision support system development. Pretoria: UP. 2004.
[20] W. Ulrich, "Critical heuristics of social systems design," in Critical systems thinking: Directed readings, R.L. Flood and M.C. Jackson, Eds. Chichester: Wiley. 1987. pp.103-116.