Digital Review

Review - The Database Language GEM.

Michael J. Carey: Review - The Database Language GEM. ACM SIGMOD Digital Review 1: (1999)


This is one of my all-time favorite database papers---and I'd recommend it highly to anyone working on object extensions to relational database systems. In a nutshell, this paper extended the relational model and a relational query language (Quel) to provide for more strongly typed tables, generalization, references, path expressions, and set-valued attributes. What makes this paper such a gem (pun intended!) is that its extensions are remarkably clean, simple, and natural. While some ``relational bigots'' will argue even today that relations and objects are like oil and water, my view is that Zaniolo in many ways proved them wrong through his GEM research almost 15 years ago. Some of the highlights of this paper are its introduction of the dot-notation for path expressions, its clear treatment of the interplay between null values and path expressions, its unique type system, and its treatment of sets. This paper strongly influenced the object-oriented data model and query language work that we did in the context of the EXODUS project at Wisconsin; it continues to influence my view of the world in my current work on object-relational extensions for DB2 UDB and SQL3.

Copyright © 1999 by the author(s). Review published with permission.


Carlo Zaniolo: The Database Language GEM. SIGMOD Conference 1983: 207-218 CiteSeerX Google scholar BibTeX bibliographical record in XML

Copyright © Fri Mar 12 17:26:56 2010 by Michael Ley (