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.
Using existing relational data with objects at the application level requires
mapping tables to objects.
This figure illustrates such a mapping. Details for mapping tables to objects
involve:
Mapping relational data types into object types. In most cases this is straightforward mapping.
Mapping relational table definitions to object classes. The table definitions map directly except for foreign keys. Those are replaced by relationships.
Mapping inheritance based on a table or multiple tables. There may be type codes in a given table used to identify types of entities, such as types of clothing or types of employees. Those types can be turned into an inheritance structure at the object application level. Similarly, there may be separate tables for different types of entities. Again, this can be turned into an inheritance structure.
Mapping tuple retrieval, keys and relational joins to relationships for object navigation. Object navigation replaces successive searches based on keys.
Mapping "intersection tables" to object relationships. An example of an intersection table is the "Size Color" table used in the examples. This table exists because the relational model does not support many-to-many relationships. The relationship between "Size" and "Color Swatch" is a many-to-many relationship because a given size can have many color swatches and a color swatch can apply to many sizes.
There are nearly 400 pages of articles on this site with over 50 pages on object-oriented database management systems.
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: Specifics for mapping tables to objects.
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.
