Proceedings of the Institute for System Programming of the RAS
RUS  ENG    JOURNALS   PEOPLE   ORGANISATIONS   CONFERENCES   SEMINARS   VIDEO LIBRARY   PACKAGE AMSBIB  
General information
Latest issue
Archive

Search papers
Search references

RSS
Latest issue
Current issues
Archive issues
What is RSS



Proceedings of ISP RAS:
Year:
Volume:
Issue:
Page:
Find






Personal entry:
Login:
Password:
Save password
Enter
Forgotten password?
Register


Proceedings of the Institute for System Programming of the RAS, 2015, Volume 27, Issue 1, Pages 173–192
DOI: https://doi.org/10.15514/ISPRAS-2015-27(1)-9
(Mi tisp118)
 

Odmg and sql object models ten years later: there are no contradictions

S. D. Kuznetsov

Institute for System Programming of the Russian Academy of Sciences
References:
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. Examples of such differences include von Neumann-style dereference of ObjectIDs in the ODMG model vs join-style dereference of reference values in the SQL model, separate and independent store of objects of one and the same object type in the ODMG model vs store of all raws of a typed table (SQL analogy of object) within this table, store of ObjectISs within extents in the ODMG model vs store within analogy of extent of objects their self in the SQL model, etc. 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:
  • differences that seemed to me deep, are not such, and indeed are not differences at the model level;
  • the object extensions of SQL provide no less (and rather large) capabilities than the ODMG object model;
  • 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.
Bibliographic databases:
Document Type: Article
Language: Russian
Citation: S. D. Kuznetsov, “Odmg and sql object models ten years later: there are no contradictions”, Proceedings of ISP RAS, 27:1 (2015), 173–192
Citation in format AMSBIB
\Bibitem{Kuz15}
\by S.~D.~Kuznetsov
\paper Odmg and sql object models ten years later: there are no contradictions
\jour Proceedings of ISP RAS
\yr 2015
\vol 27
\issue 1
\pages 173--192
\mathnet{http://mi.mathnet.ru/tisp118}
\crossref{https://doi.org/10.15514/ISPRAS-2015-27(1)-9}
\elib{https://elibrary.ru/item.asp?id=23420347}
Linking options:
  • https://www.mathnet.ru/eng/tisp118
  • https://www.mathnet.ru/eng/tisp/v27/i1/p173
  • Citing articles in Google Scholar: Russian citations, English citations
    Related articles in Google Scholar: Russian articles, English articles
    Proceedings of the Institute for System Programming of the RAS
     
      Contact us:
     Terms of Use  Registration to the website  Logotypes © Steklov Mathematical Institute RAS, 2024