Proceedings of ISP RAS


ODMG and SQL object models ten years later: there are no contradictions

S.D. Kuznetsov (ISP RAS, Moscow)

Abstract

In 2005, I wrote an article in which I discussed the most important features of the standards ODMG 3.0 (ODMG object model) and the SQL:2003 (SQL data model) and convincingly (as it seemed to me) argued that the similarity between the object model and object extensions to SQL is purely external, that close in mind syntactic constructions hide deep differences at the model level. Since then, it took many years for which I understood many things that were wrongly or insufficient correctly understood by me then, and gradually came to the conclusions that:
1.    differences that seemed to me deep, are not such, and indeed are not differences at the model level;
2.    the object extensions of SQL provide no less (and rather large) capabilities than the ODMG object model;
3.    reasonably (from the standpoint of the database community) used DBMSes based on the ODMG data model, one will create databases and tools to manipulate them similar to those prescribed by the SQL data model.

Keywords

data model, object model, ODMG 3.0, SQL, dereferencing, object relocation

Edition

Proceedings of the Institute for System Programming, vol. 27, issue 1, 2015, pp. 173-192.

ISSN 2220-6426 (Online), ISSN 2079-8156 (Print).

DOI: 10.15514/ISPRAS-2015-27(1)-9

Full text of the paper in pdf (in Russian) Back to the contents of the volume