Abstract
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.T he 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.
Supported by the German Research Society (DFG grant no.GR K 316)
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
R. Agrawal, A. Gupta, and S. Sarawagi. Modeling multidimensional database. In Proc. Data Engineering Conference, Birmingham, pages 232–243, 1997.
T. Feyer, K.-D. Schewe, and B. Thalheim. Conceptual design and development of information services. In T.W. Ling, S. Ram, and M.L. Lee, editors, Conceptual Modeling — ER’ 98, LNCS 1507, pages 7–20.S pringer, 1998.
C. Floyd, F.-M. Re isin, and G. Schmidt. STEPS to software development with users. In C. G hezzi and J.A. McDermid, editors, ESEC’89, LNCS 387, pages 48–64. Springer, Berlin, 1989.
P. Gluchowski. Data warehouse. Informatik Spektrum, 20(1):48–49, 1997.
M. Gyssens and L.V.S. Lakshmanan. A foundation for multidimensional databases. In Proc. 22nd VLDB Conference, Mumbai (Bombay), India, 1996.
B. Jahnke, H.-D. Groffmann, and S. Kruppa. On-line analytical processing (OLAP). Wirtschaftsinformatik, 38(3):321–324, 1996.
R. Kimball. The Data Warehouse Toolkit. John Wiley & Sons, 1996.
J. Lewerenz. On the use of natural language concepts for the conceptual modeling of interaction in information systems.I n Proc. of NLDB’99, Klagenfurt, 1999.
A. Motro. Superviews: Virtual integration of multiple databases. IEEE ToSE, 13(7), 1987.
H. Mucksch, J. Holthuis, and M. Reiser. Das Data-Warehouse-Konzept — Ein Überblick. Wirtschaftsinformatik, 38(4):421–433, 1996.
S.B. Navathe, R. Elmasri, and J.A. Larson. Integrating user views in database design. IEEE Computer, 19(1):50–62, 1986.
N. Pendse. The OLAP Report. A vailable through http://www.olapreport.com/.
B. Schewe. Kooperative Softwareentwicklung — Ein objektorientierter Ansatz. Deutscher Universitatsverlag, Leverkusen, 1996.
B. Schewe and K.-D. Schewe. A user-centered method for the development of dataintensive dialogue systems — an object oriented approach.I n E.D. Falkenberg, W. Hesse, and A. Olivé, editors, Information System Concepts, pages 88–103.Ch apman & Hall, 1995.
K.-D. Schewe and B. Schewe. View centered conceptual modelling — an object oriented approach.In B. Thalheim, editor, Conceptual Modeling — ER’ 96, LNCS 1157, pages 357–371. Springer, 1996.
K.-D. Schewe and B. Schewe. Integrating database and dialogue design. Knowledge and Information Systems, 1999. To appear.
B. Thalheim. Foundations of entity-relationship modeling. Annals of Mathematics and Artificial Intelligence, 7:197–256, 1993.
B. Thalheim. Fundamentals of entity-relationship modeling.Springer, Heidelberg, 1999.
E. Thomson. OLAP Solutions: Building Multidimensional Information Systems. John Wiley & Sons, New York, 1997.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1999 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Lewerenz, J., Schewe, KD., Thalheim, B. (1999). Modelling Data Warehouses and OLAP Applications by Means of Dialogue Objects. In: Akoka, J., Bouzeghoub, M., Comyn-Wattiau, I., Métais, E. (eds) Conceptual Modeling — ER ’99. ER 1999. Lecture Notes in Computer Science, vol 1728. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-47866-3_24
Download citation
DOI: https://doi.org/10.1007/3-540-47866-3_24
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-66686-8
Online ISBN: 978-3-540-47866-9
eBook Packages: Springer Book Archive