Abstract
Relational query languages such as SQL and QBE are less than ideal for end user queries since they require users to work explicitly with structures at the relational level, rather than at the conceptual level where they naturally communicate. ConQuer is a new conceptual query language that allows users to formulate queries naturally in terms of elementary relationships, and operators such as “and”, “not” and “maybe”, thus avoiding the need to deal explicitly with implementation details such as relational tables, null values, and outer joins. While most conceptual query languages are based on the Entity-Relationship approach, ConQuer is based on Object-Role Modeling (ORM), which exposes semantic domains as conceptual object types, thus allowing queries to be formulated in terms of paths through the information space. This paper provides an overview of the ConQuer language.
on leave from Dept of Computer Science, University of Queensland
Preview
Unable to display preview. Download preview PDF.
References
Auddino, A., Amiel, E. & Bhargava, B. 1991 ‘Experiences with SUPER, a Database Visual Environment', DEXA'91 Database and Expert System Applications, pp.172–178
Date, C.J. 1996, ‘Aggregate functions', Database Prog. & Design, vol. 9, no. 4, Miller Freeman, San Mateo CA, pp. 17–19.
Date, C.J. & Darwen, H. 1992, Relational Database: writings 1989–1991, Addison-Wesley, Reading MA, esp. Chs 17–20.
De Troyer, O. & Meersman, R. 1995, 'A logic framework for a semantics of object oriented data modeling', OOER'95: Object-Oriented and Entity-Relationship Modeling, Springer LNCS, no. 1021, pp. 238–49.
Halpin, T.A. 1995, Conceptual Schema and Relational Database Design, 2nd edn, Prentice-Hall, Sydney, Australia.
Halpin, T.A. & Orlowska, M.E. 1992, ‘Fact-oriented modelling for data analysis', Journal of Inform. Systems, vol. 2, no. 2, pp. 1–23, Blackwell Scientific, Oxford
Halpin, T.A. & Proper, H.A. 1995, 'subtyping and polymorphism in Object-Role Modeling', Data and Knowledge Engineering, vol. 15, Elsevier Science, pp. 251–81.
Halpin, T.A. & Proper, H. A. 1995, 'Database schema transformation and optimization', OOER'95: Object-Oriented and Entity-Relationship Modeling, Springer LNCS, no. 1021, pp. 191–203.
Hofstede, A.H.M. ter, Proper, H.A. & Weide, Th.P. van der 1993, ‘Formal definition of a conceptual language for the description and manipulation of information models', Information Systems, vol. 18, no. 7, pp. 489–523.
Jarke, M., Gallersdörfer, R., Jeusfeld, M.A., Staudt, M., Eherer, S., 1995, ConceptBase—a Deductive Object Base for Meta Data Management, Journal of Intelligent Information Systems, Special Issue on Advances in Deductive Object-Oriented Databases, vol. 4, no. 2, 167–192.
Lawley, M. & Topor R. 1994, ‘A Query Language for EER Schemas', ADC'94 Proceedings of the 5th Australian Database Conference, Global Publications Service, pp. 292–304.
Meersman, R. 1982, ‘The RIDL conceptual language', Research report, Int. Centre for Information Analysis Services, Control Data Belgium, Brussels, Belgium, 1982.
Mylopoulos, J., Borgida, A., Jarke, M. & Koubarakis, M., 1990, Telos: a language for representing knowledge about information systems, ACM Transactions Information Systems vol. 8, no 4.
Parent, C. & Spaccapietra, S. 1989, ‘About Complex Entities, Complex Objects and Object-Oriented Data Models', Information System Concepts—An In-depth Analysis, Falkenberg, E.D. & Lindgreen, P, Eds., North Holland, pp. 347—360
Proper, H.A. & Weide, Th. P. van der 1995, ‘Information disclosure in evolving information systems: taking a shot at a moving target', Data and Knowledge Engineering, vol. 15, no. 2, pp. 135–68, Elsevier Science.
Rosengren, P. 1994, 'Using Visual ER Query Systems in Real World Applications', CAiSE'94: Advanced Information Systems Engineering, Springer LNCS, no. 811, pp. 394–405.
Staudt, M., Nissen, H.W., Jeusfeld, M.A. 1994, Query by Class, Rule and Concept. Applied Intelligence, Special Issue on Knowledge Base Management, vol. 4, no. 2, pp. 133–157
Wintraecken, J.J.V.R. 1990, The NIAM Information Analysis Method: Theory and Practice, Kluwer, Deventer, The Netherlands.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1996 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Bloesch, A.C., Halpin, T.A. (1996). ConQuer: A conceptual query language. In: Thalheim, B. (eds) Conceptual Modeling — ER '96. ER 1996. Lecture Notes in Computer Science, vol 1157. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0019919
Download citation
DOI: https://doi.org/10.1007/BFb0019919
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-61784-6
Online ISBN: 978-3-540-70685-4
eBook Packages: Springer Book Archive