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:
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
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 ...
Understanding Relational Databases with Examples in SQL-92 by Fabian Pascal Average Customer Review: 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: 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: 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: 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 ...
based on 7 reviews.
based on 4 reviews.
based on 1 review.
