Modelling Data Warehouses and OLAP Applications by Means of Dialogue Objects

The idea of data warehouses is to provide condensed information in order to support managers in the analysis of business facts such as sales, costs, profits, etc.alon g various dimensions such as geography, organisation, time, etc. The analysis should allow fast switches between different selected multiple dimensions at different granularity. The task itself is usually called on-line analytical processing (OLAP). We show in this paper how to model data warehouses with OLAP functionality by means of dialogue objects. These are extended and possibly materialised views on collections of operative databases and couple structural and behavioural aspects of application units.

[1]  Bernhard Thalheim,et al.  Conceptual Design and Development of Information Services , 1998, ER.

[2]  Laks V. S. Lakshmanan,et al.  A Foundation for Multi-dimensional Databases , 1997, VLDB.

[3]  Bettina Schewe.  Kooperative Softwareentwicklung - ein objektorientierter Ansatz , 1996, DUV Informatik.

[4]  Professor Dr. Bernhard Thalheim.  Entity-Relationship Modeling , 2000, Springer Berlin Heidelberg.

[5]  Klaus-Dieter Schewe,et al.  Integrating Database and Dialogue Design , 2000, Knowledge and Information Systems.

[6]  Klaus-Dieter Schewe,et al.  A user-centered method for the development of data-intensive dialogue systems: an object-oriented approach , 1995, ISCO.

[7]  Gerhard Schmidt,et al.  STEPS to Software Development with Users , 1989, ESEC.

[8]  Klaus-Dieter Schewe,et al.  View-Centered Conceptual Modelling - An Object-Oriented Approach , 1996, ER.

[9]  Erik Thomsen,et al.  OLAP Solutions - Building Multidimensional Information Systems , 1997 .

[10]  Peter Gluchowski,et al.  Data Warehouse , 1997, Informatik-Spektrum.

[11]  Harry Mucksch,et al.  Das Data Warehouse-Konzept - ein Überblick , 1996, Wirtsch..

[12]  J. Lewerenz.  ON THE USE OF NATURAL LANGUAGE CONCEPTS FOR THE CONCEPTUAL MODELING OF INTERACTION IN INFORMATION SYSTEMS , 1999 .

[13]  Sunita Sarawagi,et al.  Modeling multidimensional databases , 1997, Proceedings 13th International Conference on Data Engineering.

[14]  Amihai Motro,et al.  Superviews: Virtual Integration of Multiple Databases , 1987, IEEE Transactions on Software Engineering.

[15]  James A. Larson,et al.  Integrating User Views in Database Design , 1986, Computer.

[16]  Ralph Kimball,et al.  The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses , 1996 .

[17]  Bernd Jahnke,et al.  On-Line Analytical Processing (OLAP) , 1996, Wirtschaftsinf..

[18]  Peter Gluchowski.  Data Warehouse - Das aktuelle Schlagwort. , 1997 .