Collections of Objects in SQL3.

David Beech: Collections of Objects in SQL3. VLDB 1993: 244-255
  author    = {David Beech},
  editor    = {Rakesh Agrawal and
               Se{\'a}n Baker and
               David A. Bell},
  title     = {Collections of Objects in SQL3},
  booktitle = {19th International Conference on Very Large Data Bases, August
               24-27, 1993, Dublin, Ireland, Proceedings},
  publisher = {Morgan Kaufmann},
  year      = {1993},
  isbn      = {1-55860-152-X},
  pages     = {244-255},
  ee        = {db/conf/vldb/Beech93.html},
  crossref  = {DBLP:conf/vldb/93},
  bibsource = {DBLP,}


SQL3 generalizes the relational model into an object model offering abstract data types, multiple inheritance, and dynamic polymorphism. Tables may then contain collections (multisets) of objects, and sets and lists are defined as closely related collection types. By specifying an SQL-Table type template to correspond to the existing Table concept, it is possible to treat sets and lists as subtypes of tables that inherit the behavior (and SQL syntax) for tables, while adding their own specializations. The SQL set-at-a-time data manipulation language can then be applied to collections of objects, i.e. tables in which each row is an object.

Copyright © 1993 by the VLDB Endowment. Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage, the VLDB copyright notice and the title of the publication and its date appear, and notice is given that copying is by the permission of the Very Large Data Base Endowment. To copy otherwise, or to republish, requires a fee and/or special permission from the Endowment.

Online Paper

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 1 Issue 5, VLDB '89-'97" and ... DVD Version: Load ACM SIGMOD Anthology DVD 1" and ... BibTeX

Printed Edition

Rakesh Agrawal, Seán Baker, David A. Bell (Eds.): 19th International Conference on Very Large Data Bases, August 24-27, 1993, Dublin, Ireland, Proceedings. Morgan Kaufmann 1993, ISBN 1-55860-152-X
Contents BibTeX


David Beech: Intensional Concepts in an Object Database Model. OOPSLA 1988: 164-175 BibTeX
Margaret A. Ellis, Bjarne Stroustrup: The Annotated C++ Reference Manual. Addison-Wesley 1990, ISBN 0-201-51459-1

Referenced by

  1. Frédéric Gingras, Laks V. S. Lakshmanan: nD-SQL: A Multi-Dimensional Language for Interoperability and OLAP. VLDB 1998: 134-145
  2. Laks V. S. Lakshmanan, Fereidoon Sadri, Iyer N. Subramanian: SchemaSQL - A Language for Interoperability in Relational Multi-Database Systems. VLDB 1996: 239-250
  3. Leonidas Fegaras, David Maier: Towards an Effective Calculus for Object Query Languages. SIGMOD Conference 1995: 47-58
ACM SIGMOD Anthology - DBLP: [Home | Search: Author, Title | Conferences | Journals]
VLDB Proceedings: Copyright © by VLDB Endowment,
ACM SIGMOD Anthology: Copyright © by ACM (, Corrections:
DBLP: Copyright © by Michael Ley (, last change: Sat May 16 23:45:56 2009