Abstract
Query formulation is still a difficult task whenever a database schema is large or complex. The user has to entirely understand the schema before a correct and complete formulation of the query will be found. Furthermore, users may overlook types in the SQL schema that must be used in the query. Visualization based on Visual SQL leads to higher conceptual correctness and conceptual completeness.
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
References
Jaakkola, H., Thalheim, B.: Visual SQL - high-quality er-based query treatment. In: Jeusfeld, M.A., Pastor, Ó. (eds.) ER Workshops 2003. LNCS, vol. 2814, pp. 129–139. Springer, Heidelberg (2003)
Thalheim, B.: Entity-relationship modeling – Foundations of database technology. Springer, Berlin (2000)
Thalheim, B.: Visual SQL - An ER-based introduction to database programming. Technical Report Preprint I-8/2003, Institut für Informatik, BTU Cottbus (2003)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2008 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Thalheim, B. (2008). Visual SQL: Towards ER-Based Object-Relational Database Querying. In: Li, Q., Spaccapietra, S., Yu, E., Olivé, A. (eds) Conceptual Modeling - ER 2008. ER 2008. Lecture Notes in Computer Science, vol 5231. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-87877-3_41
Download citation
DOI: https://doi.org/10.1007/978-3-540-87877-3_41
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-87876-6
Online ISBN: 978-3-540-87877-3
eBook Packages: Computer ScienceComputer Science (R0)