Converting the data and storing it in an object database

If you are in a situation where it makes more sense to convert the relational data to the object schema, then the equivalent views discussed earlier will again be of use. Each of these equivalent views has a corresponding relational view. See checking the class hierarchy (new window).

The relational view can be used to access the data in the relational database. The conversion process, however, will only use the relational views that correspond with the classes at the bottom of the class hierarchy, the leaf classes described earlier (new window). The converted data will be stored in these leaf classes. The classes in the object schema hierarchy above the leaf classes provide alternate ways to view or classify the data that is the equivalent to other views that existed in the relational schema.

To create a conversion program, use the single-valued views (the ones that use only one type code) to get the data from the relational database and populate object instances for the appropriate leaf class in the object schema managed by the Object DBMS (ODBMS). The upside of doing this is that you get the integration and performance provided by the ODBMS. The downside is that you will either convert the existing applications to access the ODBMS through an ODBC or JDBC interface or develop new applications. Many ODBMS products provide ODBC and JDBC interfaces. This allows the object data to appear as relational data, using the view equivalents that were presented earlier.

Next: Leaving the data in the relational database and using an object database. Also see the menu choices at the right below.

 

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
Object-relational mapping (OR mapping) definition
When object-relational mapping should be used
Mapping layer
Writing your own mapping layer
Using existing relational schema>
Article suggestions
Type codes
Using type codes to construct classes
Multi-type views
Checking the class hierarchy
Adding method code
Using the data>
Leaving the data in the relational database
Converting the data and storing it in an object database>
Leaving the data in a relational database and using an object database

Related recent articles from Google News


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

Data-Focused Visual Studio 2008 and .NET 3.5 SP1 Betas Released
Redmondmag.com, CA - May 12, 2008
The object relational mapping framework, based on the Entity Data Model, is still a work in progress. Some problems will not be addressed in EF version 1 ...

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

More related news: "object-relational mapping" - Google News

Related books at Amazon.com


Pro LINQ Object Relational Mapping in C# 2008 (Pro)
by Vijay P. Mehta
Publisher: Apress
Publication Date: June 2008

Foundation for Object / Relational Databases: The Third Manifesto
by C. J. Date, Hugh Darwen
Average Customer Review: 3 stars 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: 4 stars 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...

Multimedia Databases: An Object-Relational Approach
by Lynne Dunckley
Publisher: Pearson Education
Publication Date: January 2003

Database Directions: From Relational to Distributed, Multimedia and Object-Oriented Database Systems
by James Larson
Average Customer Review: 3 stars 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...

More related books: Search Amazon.com for object relational mapping

 

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.