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 [...]
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 [...]
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
ZK with Non-relational Database mongoDB TheServerSide.com Typically, for relational databases developers either use plain JDBC or some sophisticated object-relational mapping library like Hibernate. This series of small talk will show how developers can develop non-relational database driven ZK applications. 26 Jan 2012 at 1:42pm
NoSQL NewSQL以及其他数据库编程语言 移动Labs Good bye object-relational mapping. New information management solutions are rapidly being adopted even by large corporations, for instance Nick Tan, from the Commonwealth Bank of Australia ... 17 Jan 2012 at 6:59pm
Doctrine 2 e Zend Framework 2, un esempio di combinazione vincente Programmazione.it Per chi quindi volesse avvalersi di tecniche ORM (Object Relational Mapping) per la propria applicazione basata su Zend Framework non resta che affidarsi a strumenti come Doctrine, cercando di ottenere una sana e proficua convivenza tra i due framework ... 30 Jan 2012 at 11:28pm
Databases: Database, Relational database, Relational model, Database management system, Database normalization, Object-relational mapping by Source: Wikipedia Description: Please note that the content of this book primarily consists of articles available from Wikipedia or other free sources online. Pages: 215. Chapters: Database, Relational database, Relational model, Database management system, Database normalization, Object-relational mapping, IBM Lotus Notes, Distributed database, Weak entity, Set domain, Open Database Connectivity, Commitment ord...
