Abstract
The converging trend of relational database technology and object-oriented database technology results in object-relational database systems which extend the relational systems with add-on object features. Efforts from both academic research and industry have been directed into extended data type processing by fully functioned database systems. In this paper, we put forward an approach for realizing object-relational systems by deploying current distributed database technology. The paper first discusses the object-relational data model and its query language. Then a hetrogeneous database architecture is presented for realizing object-relational technology by integrating relational and object-oriented database systems. Two main functions of the architecture: schema transformation and query translation are further discussed and correspondent algorithms are proposed.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
References
D. Beech. Can SQL3 be simplified? Database Programming and Design, pages 46–50, January 1997.
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.
R. G. G. Cattell, editor. The Object Database Standard. ODMG-93. Morgan Kaufmann Publishers, 1994.
C. J. Date and H. Darwen. A Guide to The SQL Standard, 3rd ed. Addison-Wesley, Reading, MA, 1993.
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.
ISO/IEC. ISO/IEC 9075:1992, Database Language SQL-July 30, 1992, july 1992.
A. Kemper and G. Moerkotte. Object-Oriented Database Management: Application in Engineering and Computer Science. Pretice-Hall, 1994.
ISO DBL LHR-077 and ANSI X3H2-95-456 R2. Introducing Reference Types and Cleaning up SQL3'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.
C. Liu, H. Li, and M. E. Orlowska. Supporting update propagation in object-oriented databases. Data & Knowledge Engineering, 1997. Accepted.
C. Liu, M. E. Orlowska, and H. Li. Realizing object-relational databases by mixing tables with objects. In Proceedings of 4th International Conference on Object-Oriented Information Systems. Springer-Verlag, Nov. 1997.
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.
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.
Michael Stonebraker. Object-Relational DBMSs: The Next Great Wave. Morgan Kaufmann, 1996.
ISO DBL YOW-004 and ANSI X3H2-95-084. (ISO/ANSI Working Draft) Database Language SQL3, March 1995. Jim Melton (ed).
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.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1997 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Orlowska, M.E., Li, H., Liu, C. (1997). On integration of relational and object-oriented database systems. In: Plášil, F., Jeffery, K.G. (eds) SOFSEM'97: Theory and Practice of Informatics. SOFSEM 1997. Lecture Notes in Computer Science, vol 1338. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-63774-5_112
Download citation
DOI: https://doi.org/10.1007/3-540-63774-5_112
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-63774-5
Online ISBN: 978-3-540-69645-2
eBook Packages: Springer Book Archive