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

  • George Feuerlicht
  • Jaroslav Pokorný
  • Karel Richta


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


  1. Cohen, S., Hurley, P., Schulz, K.W., Barth, W.L., Benton, B. (2006): ACM SIGMOD Record, Vol. 35, No 2, pp. 10–15.CrossRefGoogle Scholar
  2. de Haan, L. (2005): Mastering Oracle SQL and SQL*Plus. APress, Berkeley, CA .Google Scholar
  3. Geography Markup Language (GML) Implementation Specification Version 3.0. (2004). Available at
  4. ISO/IEC 9075:1999 (1999): Information Technology, Database Languages, SQL. Part 2: Foundations.Google Scholar
  5. ISO/IEC 9075:2003 (2003): Information Technology, Database Languages, SQL. Part 2: Foundations.Google Scholar
  6. 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
  7. 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
  8. Melton, J., Simon, A.R. (2003): SQL: 1999 — Understanding Relational Language Components, 2nd edition. Morgan Kaufmann, San Mateo, CA.Google Scholar
  9. 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
  10. 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
  11. ORACLE (2000): Oracle Designer 6i: Systems Modeling. Volume 1 — Instructor Guide.Google Scholar
  12. 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
  13. Parent, Ch., Spaccapietra, S., Zimányi, E. (2006) Conceptual Modeling for Traditional and Spatio-Temporal Applications. The MADS Approach, Springer, Berlin/Heidelberg.zbMATHGoogle Scholar
  14. 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
  15. 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
  16. 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

Copyright information

© Springer Science+Business Media, LLC 2009

Authors and Affiliations

  • George Feuerlicht
  • Jaroslav Pokorný
    • 1
  • Karel Richta
    • 2
  1. 1.Charles University of PraguePragueCzech Republic
  2. 2.Czech Technical University of PragueCzech Republic

Personalised recommendations