Summary comparison of DBMS standards

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:

bulletTransparent persistence for object databases (new window)
bulletTransparent persistence for relational databases using object-relational mapping products (new window)

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

 

 

Web Services and Service-Oriented Architectures
Online articles>
Consulting
Mentoring
Speaking
Suggested programs
Stencils for the Savvy Manager's Guide
Links
Mail list
Privacy policy
Sitemap
Contact
Web Services articles
XML standards and vocabularies
Application server articles
Database concepts and standards>
Object database articles
Relational database articles
Object-relational mapping articles
XML database articles
XML middleware articles
Article Sponsorship
Reprint policy
Basic concepts for using a DBMS
Database models
DBMS standards>
Article suggestions
SQL-92
JDBC
SQLJ
SQL:1999
ADO.NET
Java Data Objects (JDO)
ODMG 3.0
Detailed comparison of ODMG 3.0 and JDO
Summary comparison of DBMS standards>

Related recent articles from Google News


Dreamtech Press Introduces 'JDBC, Servlets and JSP Black Book' by ...
Newswire Today (press release), UK - May 9, 2008
This will be a unique book for self learning and getting expertization in Java database and web technologies such as JDBC, Servlet, JSP, JSTL and JSF. ...

Product review: WaveMaker?s point-and-click Java
InfoWorld, CA - Apr 17, 2008
You don't write SQL, JDBC, or any of the Hibernate configuration code. Then you click on a few more icons to create some Services -- note that the Dashboard ...

Could not open Hibernate Session for transaction; nested exception ...
???????, China - Apr 29, 2008
JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:318) at ...

DataDirect Technologies Brings Advanced Data Access Functionality ...
Business Wire (press release), CA - May 6, 2008
The new ODBC and JDBC? client driver technology enhances the DataDirect Shadow product?s data connectivity across a wide range of mainframe data and ...

MySQL CEO sees 'invisible hand' at work
LinuxWorld.au, Australia - May 5, 2008
Or, take our JDBC (Java database connectivity) driver. The community developed three, four or five. One was clearly the market leader. ...
MySQL 5.0 open source database LinuxWorld.au
all 4 news articles

More related news: "SQL-92" OR JDBC OR SQLJ OR "SQL:1999" OR "SQL-1999" OR "SQL-99" OR "Java Dat...

Related books at Amazon.com


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)
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...

JDBC Developer's Resource (2nd Edition)
by Art Taylor
Average Customer Review: 3 stars based on 8 reviews.
Customer Review: This book is good for a beginner. I read this book and it helped me tremondously. This book would not be good for the experienced beginner. The code is easy to follow; although some could have been written better. It is a good reference. -- Not the best I have read.

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 1 review.
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 ...

Understanding SQL and Java Together : A Guide to SQLJ, JDBC, and Related Technologies (The Morgan Kaufmann Series in Data Management Systems)
by Jim Melton, Andrew Eisenberg
Average Customer Review: 3 stars based on 4 reviews.
Customer Review: In the pletoria of books on Java and databases, this is the one book that just must be read. It gives a thourough enough introduction to JDBC 1.0 and 2.0 and SQLJ Parts 0-2. Very readable! Covers the subjects to just the right level for developers and database experts.

More related books: Search Amazon.com for JDBC

 

Copyright © 2000-2008 Barry & Associates, Inc. All Rights Reserved.
You can use this material for your work or classes. Click here for our reprint policy.
www.service-architecture.com

 

 Information on becoming a sponsor

 

 

Google

 

Barry & Associates, Inc.