Skip to main content
SpringerLink
Log in
Book cover

OOIS’97 pp 335–346Cite as

Realizing Object-Relational Databases by Mixing Tables with Objects

  • Conference paper

Abstract

In this paper, we propose an approach for implementing object-relational DBMSs by using a heterogeneous database system architecture. The paper first discusses the type extensibility of an object-relational DBMS and its query language. Then the architecture is presented for realizing object-relational technology on the top of relational and object-oriented DBMSs. In particular, two main functions — schema transformation and query translation are further studied.

The work reported in this paper has been funded in part by the Cooperative Research Centres Program through the Department of the Prime Minister and Cabinet of the Commonwealth Government of Australia.

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   84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   109.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

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. D. Beech. Can SQL3 be simplified? Database Programming and Design, pages 46–50, January 1997.

    Google Scholar 

  2. Michael J. Carey and David J. DeWitt. Of objects and databases: A decade of turmoil. In Proceedings of the 22nd International conference on VLDB, pages 3–14, Mumbai (Bombay), India, September 1996. VLDB, Morgan Kaufmann.

    Google Scholar 

  3. R. G. G. Cat tell, editor. The Object Database Standard: ODMG-93. Morgan Kaufmann Publishers, 1994.

    Google Scholar 

  4. H. Ishikawa, Y. Yamane, Y. Izumida, and N. Kawato. An object-oriented database system Jasmine: Implementation, application, and extension. IEEE Transactions on Knowledge and Data Engineering, 8 (2): 285–304, 1996.

    Article  Google Scholar 

  5. ISO DBL LHR-077 and ANSI X3H2-95-456 R2. Introducing Reference Types and Cleaning up SQLS’s Object Model, November 1995. by K. Kulkarni, M. Carey, L. DeMichiel, N. Mattos, W. Hong, M. Ubell, A. Nori, V. Krishnamurthy and D. Beech.

    Google Scholar 

  6. A. Makinouchi. A consideration on normal form of not-necessarily-normalized relation in the relational data model. In Proceedings of the 3rd VLDB Conference, pages 202–211, Tokyo, October 1977.

    Google Scholar 

  7. W. Meng, C. Yu, W. Kim, G. Wang, T. Pham, and S. Dao. Construction of a relational front-end for object-oriented database systems. In Proceeding of 9th International Conference on Data Engineering, pages 476–483, 1993.

    Chapter  Google Scholar 

  8. Joan Peckham and Fred Maryanski. Semantic data models. A CM Computing Surveys, 20 (3), September 1988.

    Google Scholar 

  9. M. Stonebraker, L. A. Rowe, and M. Hirohama. The implementation of POSTGRES. IEEE Transactions on Knowledge and Data Engineering, 2 (1): 125–142, February 1990.

    Article  Google Scholar 

  10. Michael Stonebraker. Object-Relational DBMSs: The Next Great Wave. Morgan Kaufmann, 1996.

    Google Scholar 

  11. ISO DBL YOW-004 and ANSI X3H2-95-084. (ISO/ANSI Working Draft) Database Language SQL3, March 1995. Jim Melton (ed).

    Google Scholar 

  12. C. Yu, Y. Zhang, W. Meng, W. Kim, G. Wang, T. Pham, and S. Dao. Translation of object-oriented queries to relational queries. In Proceeding of 11th International Conference on Data Engineering, pages 90–97, 1995.

    Chapter  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. CRC for Distributed Systems Technology, The University of Queensland, Brisbane, Qld 4072, Australia

    Chengfei Liu & Maria E Orlowska

  2. School of Information Technology, The University of Queensland, Brisbane, Qld 4072, Australia

    Maria E Orlowska & Hui Li

Authors
  1. Chengfei Liu
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Maria E Orlowska
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Hui Li
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. School of Information Technology, University of Queensland, Q4072, Brisbane, Australia

    Maria E. Orlowska

  2. Johann Wolfgang Goethe-Universität, Frankfurt am Main, Germany

    Roberto Zicari

Rights and permissions

Reprints and permissions

Copyright information

© 1998 Springer-Verlag London Limited

About this paper

Cite this paper

Liu, C., Orlowska, M.E., Li, H. (1998). Realizing Object-Relational Databases by Mixing Tables with Objects. In: Orlowska, M.E., Zicari, R. (eds) OOIS’97. Springer, London. https://doi.org/10.1007/978-1-4471-1525-0_28

Download citation

  • DOI: https://doi.org/10.1007/978-1-4471-1525-0_28

  • Publisher Name: Springer, London

  • Print ISBN: 978-3-540-76170-9

  • Online ISBN: 978-1-4471-1525-0

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation