Newletter Sign Up
Posts on the
Design Decomposition Blog
Iridium Satellite Collision in Space
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
(The Acronym) SOA is (Perhaps) Dead (at Some Companies); Long Live Services
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
Atomicity
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
Well-Formed Business Process Diagrams
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
Recent Business Process Modeling Books
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.

A comparison of relational and object model techniques is shown in the following table. It uses the concepts of data abstraction, inheritance, and encapsulation. Each of the links in the tables will open new windows containing more explanation.

Object Model Concepts Relational model concept Object model concept Object model benefits
Data abstraction Intersection entities and indexing to represent references between tuples OIDS to directly represent references between objects Simpler schema to represent complex data
Inheritance Type codes Class hierarchy Direct representation of the references between type and subtypes as well as support for specialized processing for each subtype
Encapsulation "If then else if" code based on type codes and management of the code, usually with libraries Encapsulation provides built-in dispatching to ensure the correct code executes on the correct data Reduced application code and reduced chance of error where the wrong code executes on the right data

Also see Chapter 3 in the Object Database Handbook. That chapter has an extensive comparison of the two models.

Related content for: Comparison of object and relational concepts

More on the general topic: Comparing the object and relational models

Read more free articles on this site

There are nearly 400 pages of articles on this site with over 40 pages on database concepts and standards.

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: Comparison of object and relational concepts.

Related recent articles from Google News

Browsing Database Artifacts Using Data Source Explorer
SYS-CON Media (press release)
In the Project Explorer view, you can find the object model under the package com.bea.beans of the branch web/WEB-INF/src/java. ...

4 Mar 2010 at 2:52pm
NoSQL Supporters Challenge Relational Databases
InternetNews.com
Cloudant provides commercial services for the open source Apache CouchDB NoSQL database. As opposed to an RDBMS, which uses a relational model to link data, ...

10 Mar 2010 at 6:10pm
SCALE 8x: Relational vs. non-relational
LWN.net
PostgreSQL hacker Josh Berkus set out to do some "mythbusting" about differences in database technologies in his talk at SCALE 8x. ...

3 Mar 2010 at 8:58pm
Neo4j: Java-based NoSQL Graph Database
InfoQ.com
Since Neo4j is a database, each access to the graph structure - read, write, and traversal - are managed by an ACID transaction system. ...

25 Feb 2010 at 10:16am
A look at ColdFusion 9's new features
Builder AU
This makes object-oriented development even easier, as you can build an object model without thinking about the database at all, and let Hibernate translate ...

2 Mar 2010 at 9:41pm
More related news on: database "object model" OR "relational model"

Related books at Amazon.com

Database Systems: Design, Implementation, and Management
Database Systems: Design, Implementation, and Management
by Peter Rob, Carlos Coronel
Average Customer Review: 4 stars based on 14 reviews.
Customer Review: Great Book, great information. I thought I knew something about databases having worked with them for 7 years. This book open my mind to the theories and the beginnings that need to take place before trying to make a database in a software. Very helpful and easy read book.
Citing Ancestry.com Databases & Images Quicksheet
Citing Ancestry.com Databases & Images Quicksheet
by Elizabeth Shown Mills
Average Customer Review: 5 stars based on 1 review.
Customer Review: I am glad this was recommended to me. I have Mills' book and this card is a great productivity aid.
Beginning Database Design: From Novice to Professional
Beginning Database Design: From Novice to Professional
by Clare Churcher
Average Customer Review: 4.5 stars based on 19 reviews.
Customer Review: I wanted to learn the fundamentals of modeling data and designing appropriate SQL tables for a moderately complicated online database, and I had been very frustrated with another book on data modeling that I had started off reading. Fortunately, I decided to try this Churcher book instead. It is clearly the work of a very intelligen...
Databases Demystified (Demystified)
Databases Demystified (Demystified)
by Andrew Oppel
Average Customer Review: 5 stars based on 24 reviews.
Customer Review: Very clear and concise coverage of many essential database issues. I really appreciate the brevity and lack of unnecessary jargon and formalism. However it's definitely worth pointing out that the examples come from Microsoft SQL, Microsoft Access and to a lesser degree Oracle.
The Manga Guide to Databases
The Manga Guide to Databases
by Mana Takahashi, Shoko Azuma, Trend-Pro Co. Ltd.
Average Customer Review: 4.5 stars based on 17 reviews.
Customer Review: Most of my friends and colleagues had to laugh when I told about or showed them this manga guide. Though this book is really fun to read and contains many subtle jokes, it's not something to dismiss as some crazy comic book. Don't fool yourself, under the happy Manga lies a superb learning book on databases. The book deals with the ...
More related books: Search Amazon.com for database model