You might have seen the recent news reports about the collision between U.S. and Russian communication satellites. The U.S. satellite was one of the Iridium satellites. What wasn’t reported and you probably don’t know is that an object database management system (ODBMS) is an important part of the Iridium system. Even though ODBMSs are a [...]
February 13, 2009
I am now also posting on the Cutter Blog. My initial posting is (The Acronym) SOA is (Perhaps) Dead (at Some Companies); Long Live Services. It is a response to Anne Thomas Manes’ SOA is Dead; Long Live Services on her blog at the Burton Group.
January 9, 2009
The typical definition of an atomic task or process is one that cannot be decomposed further. This is vague and subject to interpretation. The Decomposition Matrix on this site uses a specific definition: A task (for business process diagrams) or a process (for data flow diagrams) is atomic if every input relates to every output [...]
December 3, 2008
My last posting referenced the criteria for a well-formed business process diagram mentioned in Business Process Driven SOA using BPMN and BPEL by Matjaz B. Juric and Kapil Pant. I am going to expand on their criteria to create a more comprehensive definition of a well-formed business process diagram.
To start, here are three criteria from [...]
November 18, 2008
I recently received two new books on business process modeling. Both books looked interesting because they had great titles. As it turns out, one book is great and the other not so good.
The not so good book is Business Process Driven SOA using BPMN and BPEL by Matjaz B. Juric and Kapil Pant. There are [...]
October 9, 2008
The Design Decomposition Blog is written by Doug Barry.
Mapping objects to tables involves creating or updating data stored in a relational database. This figure illustrates such a mapping. Mapping involves:
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.
There are nearly 400 pages of articles on this site with over 50 pages on object-relational mapping.
Search this site for more articles
Custom Search
Browse this site for more articles
Click on the topics below to browse the articles on this site. You can see more detail by clicking on the arrows. This highlights the location of the current
article: Mapping objects to tables.
Related recent articles from Google News
MODX Revolution 2.0 has been released CMS Critic It is built on a modern, object-oriented core with a fully documented API for developers, sits on top of a robust database Object-Relational Mapping (ORM) ... and more » 26 Jul 2010 at 7:54am
Mapping Quest Drives .NET ORMs Redmond Developer News (blog) This week, Microsoft shed some light on vNext of its "official" object-relational mapping tool, ADO.NET Entity Framework. On Wednesday, the first preview of ... 15 Jul 2010 at 8:22pm
EMC Big Data Play Continues: Greenplum Acquisition Enterprise Irregulars (blog) We have been forcing round holes into square pegs with object/relational mapping for years, but the approach is breaking down. Tools and datastores are ... and more » 7 Jul 2010 at 11:08pm
Google Chrome Vs Mozilla Firefox Boosh News (press release) (blog) One impressive features of CakePHP is its Object Relational Mapping (ORM) framework, which allows you to streamline SQL queries by presenting tables as ... and more » 19 Jul 2010 at 10:32pm
Pro LINQ Object Relational Mapping in C# 2008 by Vijay P. Mehta Average Customer Review: based on 11 reviews. Customer Review: I am not sure what the 2 and 3 star reviews are about, because I thought this book was excellent, and considering the book says "intermediate" I'm not sure why people were expecting a "deep technical ORM, LINQ to SQL, or EF" book. The book is broken into 5 different parts: Part 1 - ORM Concepts - This is really good background for p...
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...
based on 11 reviews.
based on 4 reviews.
