A foundation for evolution from relational to object databases

  • David Beech
Complex Database Objects
Part of the Lecture Notes in Computer Science book series (LNCS, volume 303)


Object models have an important part to play in the future of database systems, but progress is hampered by lack of agreement on their essential characteristics. Strong constraints on the design of a common model are exercised by the need to interface well with object models in programming languages, and the desirability of a smooth evolution from existing database technology.

This paper briefly reviews some salient features of database and language object concepts, and then draws attention to a correspondence between relational and object database models. It shows how this can be exploited in defining Object SQL (OSQL), which reinterprets and extends SQL to define object types and instances, together with functions which relate and manipulate objects. OSQL has been implemented as an interface to the Iris Object DBMS.


Programming Language Database System Object Model Property Function Object Concept 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [ANSI 86]
    American National Standards Institute. Database Language SQL. ANSI X3.135-1986.Google Scholar
  2. [Bancilhon et al. 87]
    Bancilhon, F., Briggs, T., Khoshafian, S., and Valduriez, P. FAD, a Powerful and Simple Database Language. Proc. 13th VLDB, Brighton. 1987.Google Scholar
  3. [Beech, Feldman & Johnson 82]
    Beech, D., Feldman, J.S., and Johnson, M.S. A Database Language for the Integrated Data Model. Computer Science Laboratory, HP Laboratories. December, 1982.Google Scholar
  4. [Beech 87a]
    Beech, D. Groundwork for an Object Database Model. In: Shriver, B. and Wegner, P. (eds.) Research Directions in Object-Oriented Languages. MIT Press, 1987.Google Scholar
  5. [Beech 87b]
    Beech, D. Intensional Concepts in a Database Programming Language. Proc. Roscoff Workshop on Database Programming Languages. Altair, Le Chesnay. 1987.Google Scholar
  6. [Beech & Mahbod 88]
    Beech, D., and Mahbod, B. Generalized Version Control in an Object-Oriented Database. Proc. 4th Intl. Conf. on Data Engineering. IEEE, 1988.Google Scholar
  7. [Bobrow et al. 87]
    Bobrow, D., DeMichiel, L.G., Gabriel, R.P., Keene, S.E., Kiczales, G., and Moon, D.A. Common Lisp Object System Specification. (87-002 Draft). Sept. 1987.Google Scholar
  8. [Chen 76]
    Chen, P.P.-S. The Entity-Relationship Model—Toward a Unified View of Data. ACM Trans. on Database Systems. March, 1976.Google Scholar
  9. [Codd 70]
    Codd, E.F. A Relational Model of Data for Large Shared Data Banks. Comm. ACM 13:6 (1970 June), 377–387.CrossRefGoogle Scholar
  10. [Cox 86]
    Cox, B. Object-Oriented Programming—An Evolutionary Approach. Addison-Wesley, 1986.Google Scholar
  11. [Dahl, Myrhaug & Nygaard 70]
    Dahl, O.-J., Myrhaug, B., and Nygaard, K. SIMULA Common Base Language. Norwegian Computing Centre S-22. Oslo, 1970.Google Scholar
  12. [Date 87]
    Date, C.J. A Guide to the SQL Standard. Addison-Wesley, 1987.Google Scholar
  13. [Dayal & Dittrich 86]
    Dayal, U. and Dittrich, K.R. (eds.) Proc. Intl. Workshop on Object-Oriented Database Systems, Asilomar, CA. Sept. 1986.Google Scholar
  14. [Elmasri & Wiederhold 81]
    Elmasri, R. and Wiederhold, G.: GORDAS: A Formal High-Level Query Language for the Entity-Relationship Model. In Chen, P.P.S. (ed): Entity-Relationship Approach to Information Modeling and Analysis, ER Institute, 1981.Google Scholar
  15. [Fishman et al. 87]
    Fishman, D.H., Beech, D., Cate, H.P., Chow, E.C., Connors, T., Davis, J.W., Derrett, N., Hoch, C.G., Kent, W., Lyngbaek, P., Mahbod, B., Neimat, M.A., Ryan, T.A., and Shan, M.C. Iris: An Object-Oriented Database Management System. ACM Transactions on Office Information Systems 5:1 (January 1987), 48–69.Google Scholar
  16. [Goldberg & Robson 83]
    Goldberg, A. and Robson, D. Smalltalk-80: The Language and its Implementation. Addison-Wesley (1983).Google Scholar
  17. [Held, Stonebraker & Wong 75]
    Held, G., Stonebraker, M.R., and Wong, E. INGRES—A Relational Data Base System. Proc AFIPS NCC, 1975.Google Scholar
  18. [IEEE 85]
    IEEE. Database Engineering, 8:4. Special Issue on Object-Oriented Systems. December, 1985.Google Scholar
  19. [Khoshafian & Copeland 86]]
    Khoshafian, S., and Copeland, G. Object Identity. Proc. OOPSLA, Portland, OR. Sept. 1986.Google Scholar
  20. [Landis 86]
    Landis, G.S., Design Evolution and History in an Object-Oriented CAD/CAM Database. Proc. IEEE Compcon86. March 1986.Google Scholar
  21. [Maier et al. 86]
    Maier, D., Stein, J., Otis, A., and Purdy, A. Development of an Object-Oriented DBMS. Proc. OOPSLA, Portland, OR. Sept. 1986.Google Scholar
  22. [Shipman 81]
    Shipman. D.W. The Functional Data Model and the Data Language DAPLEX. ACM Transactions on Database Systems, Vol 6, No 1, March, 1981.Google Scholar
  23. [Stroustrup 86]
    Stroustrup, B. The C++ Programming Language. Addison-Wesley, 1986.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1988

Authors and Affiliations

  • David Beech
    • 1
  1. 1.Hewlett-Packard LaboratoriesPalo Alto

Personalised recommendations