Loading...
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 [...]
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 [...]
October 9, 2008
The Design Decomposition Blog
is written by Doug Barry.
Loading...

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.

Loading...

Related recent articles from Google News

TIBCO ActiveMatrix BPM In Depth
Enterprise Irregulars (blog)
Even better, you can import it from UML, XSD, WSDL or directly from a database, and can export it to XSD or WSDL. A business object model is then attached ...

1 Sep 2010 at 11:37am
SQL Server 2008 R2 for the Developer
Visual Studio Magazine
Report Manager has an improved interface that's easier to use, while Report Viewer uses AJAX and a JavaScript object model in Web reports to make it easier ...
and more »
31 Aug 2010 at 8:45am
Managing Models in ASP.NET MVC
Visual Studio Magazine
However, a view is the application's user interface and is going to need to support the user's workflow -- not the application's object model or the ...

31 Aug 2010 at 1:10pm
Using Windows PowerShell to Manage SharePoint 2010
Windows IT Pro
NET Framework and work directly with the SharePoint Object Model or Web Services. But now it's official, and administrators get to use the power of ...
and more »
27 Aug 2010 at 11:30am
A Primer on the 2010 US House and Senate Elections
The Narco News Bulletin
About the (achat microsoft) ribbon ui decides the complete object model unfavorably there integrates a usb drive near whichever the cells originated. ...

1 Sep 2010 at 2:02pm
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 15 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.
Fundamentals of Database Systems (6th Edition)
Fundamentals of Database Systems (6th Edition)
by Ramez Elmasri, Shamkant Navathe
Average Customer Review: 3.5 stars based on 56 reviews.
Customer Review: It's always refreshing to see a book with such a nice balance of theory and practice: the topic of databases is so huge that even an introduction of this size merely scratches the surface. I had a previous 'on-the-run' experience of SQL querying before tackling this book, but I've always felt that something was deeply missing. Study...
Modern Database Management (9th Edition)
Modern Database Management (9th Edition)
by Jeffrey A. Hoffer, Mary Prescott, Heikki Topi
Average Customer Review: 4 stars based on 17 reviews.
Customer Review: I used this book in graduate school while taking the Database Management System course. The book has usefull information. It help me understand and practice normalization. Some unfamiliar concepts also were learnt from the book. I can recommend this book to anyone getting into the database world.
More related books: Search Amazon.com for database model