Newletter Sign Up
Posts on the
Design Decomposition Blog
Iridium Satellite Collision in Space
You might have seen the recent news reports about the collision between U.S. and Russian communication satellites. The U.S. satellite was one of the Iridium satellites. What wasn’t reported and you probably don’t know is that an object database management system (ODBMS) is an important part of the Iridium system. Even though ODBMSs are a [...]
February 13, 2009
(The Acronym) SOA is (Perhaps) Dead (at Some Companies); Long Live Services
I am now also posting on the Cutter Blog. My initial posting is (The Acronym) SOA is (Perhaps) Dead (at Some Companies); Long Live Services. It is a response to Anne Thomas Manes’ SOA is Dead; Long Live Services on her blog at the Burton Group.
January 9, 2009
Atomicity
The typical definition of an atomic task or process is one that cannot be decomposed further. This is vague and subject to interpretation. The Decomposition Matrix on this site uses a specific definition: A task (for business process diagrams) or a process (for data flow diagrams) is atomic if every input relates to every output [...]
December 3, 2008
Well-Formed Business Process Diagrams
My last posting referenced the criteria for a well-formed business process diagram mentioned in Business Process Driven SOA using BPMN and BPEL by Matjaz B. Juric and Kapil Pant. I am going to expand on their criteria to create a more comprehensive definition of a well-formed business process diagram. To start, here are three criteria from [...]
November 18, 2008
Recent Business Process Modeling Books
I recently received two new books on business process modeling. Both books looked interesting because they had great titles. As it turns out, one book is great and the other not so good. The not so good book is Business Process Driven SOA using BPMN and BPEL by Matjaz B. Juric and Kapil Pant. There are [...]
October 9, 2008
The Design Decomposition Blog
is written by Doug Barry.

The following table shows the comparison of SQL-92, JDBC, SQLJ, SQL:1999, ODMG 3.0, and JDO on their respective models, data definition languages, query languages, and data manipulation languages. The table is completed with the idea you will be using an object programming language such as Java or C++.

This table is not a comparison of database management systems (DBMSs). It is really a comparison of application program interfaces (APIs). This is because any of these APIs can be used with virtually any DBMS. For example, SQL-92 and JDBC are often associated with relational DBMSs. Both APIs, however, are also used with various object DBMSs. Conversely, ODMG 3.0 is often associated with object DBMSs, but in reality, it is also used with object-relational mapping products for relational DBMSs.

An important term to know is transparent persistence. You can see the term used in the table for the ODMG 3.0 and JDO specifications. For more information on transparent persistence, see:

For more information on each of the specifications, see the menu choices at the right on the bottom of the page.

Feature SQL-92 JDBC SQLJ SQL:1999 ODMG 3.0 JDO
Model relational model relational model Parts 0 & 1: relational model

Part 2: SQL:1999 object model
(more)

SQL:1999 object model
(more)
Java, C++, and Smalltalk object models enhanced for transparent persistence

The model with the transparent persistence enhancements is a superset of the OMG Common Object Model

Java object model enhanced for transparent persistence
Data Definition Language SQL SQL SQL SQL Object Definition Language (ODL)  which is a superset of the OMG Interface Definition Language (IDL) Java & XML
Query Language Embedded SQL, Dynamic SQL, and Call-level interface Call-level interface for SQL Embedded SQL Embedded SQL, Dynamic SQL, and Call-level interface Object Query Language (OQL) which is based on SQL-92 JDO Query Language (JDOQL)
(more)
Data Manipulation Language Embedded SQL, Dynamic SQL, and Call-level interface Call-level interface for SQL and Java Embedded SQL and Java Embedded SQL, Dynamic SQL, and Call-level interface Java, C++, or Smalltalk Java

From the table, you can see that SQL differs from the other specifications because it defines its own model, data definition language, query language, and data manipulation language. Both SQL-92 and SQL:1999 do not build on any specifications other than versions of SQL. See the table below:

  SQL-92 JDBC SQLJ SQL:1999 ODMG 3.0 JDO        
Specification based on: SQL-89 Java & SQL-92 Java, JDBC & SQL:1999 SQL-92 OMG Common Object Model, OMG IDL, SQL-92, Java, C++, and Smalltallk Java & XML

Related content for: Summary comparison of DBMS standards

More on the general topic: DBMS standards

Read more free articles on this site

There are nearly 400 pages of articles on this site with over 40 pages on database concepts and standards.

Search this site for more articles

Custom Search

Browse this site for more articles

Click on the topics below to browse the articles on this site. You can see more detail by clicking on the arrows. This highlights the location of the current article: Summary comparison of DBMS standards.

Related recent articles from Google News

SQL Server JDBC Driver 3.0 Community Technology Preview (CTP) Live
Softpedia
A preview of the upcoming Java Database Connectivity (JDBC) driver is currently up for grabs via the Microsoft Download Center. SQL Server JDBC Driver 3.0 ...

3 Mar 2010 at 4:17am
The Challenges of Smartphone Programming for Google Android
CTO Edge (blog)
If you do interact with other programs, it is typically through an API, such as Java Database Connectivity (JDBC), or frameworks atop it, to communicate ...

9 Mar 2010 at 1:58pm
Red Hat alert RHSA-2010:0130-01 (java-1.5.0-ibm)
LWN.net
... java-1.5.0-ibm-jdbc-1.5.0.11.1-1jpp.3.el4.ppc.rpm java-1.5.0-ibm-plugin-1.5.0.11.1-1jpp.3.el4.ppc.rpm java-1.5.0-ibm-src-1.5.0.11.1-1jpp.3.el4.ppc.rpm ...

4 Mar 2010 at 1:44pm
Linoma Adds Tokenization to i/OS Encryption Tool
IT Jungle
... a new HTTPS transport mechanism to support the new tokenization capabilities (alternatively, customers can transmit tokens via SQL and ODBC or JDBC). ...

8 Mar 2010 at 5:49pm
Copan's ex-CEO turns up at Attivio
Register
... Structured Query Language (SQL) support and a JDBC driver for providing unified information to business intelligence (BI) reports and dashboards. ...
Making Sense of the Data IT Business Edge (blog)
all 2 news articles »
12 Feb 2010 at 5:19am
More related news on: "SQL-92" OR JDBC OR SQLJ OR "SQL:1999" OR "SQL-1999" OR "SQL-99" OR "Java Data Objects" OR "ODMG 3.0"

Related books at Amazon.com

JDBC(TM) API Tutorial and Reference (3rd Edition)
JDBC(TM) API Tutorial and Reference (3rd Edition)
by Maydene Fisher, Jon Ellis, Jonathan Bruce
Average Customer Review: 4.5 stars based on 22 reviews.
Customer Review: JDBC is one of the most mature and widely used Java APIs. Even after the arrival of more recent tools and technologies like EJB's CMP and JDO, JDBC still remains a simple, fast, and reliable way of storing objects' state in an RDBMS. While conceptually this technology is quite straightforward, its evolution has made it more complex ...
Understanding Relational Databases with Examples in SQL-92
Understanding Relational Databases with Examples in SQL-92
by Fabian Pascal
Average Customer Review: 3 stars based on 7 reviews.
Customer Review: Terse and authoritative, but engaging. This book's style may not be for everyone but its content is well worth the effort of study and review. It's short for a book on relational theory, which derives from the author's economy of exposition rather than from a lack of depth or coverage. In reading it I was repeatedly struck with the s...
SQL: 1999 - Understanding Relational Language Components (The Morgan Kaufmann Series in Data Management Systems)
SQL: 1999 - Understanding Relational Language Components (The Morgan Kaufmann Series in Data Management Systems)
by Jim Melton, Alan R. Simon
Average Customer Review: 4.5 stars based on 4 reviews.
Customer Review: This is an important book. Most books on SQL cover simple SQL statements, and/or focus on a particular vendor's SQL implementation. Very few books attempt to cover the SQL standard in any depth, if at all. This one does. Furthermore, because one of the authors (Jim Melton) is the editor of the ISO SQL Standards Committee, the book is...
The Object Data Standard: ODMG 3.0 (The Morgan Kaufmann Series in Data Management Systems)
The Object Data Standard: ODMG 3.0 (The Morgan Kaufmann Series in Data Management Systems)
by R. G. Cattell, Douglas K. Barry, Mark Berler, Jeff Eastman, David Jordan, Craig Russell, Olaf Schadow, Torsten Stanienda, Fernando Velez
Average Customer Review: 4 stars based on 2 reviews.
Customer Review: A well-written, concise reference covering a diverse range of topics that will be of interest to all who know the frustration of cramming complex OO systems into relational tables. From a complete design pattern for Object and Object Relational database systems, to design patterns for declarative language symantics; from C++ and Java...
Teach Yourself Database Programming With Jdbc in 21 Days (Teach Yourself Series)
Teach Yourself Database Programming With Jdbc in 21 Days (Teach Yourself Series)
by Ashton Hobbs
Average Customer Review: 2.5 stars based on 5 reviews.
Customer Review: The author shows you good examples of using JDBC, dbAnywhere, and Sybase. An excellent jump start if you want to understand inner workings of JDBC application development. The author centers much of his JDBC examples around PowerBuilder concepts such as the datawindow and transaction object. If you knew PowerBuilder in the past you w...
More related books: Search Amazon.com for SQL