Abstract
Database and information systems technology has substantially changed. Nowadays, content management systems, (information-intensive) web services, collaborating systems, internet databases, OLAP databases etc. have become buzzwords. At the same time, object-relational technology has gained the maturity for being widely applied. Conceptual modelling has not (yet) covered all these novel topics. It has been concentrated for more than two decades around specification of structures. Meanwhile, functionality, interactivity and distribution must be included into conceptual modelling of information systems. Also, some of the open problems that have been already discussed in 1987 [15, 16] still remain to be open. At the same time, novel models such as object-relational models or XML-based models have been developed. They did not overcome all the problems but have been sharpening and extending the variety of open problems. The open problem presented are given for classical areas of database research, i.e., structuring and functionality. The entire are of distribution and interaction is currently an area of very intensive research.
The presentation of open problems is combined with the introduction to the achievements of conceptual modelling. The paper develops an approach to conceptual modelling for object-relational, collaborating information systems that support virtual communities of work, integration of information systems, varieties of architecture such as the OLTP-OLAP architecture, varieties of play-out and play-in systems, and data analysis engines. The paper is based on an extended entity-relationship model that covers all structuring facilities of object-relational systems. It uses the theory of media types and storyboards for the specification of interactivity and provides a framework for collaboration.
The paper presents 20 open problems that need to be solved for conceptual modelling. The problems are sketched. Main references and the background are given. Additional references can be provided by the author on demand.
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
Beeri, C., Thalheim, B.: Identification as a primitive of database models. In: Polle, T., Ripke, T., Schewe, K.-D. (eds.) FoMLaDO 1998. Proc. Fundamentals of Information Systems, 7th Int. Workshop on Foundations of Models and Languages for Data and Objects, Timmel, Ostfriesland, pp. 19–36. Kluwer, London (1999)
Börger, E., Stärk, R.: Abstract state machines - A method for high-level system design and analysis. Springer, Berlin (2003)
Demetrovics, J., Molnar, A., Thalheim, B.: Graphical and spreadsheet reasoning for sets of functional dependencies. In: Atzeni, P., Chu, W., Lu, H., Zhou, S., Ling, T.-W. (eds.) ER 2004. LNCS, vol. 3288, pp. 54–66. Springer, Heidelberg (2004)
Jaakkola, H., Thalheim, B.: Software quality and life cycles. In: Eder, J., Haav, H.-M., Kalja, A., Penjam, J. (eds.) ADBIS 2005. LNCS, vol. 3631, pp. 208–220. Springer, Heidelberg (2005)
Kaschek, R.: Konzeptionelle Modellierung. PhD thesis, University Klagenfurt, Habilitationsschrift (2003)
Lenz, H.-J., Thalheim, B.: OLAP databases and aggregation functions. In: 13th SSDBM 2001, pp. 91–100 (2001)
Lenz, H.-J., Thalheim, B.: OLTP-OLAP schemes for sound applications. In: Draheim, D., Weber, G. (eds.) TEAA 2005. LNCS, vol. 3888, pp. 99–113. Springer, Heidelberg (2006)
Levene, M., Loizou, G.: A guided tour of relational databases and beyond. Springer, Berlin (1999)
Lockemann, P.: Information system architectures: From art to science. In: Proc. BTW 2003, pp. 1–27. Springer, Berlin (2003)
Schewe, K.-D.: The specification of data-intensive application systems. PhD thesis, Brandenburg University of Technology at Cottbus, Faculty of Mathematics, Natural Sciences and Computer Science, Advanced PhD Thesis (1994)
Schewe, K.-D., Thalheim, B.: Fundamental concepts of object oriented databases. Acta Cybernetica 11(4), 49–81 (1993)
Schewe, K.-D., Thalheim, B.: Modeling interaction and media objects. In: Bouzeghoub, M., Kedad, Z., Métais, E. (eds.) NLDB 2000. LNCS, vol. 1959, pp. 313–324. Springer, Heidelberg (2001)
Srinivasa, S.: An algebra of fixpoints for characterizing interactive behavior of information systems. PhD thesis, BTU Cottbus, Computer Science Institute, Cottbus (April 2000)
Suppes, P.: Representation and invariance of scientific structures. CSLI publications, Stanford (2002)
Thalheim, B.: Open problems in relational database theory. Bull. EATCS 32, 336–337 (1987)
Thalheim, B.: Entity-relationship modeling – Foundations of database technology. Springer, Berlin (2000)
Thalheim, B.: ASM specification of internet information services. In: Moreno-DÃaz Jr., R., Buchberger, B., Freire, J.-L. (eds.) EUROCAST 2001. LNCS, vol. 2178, pp. 301–304. Springer, Heidelberg (2001)
Thalheim, B.: Co-design of structuring, funtionality, distribution, and interactivity of large information systems. Computer Science Reports 15/03, Cottbus University of Technology, Computer Science Institute (2003)
Thalheim, B.: The conceptual framework to user-oriented content management. In: EJC 2006, Trojanovice (May 2006)
Thalheim, B., Düsterhöft, A.: Sitelang: Conceptual modeling of internet sites. In: Kunii, H.S., Jajodia, S., Sølvberg, A. (eds.) ER 2001. LNCS, vol. 2224, pp. 179–192. Springer, Heidelberg (2001)
Vinogradov, I.: Mathematical encyclopaedia (in 5 volumes). Soviet Encyclopaedia, Moscov (in Russian) (1982)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2007 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Thalheim, B. (2007). Achievements and Problems of Conceptual Modelling. In: Chen, P.P., Wong, L.Y. (eds) Active Conceptual Modeling of Learning. ACM-L 2006. Lecture Notes in Computer Science, vol 4512. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-77503-4_7
Download citation
DOI: https://doi.org/10.1007/978-3-540-77503-4_7
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-77502-7
Online ISBN: 978-3-540-77503-4
eBook Packages: Computer ScienceComputer Science (R0)