Skip to main content
SpringerLink
Log in

Visual SQL – High-Quality ER-Based Query Treatment

  • Conference paper
Conceptual Modeling for Novel Application Domains (ER 2003)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 2814))

Included in the following conference series:

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. We show in this paper that visualization led in this case to higher conceptual correctness and conceptual completeness. Visualization is based on Visual SQL. Visual SQL follows the paradigm of entity-relationship representation. At the same time, it has the same expression power as SQL-92. The quality of query formulation is, however, higher.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Atzeni, P., Chen, P.P.: Completeness of query languages for the entity relationship model. In: Chen, P.P. (ed.) Proc. of the 2nd Int. Conf. on the Entity-Relationship Approach to Systems Analysis and Design, pp. 109–121 (1981)

    Google Scholar 

  2. Balki, N.H., Ozsoyoglu, G., Ozsoyoglu, Z.M.: A graphical query language: VISUAL and its query processing. IEEE Transactions on Knowledge and Data Engineering 14(5), 955–979 (2002)

    Article  Google Scholar 

  3. Catarci, T., Tarantino, L.: Database querying by hypergraph manipulation. In: Proc. IDS 1994, pp. 84–103. Springer, Berlin (1994)

    Google Scholar 

  4. Chappell, D., Trimble Jr., J.H.: A visual introduction to SQL. Wiley, NY (2002)

    Google Scholar 

  5. Daisy200. Visual SQL charts, http://www.daisy2000.com

  6. Gogolla, M.: An Extended Entity-Relationship Model. LNCS, vol. 767. Springer, Heidelberg (1994)

    MATH  Google Scholar 

  7. Hohenstein, U.: Formale Semantik eines erweiterten Entity-Relationship- Modells. Teubner, Stuttgart (1993)

    Google Scholar 

  8. Jaakkola, H., et al.: Experiences in software process improvement with small organizations. In: Proc. IASTED 2002, Innsbruck, pp. 13–17 (2002)

    Google Scholar 

  9. Jaakkola, H., Kukkonen, J., Varkoi, T.: Best practices as reuse infrastructure. In: Proc. ReTIS 2001, Osterreichische Computer Gesellschaft, Vienna, pp. 9–31 (2001)

    Google Scholar 

  10. Kunii, H.S.: Graph data model and its data language. Springer, New York (1982)

    Google Scholar 

  11. Lakshmanan, L.V.S., Sadri, F., Subramanian, I.N.: SchemaSQL – A language for interoperability in relational multi-database systems. In: Proc. VLDB 1996 (1996)

    Google Scholar 

  12. Reingruber, M.C., Gregory, W.W.: The data modeling handbook. John Wiley & Sons, New York (1994)

    Google Scholar 

  13. Santucci, G., Palmisano, F.: A dynamic form-based visualiser for semantic query languages. In: Proc. IDS 1994, pp. 249–265. Springer, Berlin (1994)

    Google Scholar 

  14. 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)

    Chapter  Google Scholar 

  15. Subieta, K., Missala, M.: Semantics for the entity-relationship model. In: Spaccapietra, S. (ed.) The Entity-Relationship Approach, pp. 197–216. North-Holland, Amsterdam (1987)

    Google Scholar 

  16. Thalheim, B.: Entity-Relationship Modeling – Fundamentals o Database Technology. Springer, Berlin (2000)

    Google Scholar 

  17. Thalheim, B.: Visual SQL – An ER-Based Introduction to Database Querying. Report I–08/03 of the Computer Science Institute at BTU Cottbus, Cottbus (2003)

    Google Scholar 

  18. Thalheim, B., Kobienia, T.: Generating DB queries for web NL requests using schema information and DB content. In: Proc. NLDB 2001. LNI, vol. 3, pp. 205–209. Springer, Heidelberg (2001)

    Google Scholar 

  19. Vestenicky, V., Thalheim, B.: An Intelligent Query Generator. In: Proc. EJC 2002, pp. 135–141. ISO Press, Amsterdam (2002)

    Google Scholar 

  20. Visual SQL-Designer (VSD), http://www.visualsoftru.com/support.htm

Download references

Author information

Authors and Affiliations

  1. Tampere University of Technology, Pori, P.O.Box 300, FIN-28101, Pori

    Hannu Jaakkola

  2. Computer Science Institute, Brandenburg University of Technology at Cottbus, PostBox 101344, D-03013, Cottbus

    Bernhard Thalheim

Authors
  1. Hannu Jaakkola
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Bernhard Thalheim
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. CRISM/Infolab, Tilburg University, 5000, Tilburg, LE, The Netherlands

    Manfred A. Jeusfeld

  2. Department of Information Systems and Computation, Technical University of Valencia, Camino de Vera s/n, 46022, Valencia, Spain

    Óscar Pastor

Rights and permissions

Reprints and permissions

Copyright information

© 2003 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Jaakkola, H., Thalheim, B. (2003). Visual SQL – High-Quality ER-Based Query Treatment. In: Jeusfeld, M.A., Pastor, Ó. (eds) Conceptual Modeling for Novel Application Domains. ER 2003. Lecture Notes in Computer Science, vol 2814. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-39597-3_13

Download citation

  • DOI: https://doi.org/10.1007/978-3-540-39597-3_13

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-20257-8

  • Online ISBN: 978-3-540-39597-3

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation