Transparent persistence vs. JDBC call-level interfaces
In November 1998, Torsten Stanienda and I wrote an article for IEEE
Computer that compared transparent persistence to a call-level interface.
The article was based on an exercise Torsten did that compared the ODMG transparent
persistence for Java to the JDBC call-level interface. Even though the article
goes back some years, the results of Torsten's exercise are worth noting.
Torsten created an example set of classes for Person, Professor, Student,
Course, and LectureRoom. He then wrote two sets of code to create, access, and
manipulate objects in each of the classes. One set of code used the ODMG Java
Binding and the other used the JDBC call-level interface. A summary of the
results are shown in the graph below. For this exercise, 496 lines of code were
needed using the ODMG Java Binding compared to 1,923 lines of code using JDBC.
What does this mean for you? Granted this is small example, but it does
demonstrate the difference in the lines of code needed between transparent
persistence and a call-level interface. This can be an advantage when it comes
to development costs. The results can be extrapolated to Java
Data Objects (JDO) or the ODMG C++ Binding. See transparent
persistence (new window). For additional
coding examples for transparent persistence, see how
to access data in a relational database (new window).
Note that this example does not cover the development time needed to design
the best mapping when using an object-relational mapping product. It also does
not cover entering this information into the object-relational mapping product
so that the mapping layer can be generated. Nevertheless, using transparent
persistence with an object-relational mapping products significantly reduces
development time. See development
costs with object-relational mapping products (new
window).
The article's title is "Solving the Java Storage Problem" and it
can be downloaded from the IEEE
Computer site (new window).
Which EII Solution Is Right for You? Web Services Journal, NJ - 14 hours ago ... data object's methods. In the relational and XML approach, the developer must work with generic data structures such as JDBC ResultSets or DOM objects. ...
Review: WaveMaker provides point-and-click Java Computerworld, MA - Apr 21, 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 ...
Java ORM Data Mapping Eclipse Plug-in Due Integration Developers, CA - Apr 11, 2008 Building to a database is the hardest part, and we?re still [using] JDBC, something that originated in the earliest days of Java. This [ORM tooling project] ...
Expert Oracle JDBC Programming by R.M. Menon Average Customer Review: based on 5 reviews. Customer Review: This book is about Oracle JDBC programming, not generic database neutral JDBC programming but Oracle specific. There are many JDBC books available and many Oracle and Oracle programming books but this concentrates narrowly on JDBC for Oracle, and how to get the best performance out of that combination. It is aimed at an audience that...
JDBC(TM) API Tutorial and Reference (3rd Edition) (The Java Series) by Maydene Fisher, Jon Ellis, Jonathan Bruce Average Customer Review: based on 21 reviews. Customer Review: Whether you are a beginner, intermediate, or advanced JDBC programmer you will find useful information in this book. The book is divided into two sections. The first section is a tutorial on using JDBC which makes up four chapters. The tutorial starts with a look at JDBC 1.0. The next chapter looks at the additional features added t...
Database Programming with JDBC and Java by George Reese Average Customer Review: based on 41 reviews. Customer Review: The text covers JDBC with enough depth, without burdening the reader with useless details available in any reference (in fact the reference is attached in an appendix, so there is no need to go looking online). Unlike other books it doesn't bore the reader with introduction to obvious concepts and examples. I highly recommend this f...
Jdbc Database Access With Java: A Tutorial and Annotated Reference (Java Series) by Graham Hamilton, Rick Cattell, Maydene Fisher Average Customer Review: based on 8 reviews. Customer Review: This book is well-written and has examples on using the SQL select, insert, delete and update commands. In addition, the topics on metadata is thorough. This is the best of the bunch, you won't be disappointed. It covers everything about database transactions - stored procedures, rollbacks and more.
JDBC Recipes: A Problem-Solution Approach by Mahmoud Parsian Average Customer Review: based on 3 reviews. Customer Review: I used some of the examples from this book (by cut-and-paste -- just chnaged the db URL, user/password) and they worked great. I needed to write some code for handling images and the BLOB code examples provided very good starting point. Thanks. Alex Hanif alex.hanif@yahoo.com