Specification of management views in information warehouse projects

Information Systems

Volumn 28, Issue 7, 2003, Pages 709-751

  Holten, Roland ^a  

^a UNIVERSITY OF MÜNSTER   (Germany)

Author keywords

Data warehouse development framework; Management view; Meta data; Query generation; Scheme generation

Indexed keywords

ALGORITHMS; INFORMATION MANAGEMENT; METADATA; PROJECT MANAGEMENT;

QUERY GENERATION;

DATA WAREHOUSES;

EID: 0041428174     PISSN: 03064379     EISSN: None     Source Type: Journal    
DOI: 10.1016/S0306-4379(02)00080-7     Document Type: Article

References (78)

1. W.H. Inmon, Building the Data Warehouse, 2nd Edition, Wiley, New York, 1996.
2. W.H. Inmon, R.D. Hackathorn, Using the Data Warehouse, Wiley, New York, 1994.
3. W.H. Inmon, J.D. Welch, K.L. Glasey, Managing the Data Warehouse, New York, 1997.
4. J. Becker, R. Holten, Fachkonzeptuelle Spezifikation von Führungsinformationssystemen, Wirtschaftsinformatik 40 (6) (1998) 483-492.
5. S. Chaudhuri, U. Dayal, An overview of data warehousing and olap technology, ACM SIGMOD Record 26 (1) (1997) 65-74.
6. J. Widom, Research problems in data warehousing, Proceedings of the 4th International Conference on Information and Knowledge Management, ACM, New York, 1995.
7. P. Vassiliadis, Gulliver in the land of data warehousing: practical experiences and observations of a researcher, Proceedings of the International Workshop on Design and Management of Data Warehouses (DMDW'2000), Stockholm, Sweden, June 5-6, 2000, http://SunSITE.Informatik.RWTH-Aachen.DE/Publications/CEUR-WS/Vol-28/.
8. S. Agarwal, R. Agrawal, P.M. Deshpande, A. Gupta, J.F. Naughton, R. Ramakrishnan, S. Sarawagi, On the computation of multidimensional aggregates, Proceedings of the 22nd International Conference on Very Large Data Bases, Morgan Kaufmann, San Francisco, CA, 1996, pp. 506-521.
9. L. Cabibbo, R. Torlone, An architecture for data warehousing supporting data independence and interoperability, Internat. J. Cooperative Inform. Systems 10 (3) (2001) 377-397.
10. E.F. Codd, S.B. Codd, C.T. Salley, Providing olap (on-line analytical processing) to user analysts: an IT mandate, white paper, E.F. Codd & Associates, 1993, http://www.arborsoft.com/essbase/wht_ppr/coddTOC.html, downloaded 1998-06-05.
11. G. Colliat, OLAP, relational, and multidimensional database systems, ACM SIGMOD Record 25 (3) (1996) 64-69.
12. R.G. Eccles, The performance measurement manifesto, Harvard Business Rev. 69 (1991) 131-137.
13. M. Gyssens, L.V.S. Lakshmanan, A foundation for multi-dimensional databases, Proceedings of the 23rd International Conference on Very Large Data Bases, San Francisco, CA, Morgan Kaufmann, Los Altos, CA, 1997, pp. 106-115.
14. OLAP Council, OLAP and OLAP Server Definitions, http://www.olapcouncil.org/research/glossaryly.htm 1997, downloaded 1998-06-03.
15. P. Vassiliadis, T. Sellis, A survey of logical models for olap databases, Sigmod Record 28 (4) (1999) 64-69.
16. H. Wedekind, J. Albrecht, H. Günzel, W. Lehner, Repositories for data warehouse systems in a middleware environment, Fifth International Conference on Information Systems Analysis and Synthesis, ISAS'99, Orlando, Florida, July 31-August 4 1999.
17. H.P. Borgman, Manager's information search behaviour using management support systems, Wirtschaftsinformatik 40 (6) (1998) 527-535.
18. M. Golfarelli, D. Maio, S. Rizzi, Conceptual design of data warehouses from E/R schemes, Proceedings of the Hawaii International Conference on Systems Science, January 6-9, IEEE, London, 1998.
19. M. Jarke, M.A. Jeusfeld, C. Quix, P. Vassiliadis, Architecture and quality in data warehouses, an extended repository approach, Inform. Systems 24 (3) (1999) 229-253.
20. M. Jarke, M. Lenzerini, Y. Vassiliou, P. Vassiliadis, Fundamentals of Data Warehouses, Berlin, 2000.
21. H.W. Nissen, M. Jeusfeld, M. Jarke, G.V. Zemanek, H. Huber, Managing multiple requirements perspectives with metamodels, IEEE Software 13 (3) (1996) 37-48.
22. K. Pohl, Process-Centered Requirements Engineering, Research Studies Press, Taunton, Somerset, 1996.
23. H. Wedekind, Datenbanksysteme I, Eine konstruktive Einführung in die Datenverarbeitung in Wirtschaft und Verwaltung, 2nd Edition, Mannheim, 1981.
24. H. Wedekind, Objektorientierte Schemeentwicklung, Ein kategorialer Ansatz für Datenbanken und Programmierung, Mannheim, 1992.
25. B. Boehm, Software-Engineering Economics, Prentice-Hall, Englewood Cliffs, NJ, 1981.
26. A.M. Davis, The analysis and specification of systems and software requirements, in: R.H. Thayer, M. Dorfman (Eds.), Systems and Software Requirements Engineering, IEEE Computer Society Press-Tutorial, Silver Spring, MD, 1990, pp. 119-134.
27. A.M. Davis, E.H. Bersoff, E.R. Comer, A strategy for comparing alternative software development life cycle models, IEEE Trans. Software Eng. 10 (14) (1988) 1453-1461.
28. M. Weske, T. Goesmann, R. Holten, R. Striemer, A reference model for workflow application development processes, Proceedings of the International Joint Conference on Work Activities Coordination and Collaboration (WACC), San Francisco, CA 1999, ACM, New York, pp. 1-10.
29. A.-W. Scheer, ARIS - Business Process Frameworks, 3rd Edition, Springer, Berlin, 1999.
30. A.-W. Scheer, ARIS - Business Process Modeling, 3rd Edition, Springer, Berlin, 2000.
31. A.-W. Scheer, Business Process Engineering, 3rd Edition, Springer, Berlin, 1998.
32. M. Golfarelli, S. Rizzi, Designing the data warehouse: key steps and crucial issues, J. Comput. Sci. Inform. Manage. 2 (1) (1999) 1-14.
33. M. Golfarelli, S. Rizzi, A methodological framework for data warehouse design, in: Proceedings ACM First International Workshop on Data Warehousing and OLAP (DOLAP), Washington, 1998.
34. M. Golfarelli, D. Maio, S. Rizzi, The dimensional fact model: a conceptual model for data warehouses, Int. J. Cooperative Inform. Systems 7 (2-3) (1998) 215-247.
35. J. Lechtenbörger, Data Warehouse Scheme Design, Akademische Verlagsgesellschaft Aka, Berlin, 2001.
36. B. Hüsemann, J. Lechtenbörger, G. Vossen, Conceptual data warehouse design, Proceedings of the International Workshop on Design and Management of Data Warehouses (DMDW'2000), Stockholm, Sweden, June 5-6, 2000, http://SunSITE.Informatik.RWTH-Aachen.DE/Publications/CEUR-WS/Vol-28/.
37. D.L. Moody, M.A.R. Kortink, From enterprise models to dimensional models: a methodology for data warehouse and data mart design, Proceedings of the International Workshop on Design and Management of Data Warehouses (DMDW'2000), Stockholm, Sweden, June 5-6, 2000, http://SunSITE.Informatik.RWTH-Aachen.DE/Publications/CEUR-WS/Vol-28/.
38. C. Phipps, K.C. Davis, Automating data warehouse conceptual scheme design and evaluation, in: Lakshmanan, Lakas V.S. (Ed.), Design and Management of Data Warehouses 2002, Proceedings of the 4th International Workshop DMDW'2002, Toronto, Canada, May 27, 2002, pp. 23-32, http://sunsite.informatik.rwth-aachen.de/Publications/CEUR-WS/Vol-58/ phipps-davis.pdf.
39. K. Hahn, C. Sapia, M. Blaschka, Automatically generating OLAP schemeta from conceptual graphical models, Proceedings of the ACM DOLAP 2000 Workshop, 2000, pp. 9-16.
40. D. Calvanese, G. De Giacomo, M. Lenzerini, D. Nardi, R. Rosati, Data integration in data warehousing, Internat. J. Cooperative Inform. Systems 10 (3) (2001) 237-271.
41. C. Sapia, M. Blaschka, G. Höfling, GraMMi: using a standard repository management system to build a generic graphical modeling tool, Proceedings of the 33rd Hawaii International Conference on System Sciences (HICSS-33), Maui, Hawaii, USA, 2000.
42. N. Tryfona, F. Busborg, J.G. Borch Christiansen, starER, A conceptual model for data warehouse design, Proceedings of the DOLAP '99, ACM Second International Workshop on Data Warehousing and OLAP, November 6, 1999, Kansas City, Missouri, USA, Proceedings ACM 1999, pp. 3-8.
43. M. Böhnlein, Konstruktion semantischer Data-Warehouse-Schemeta, Deutscher Universitäts-Verlag, Wiesbaden, 2001.
44. G.M. Freitas, A.H.F. Laender, M.L. Campos, MD2 - Getting users involved in the development of data warehouse applications, in: L.V.S. Lakshmanan (Ed.), Design and Management of Data Warehouses 2002, Proceedings of the 4th International Workshop DMDW'2002, Toronto, Canada, May 27, 2002, pp. 3-12, http://sunsite.informatik.rwth-aachen.de/Publications/ CEUR-WS/Vol-58/laender.pdf.
45. R. Holten, Entwicklung von Führungsinformationssystemen, Ein methodenorientierter Ansatz, Wiesbaden, 1999.
46. ISO: ISO/IEC 10027: Information Technology. Information Resource Dictionary Systems (IRDS)-Framework, ISO/IEC Intl. Standard, 1990.
47. S. Jacobs, R. Holten, Goal driven business modeling. Supporting decision making within information systems development, in: N. Comstock, C. Ellis, R. Kling, J. Mylopoulos, S. Kaplan (Eds.), Conference on Organizational Computing Systems, August 13-16, Milipatis, California, USA, ACM Press, New York, 1995, pp. 96-105.
48. IEEE-830, Guide to Software Requirements Specification, ANSI/IEEE Std. 830, 1984.
49. S.M. McMenamin, J.F. Palmer, Essential System Analysis, Yourdon Press, Prentice-Hall, Englewood Cliffs, NY, 1984.
50. E.F. Codd, The Relational Model for Database Management, Version 2, Addison-Wesley, Reading, MA, 1990.
51. C.J. Date, An Introduction to Database Systems, Vol. 1, 5th Edition, Addison-Wesley, Reading, MA, 1990.
52. D.W. Embley, Object Database Development. Concepts and Principles, Addison-Wesley, Reading, MA, 1998.
53. A. Gupta, E. Horowitz, Object-Oriented Databases with Applications to CASE, Networks, and VLSI CAD, Prentice-Hall, Englewood-Cliffs, NJ, 1991.
54. H. Balzert, From OOA to GUIs: the JANUS system, J. Object-Oriented Program. 2 (1996) 43-47.
55. M. Nagl, Softwaretechnik. Methodisches Programmieren im Großen, Berlin, Heidelberg, 1990.
56. C. Batini, S. Ceri, S.B. Navathe, Conceptual database design. An Entity-Relationship Approach, Benjamin, Cummings, Redwood City, 1992.
57. R. Elmasri, S.B. Navathe, Fundamentals of Database Systems, 3rd Edition, Addison-Wesley, Redwood City, 2000.
58. G. Vossen, Data models, Database Languages and Database Management Systems, 4th Edition, Oldenbourgh, München, Wien, 2000 (in German).
59. P. Riebel, Gestaltungsprobleme einer zweckneutralen Grundrechnung, ZfbF 31 (1979) 863-893.
60. P. Riebel, Einzelerlös-, Einzelkosten- und Deckungsbeitragsrechung als Kern einer ganzheitlichen Führungsrechung, in: W. Männel (Ed.), Handbuch Kostenrechnung, Wiesbaden, 1992, pp. 247-299.
61. J. Schelp, Konzeptionelle Modellierung mehrdimensionaler Datenstrukturen, in: P. Chamoni, P. Gluchowski (Eds.), Analytische Informationssysteme. Data Warehouse, On-Line Analytical Processing, Data Mining, 2nd Edition, Springer, Berlin, 1999, pp. 281-306.
62. CCG, Standard-Warngruppenklassifikation für Verbrauchsgüter, Gebrauchsgüter, Investitionsgüter und Rohstoffe, 2nd Edition, Centrale für Coorganisation GmbH, Cologne, 1997.
63. M. Blaschka, C. Sapia, G. Höfling, B. Dinter, Finding your way through multidimensional data models, Proceedings of the International Workshop on Data Warehouse Design and OAP Technology, DWDOT 1998, Vienna, Austria, August 28, 1998, pp. 198-203.
64. D. Bulos, OLAP Database Design. A new dimension, database programming & design (DBPD), 9(6) (1996) 33-37.
65. C. Sapia, M. Blaschka, G. Höfling, B. Dinter, Extending the E/R model for the multidimensional paradigm, Proceedings of the International Workshop on Data Warehouse and Data Mining (DWDM 1998) Singapore, November 19-20 1998, Springer, Berlin, 1998, pp. 105-116.
66. T. Copeland, T. Koller, J. Murrin, Valuation: Measuring and Managing the Value of Companies, Wiley, New York, 1990.
67. H.T. Johnson, R.S. Kaplan, Relevance Lost: The Rise and Fall of Management Accounting, Harvard Business School Press, Boston, 1987.
68. R.S. Kaplan, D.P. Norton, Why does business need a balanced scorecard, J. Cost Manage. 11 (3) (1997) 5-10.
69. R.S. Kaplan, D.P. Norton, Translating Strategy into Action, The Balanced Scorecard, Boston, MA, 1996.
70. R.S. Kaplan, D.P. Norton, The balanced score card. Measures that drive business performance, Harvard Business Rev. 70 (1992) 71-79.
71. I. Lapsley, F. Mitchel, The Accounting Challenge: Accounting and Performance Measurement, London, 1996.
72. R.A. Brealey, S.C. Myers, Principles of Corporate Finance, 5th Edition, McGraw-Hill Companies, Inc., New York, 1996.
73. T. Stöhr, R. Müller, E. Rahm, An integrative and uniform model for metadata management in data warehousing environments, in: S. Gatztiu, M. Jeusfeld, M. Staudt, Y. Vassiliou (Eds.), Proceedings of the International Workshop on Design and Management of Data Warehouses (DMDW'99), http://sunsite.informatik.rwth-aachen.de/Publications/CEUR-WS/Vol-19/, downloaded 1999-07-12.
74. A. Tsois, N. Karayannidis, T. Sellis, D. Theodoratos, Cost-based optimization of aggregation star queries on hierarchically clustered data warehouses, in: L.V.S. Lakshmanan (Ed.), Design and Management of Data Warehouses 2002, Proceedings of the 4th International Workshop DMDW'2002, Toronto, Canada, May 27, 2002, pp. 62-71, http://sunsite.informatik.rwth-aachen.de/ Publications/CEUR-WS/Vol-58/tsois.pdf.
75. P. Vassiliadis, M. Bouzeghoub, C. Quix, Towards quality-oriented data warehouse usage and evolution, Information Systems 25 (2) (2000) 89-115.
76. R. Holten, Framework and method for information warehouse development processes, in: R. Jung, R. Winter (Eds.), Data Warehousing 2000-Methoden, Anwendungen, Strategien, Heidelberg, 2000, pp. 135-163.
77. J. Crisandt, Integration eines SQL-generators für ROLAP-anfragen in eine data-warehouse-entwicklungsumgebung, Master Thesis, Universität Münster, 2000.
78. J. Hilbers, Integration eines Scheme generators in eine data-warehouse-entwicklungsumgebung, Master Thesis, Universität Münster, 2000.