Object subclass hierarchy in SQL: a simple approach

ABSTRACT

The object subclass hierarchy is a useful way of modeling property and behavior inheritance. It can be implemented on a relational DBMS using views.

REFERENCES

• 1: Dina Bitton , David J. DeWitt , Carolyn Turbyfill, Benchmarking Database Systems A Systematic Approach, Proceedings of the 9th International Conference on Very Large Data Bases, p.8-19, October 31-November 02, 1983
• 2: Michael R. Blaha , William J. Premerlani , James E. Rumbaugh, Relational database design using an object-oriented methodology, Communications of the ACM, v.31 n.4, p.414-427, April 1988 [doi>10.1145/42404.42407]
• 3: Jose A. Blakeley , Per-Ake Larson , Frank Wm Tompa, Efficiently updating materialized views, Proceedings of the 1986 ACM SIGMOD international conference on Management of data, p.61-71, May 28-30, 1986, Washington, D.C., United States
• 4: Georg Gottlob , Paolo Paolini , Roberto Zicari, Properties and update semantics of consistent views, ACM Transactions on Database Systems (TODS), v.13 n.4, p.486-524, Dec. 1988 [doi>10.1145/49346.50068]
• 5: Eric N. Hanson, A performance analysis of view materialization strategies, Proceedings of the 1987 ACM SIGMOD international conference on Management of data, p.440-453, May 27-29, 1987, San Francisco, California, United States
• 6: Jonathan P. Jacky , Ira J. Kalet, An object-oriented programming discipline for standard Pascal, Communications of the ACM, v.30 n.9, p.772-776, Sept. 1987 [doi>10.1145/30401.30403]
• 7: C. H. Kung, Conceptual Modeling in the Context of Development, IEEE Transactions on Software Engineering, v.15 n.10, p.1176-1187, October 1989 [doi>10.1109/TSE.1989.559766]
• 8: Kung, C.H. The behavior network model for conceptual information modeling. To be published.
• 9: Peter Lyngbaek , Victor Vianu, Mapping a semantic database model to the relational model, Proceedings of the 1987 ACM SIGMOD international conference on Management of data, p.132-142, May 27-29, 1987, San Francisco, California, United States
• 10: Michael Stonebraker , Gerald Held , Eugene Wong , Peter Kreps, The design and implementation of INGRES, ACM Transactions on Database Systems (TODS), v.1 n.3, p.189-222, Sept. 1976 [doi>10.1145/320473.320476]
• 11: Toby J. Teorey , Dongqing Yang , James P. Fry, A logical design methodology for relational databases using the extended entity-relationship model, ACM Computing Surveys (CSUR), v.18 n.2, p.197-222, June 1986 [doi>10.1145/7474.7475]
• 12: Shalom Tsur , Carlo Zaniolo, An implementation of GEM: supporting a semantic data model on a relational back-end., Proceedings of the 1984 ACM SIGMOD international conference on Management of data, June 18-21, 1984, Boston, Massachusetts
• 13: Victor Vianu, A dynamic framework for object projection views, ACM Transactions on Database Systems (TODS), v.13 n.1, p.1-22, March 1988 [doi>10.1145/42201.42202]

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.3 Languages

          Nouns: SQL

Additional Classification:
  D. Software
  D.1 PROGRAMMING TECHNIQUES
  D.2 SOFTWARE ENGINEERING

  H. Information Systems
  H.2 DATABASE MANAGEMENT

General Terms:
Design

Keywords:
inclusion constraints, normal forms, object-oriented, query processing, relational databases