Improved Data Warehousing: Lessons Learnt from the Systems Approach

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.

Authors:

• Roelien Goede

Keywords:

• Data warehouse development
• Information systemsdevelopment
• Interpretive case study
• Systems thinking

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.