Mapping objects to tables involves creating or updating data stored in a relational database. This figure illustrates such a mapping.
The details of mapping involve:
Mapping objects to one or many tables. There are usually multiple ways to
map objects to tables. The issues include:
Mapping inheritance issues. Is the inheritance structure mapped to
multiple tables or is it mapped to one table with multiple type codes?
Determining how many classes per table. Sometimes a given class might be
stored as multiple tables or vice versa.
Making decisions related to the potential for redundant data. Since
object models do not need foreign keys or intersection entities, using
them in a relational database, in a sense, is creating redundant data.
Designing for multi-table updates. The prior issues often create the
need for updating multiple tables.
Mapping collection classes into tables. Decisions need to be made if a
collection is mapped to one or more tables.
Mapping object types to database data types. In most cases this is
straightforward mapping.
Mapping object relationships to keys or intersection tables. This is the
many-to-many relationship issue that is represented in a relational database
as an intersection table.
Easily manipulate data with LINQ Builder AU, Australia - 20 hours ago NET: This includes three variations: LINQ to SQL (working with relational data, with only SQL Server supported) provides an object relational 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 ...
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 ...
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).
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...
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...
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...
based on 1 review.
based on 4 reviews.
