Skip to main content
SpringerLink
Log in
Book cover

Information Systems Development pp 975–987Cite as

Object-Relational Database Design: Can Your Application Benefit from SQL:2003?

  • Chapter
  • First Online:

Abstract

Traditional database design methods based on information engineering principles and data normalization do not fully apply to SQL:2003 object-relational databases. New design methodologies and tools are needed to support complex data constructs used in today's software engineering practice. There are application domains such as spatial, geographical information systems (GISs) and multimedia applications where the use of object-relational features is mandatory. There are also many other application types that are good candidates for object-relational features, but are frequently implemented using purely relational design as designers hesitate to face the challenges of object-relational design. It can be argued that the use of object-relational features is limited in practice by the lack of design methodologies that can guide database designers in making informed decisions about design choices that involve comparisons of relational and object-relational solutions. In this chapter we discuss object-relational design guidelines and illustrate, using an example, that the object-relational implementation can provide significant benefits simplifying the resulting data structures and the implementation of database queries.

This is a preview of subscription content, 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   129.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   169.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD   169.99
Price excludes VAT (USA)
  • Durable hardcover 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

Learn about institutional subscriptions

References

  • Cohen, S., Hurley, P., Schulz, K.W., Barth, W.L., Benton, B. (2006): ACM SIGMOD Record, Vol. 35, No 2, pp. 10–15.

    Article  Google Scholar 

  • de Haan, L. (2005): Mastering Oracle SQL and SQL*Plus. APress, Berkeley, CA .

    Google Scholar 

  • Geography Markup Language (GML) Implementation Specification Version 3.0. (2004). Available at http://www.opengis.net/gml

  • ISO/IEC 9075:1999 (1999): Information Technology, Database Languages, SQL. Part 2: Foundations.

    Google Scholar 

  • ISO/IEC 9075:2003 (2003): Information Technology, Database Languages, SQL. Part 2: Foundations.

    Google Scholar 

  • Marcos, E., Vela, B., Cavero, M., Cáceras (2001): Aggregation and Composition in Object-Relational Database Design. In: Proc. of ADBIS 2001, Res. Communications, A. Caplinskas, J. Eder (Eds.), pp. 195–209.

    Google Scholar 

  • Marcos, E., Vela, B., Cavero, M. (2004): A methodological approach for object-relational database design using UML. Informatik — Forschung und Entwicklung, Vol. 18, No. 3–4/April 2004, Springer, Berlin/Heidelberg, pp. 152–164.

    Google Scholar 

  • Melton, J., Simon, A.R. (2003): SQL: 1999 — Understanding Relational Language Components, 2nd edition. Morgan Kaufmann, San Mateo, CA.

    Google Scholar 

  • Mlýnková, I., Pokorný, J. (2005): XML in the World of (Object-)Relational Database Systems. In: Information Systems Development Advances in Theory, Practice, and Education 2004. Vasilecas, O., Caplinskas, A., Wojtkowski, G., Wojtkowski, W., Zupancic, J., Wrycza, S. (Eds.), Springer Science + Business Media, New York , pp. 63–76.

    Google Scholar 

  • Nečaský, M. (2007): XSEM — A Conceptual Model for XML. In Proc. Fourth Asia-Pacific Conference on Conceptual Modelling (APCCM2007), Ballarat, Australia. CRPIT, 67. Roddick, J.F., Annika, H. (Eds.), ACS, pp. 37–48.

    Google Scholar 

  • ORACLE (2000): Oracle Designer 6i: Systems Modeling. Volume 1 — Instructor Guide.

    Google Scholar 

  • Pardede, E., Rahayu, W., Taniar, D. (2004): Mapping Methods and Query for Aggregation and Association in Object-Relational Database using Collection. In: Proc. of the International Conference on Information Technology: Coding and Computing (ITCC’04), IEEE, 2004, pp. 539–543.

    Google Scholar 

  • Parent, Ch., Spaccapietra, S., Zimányi, E. (2006) Conceptual Modeling for Traditional and Spatio-Temporal Applications. The MADS Approach, Springer, Berlin/Heidelberg.

    MATH  Google Scholar 

  • Rahayu, W., Taniar, D. (2002): Preserving Aggregation in Object-Relational DBMS. In: Proc. of ADVIS 2002, T. Yakho (Ed.), LNCS 2457, pp. 1–10.

    Google Scholar 

  • Urban, S.D., Dietrich, S.W. (2003 ) Using UML Class Diagrams for a Comparative Analysis of Relational, Object-Oriented, and Object-Relational Database Mappings. In: Proc. of SIGCSE'03, February 19–23, 2003, Reno, Nevada, USA, pp. 21–25.

    Google Scholar 

  • Zhu, F., Zhou, J., Guan, J., Zhou, S. (2006) Storing and Querying GML in Object-Relational Databases. In: Proc. of ACM-GIS’06, November 10–11, 2006, Arlington, Virginia, USA, ACM, pp. 107–114.

    Google Scholar 

Download references

Acknowledgments

This research has been partially supported by the National Program of Research, Information Society Project No. 1ET100300419, and also by Ministry of Education of Czech Republic under research program MSM 6840770014 and also by the grant of GACR No. GA201/06/0756.

Author information

Authors and Affiliations

  1. Charles University of Prague, Prague, Czech Republic

    Jaroslav Pokorný

  2. Czech Technical University of Prague, Czech Republic

    Karel Richta

Authors
  1. George Feuerlicht
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Jaroslav Pokorný
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Karel Richta
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Business Information Systems Group J.E. Cairnes School of Business & Economics, National University of Ireland, Galway, University Road, Galway, Ireland

    Chris Barry

  2. Business Information Systems Group J.E. Cairnes School of Business & Economics, National University of Ireland, Galway, University Road, Galway, Ireland

    Michael Lang

  3. Department of Electrical Computer Engineering, Boise State University, 1910 University Dr. MEC 202C, Boise, ID, 83725-2075, USA

    Wita Wojtkowski

  4. Business Information Systems Group J.E. Cairnes School of Business & Economics, National University of Ireland, Galway, University Road, Galway, Ireland

    Kieran Conboy

  5. Department of Electrical & Computer Engineering, Boise State University, 1910 University Dr. MEC 202C, Boise, ID, 83725-2075, USA

    Gregory Wojtkowski

Rights and permissions

Reprints and permissions

Copyright information

© 2009 Springer Science+Business Media, LLC

About this chapter

Cite this chapter

Feuerlicht, G., Pokorný, J., Richta, K. (2009). Object-Relational Database Design: Can Your Application Benefit from SQL:2003?. In: Barry, C., Lang, M., Wojtkowski, W., Conboy, K., Wojtkowski, G. (eds) Information Systems Development. Springer, Boston, MA. https://doi.org/10.1007/978-0-387-78578-3_30

Download citation

  • DOI: https://doi.org/10.1007/978-0-387-78578-3_30

  • Published:

  • Publisher Name: Springer, Boston, MA

  • Print ISBN: 978-0-387-78577-6

  • Online ISBN: 978-0-387-78578-3

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation