Skip to main content
SpringerLink
Log in

An SQL\(^o\) Front-End for Non-monotonic Inheritance and De-referencing

  • Conference paper
  • First Online:
Conceptual Modeling (ER 2019)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 11788))

Included in the following conference series:

  • 1634 Accesses

Abstract

We revisit the issues of non-monotonic inheritance and structure traversal in object-relational databases with new insights to propose OO extensions of SQL and demonstrate that they are sufficient and powerful enough for modeling classes, non-monotonic inheritance and de-referencing. In particular, we show that simple tweaking of SQL with tuple ID helps capture these OO features cleanly and empowers application developers with a powerful knowledge modeling tool.

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 EPUB and 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

Notes

  1. 1.

    In this article, we use the terms sub and superclasses interchangeably with sub and supertables for convenience.

References

  1. Alashqur, A.M., Su, S.Y.W., Lam, H.: OQL: A query language for manipulating object-oriented databases. In: VLDB, pp. 433–442 (1989)

    Google Scholar 

  2. Bancilhon, F., Delobel, C., Kanellakis, P.C. (eds.): Building an Object-Oriented Database System, The Story of O2. Morgan Kaufmann, Burlington (1992)

    Google Scholar 

  3. Dar, S., Gehani, N.H., Jagadish, H.V.: CQL++: a SQL for the Ode object-oriented DBMS. In: Pirotte, A., Delobel, C., Gottlob, G. (eds.) EDBT 1992. LNCS, vol. 580, pp. 201–216. Springer, Heidelberg (1992). https://doi.org/10.1007/BFb0032432

    Chapter  Google Scholar 

  4. Feuerlicht, G., Pokorný, J., Richta, K.: Object-relational database design: can your application benefit from SQL: 2003? In: Barry, C., Lang, M., Wojtkowski, W., Conboy, K., Wojtkowski, G. (eds.) ISD, Challenges in Practice, Theory, and Education, vol. 2, pp. 975–987. Springer, Boston (2007). https://doi.org/10.1007/978-0-387-78578-3_30

    Chapter  Google Scholar 

  5. Fuh, Y., et al.: Implementation of SQL3 structured types with inheritance and value substitutability. In: VLDB, pp. 565–574 (1999)

    Google Scholar 

  6. Hammer, M., McLeod, D.: Database description with SDM: a semantic database model. ACM Trans. Database Syst. 6(3), 351–386 (1981)

    Article  Google Scholar 

  7. Mitschang, B., Pirahesh, H., Pistor, P., Lindsay, B.G., Südkamp, N.: SQL/XNF - processing composite objects as abstractions over relational data. In: ICDE, pp. 272–282 (1993)

    Google Scholar 

  8. Sieg Jr., J., Sciore, E.: Extended relations. In: ICDE, pp. 488–494 (1990)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Computer Science, University of Idaho, Moscow, ID, USA

    Joel Oduro-Afriyie & Hasan M. Jamil

Authors
  1. Joel Oduro-Afriyie
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Hasan M. Jamil
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Hasan M. Jamil .

Editor information

Editors and Affiliations

  1. Universidade Federal de Minas Gerais, Belo Horizonte, Brazil

    Alberto H. F. Laender

  2. Politecnico di Milano, Milan, Italy

    Barbara Pernici

  3. Singapore Management University, Singapore, Singapore

    Ee-Peng Lim

  4. Univ Federal do Rio Grande do Sul, Porto Alegre, Brazil

    José Palazzo M. de Oliveira

Rights and permissions

Reprints and permissions

Copyright information

© 2019 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Oduro-Afriyie, J., Jamil, H.M. (2019). An SQL\(^o\) Front-End for Non-monotonic Inheritance and De-referencing. In: Laender, A., Pernici, B., Lim, EP., de Oliveira, J. (eds) Conceptual Modeling. ER 2019. Lecture Notes in Computer Science(), vol 11788. Springer, Cham. https://doi.org/10.1007/978-3-030-33223-5_6

Download citation

  • DOI: https://doi.org/10.1007/978-3-030-33223-5_6

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-030-33222-8

  • Online ISBN: 978-3-030-33223-5

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation