It can be very tempting to write your own object-relational mapping. If fact,
there are books and articles advocating this. The bottom line, however, is that
unless you have a very simple mapping, it is a bad idea to write your own
mapping layer.
I have talked with plenty of developers who tried writing a mapping layer. The
result, although anecdotal, is universal. The mapping code, in each case, grew to
be 30 to 40 percent of the code needed for the entire application. There are two
problems that resulted from this. The first is that this is a lot of effort
towards writing code that is not addressing the business problem that prompted
the application development in the first place. The second is that, given the
development models that show how code defects rise with total code, a
significant number of additional defects appeared which, again, are not directly related to
the business problem being addressed by the application development.
So, if you have a relational database and you want to use C++ or Java, by all
means use an object-relational product. Writing a mapping layer is much harder
than you might expect. Some of the reasons this is hard can be seen in the
considerations for mapping:
DevExpress Announces the Newest Version of Its .NET Business ... Market Wire (press release) - Apr 29, 2008 To learn more about DevExpress business application framework and object-relational mapping tools for .NET, and to download a fully functional evaluation ...
Java ORM Data Mapping Eclipse Plug-in Due Integration Developers, CA - Apr 11, 2008 See why the JSR220-ORM Project lead says that object-relational mapping technologies are the ?last missing piece? for getting rid of the pain Java/J2EE devs ...
Eclipse to release new plug-in ITWeb, South Africa - Apr 15, 2008 Robert Greene, the project lead, said the latest Eclipse plug-in is a standards-based object-relational mapping design time tool, built to comply with the ...
Cincom Smalltalk Releases ObjectStudio 8.1 and VisualWorks 7.6 Market Wire (press release) - Apr 28, 2008 ... Cincom VisualWorks 7.6 also supports Microsoft Vista, OSX Leopard and MySQL, and includes a supported object-relational mapping framework (GLORP).
Ruby on Rails: weapons of mass customisation IT Wales, UK - Apr 15, 2008 Rather than adopt a complex object-relational mapping schema as is common in the Java world Rails adopts the simpler, more direct "ActiveRecord" pattern. ...
Foundation for Object / Relational Databases: The Third Manifesto by C. J. Date, Hugh Darwen Average Customer Review: based on 4 reviews. Customer Review: Mr. Data and Mr. Darwen have much to say in this book. The question is will community of "database" people read it, assimilate it, and get to sufficient mass to discuss the merits of the concepts described in this book? And, if that does happen, will it be too late to implement any of the concepts in a real DBMS? There is no question...
C++ Database Development: Featuring Parody the Persistent Almost-Relational Object Database Management System by Al Stevens Average Customer Review: based on 1 review. Customer Review: Al Stevens, C++ Database Development (MIS Press, 1992) Two questions come to mind as to why anyone would be reading a ten-year-old book on database development in an outdated edition written to cater to an operating system that (almost) no longer exists in any meaningful way. (Or why they would be reading a review of such a book.) Tho...
Database Directions: From Relational to Distributed, Multimedia and Object-Oriented Database Systems by James Larson Average Customer Review: based on 1 review. Customer Review: This book should be renamed as Database Pocket Guide.Good for College students ,who just want to refer to refresh themselves.Good for Database Users whojust want to know little details about Distributed Databases.But for people who are really serious about Distributed Databases, this is not the right choice. A Good one could be "Manag...