Comparison of object and relational concepts

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.

 

Web Services and Service-Oriented Architectures
Online articles>
Consulting
Mentoring
Speaking
Suggested programs
Stencils for the Savvy Manager's Guide
Links
Mail list
Privacy policy
Sitemap
Contact
Web Services articles
XML standards and vocabularies
Application server articles
Database concepts and standards>
Object database articles
Relational database articles
Object-relational mapping articles
XML database articles
XML middleware articles
Article Sponsorship
Reprint policy
Basic concepts for using a DBMS
Database models>
DBMS standards
Article suggestions
Object model concepts
Relational model concepts
Comparing the object and relational models>
Comparison of object and relational terminology
Comparison of object and relational concepts>

Related recent articles from Google News


Easily manipulate data with LINQ
Builder AU, Australia - May 14, 2008
Linq namespace for working with relational database systems. It allows you to generate an object model that represents the structure and content of the data ...

Oracle Jumps Into the Collaboration Market (Again)
Gartner, CT - May 14, 2008
Oracle Beehive has some attractive characteristics, such as a consistent object model, tags, Outlook support and Business Process Execution Language (BPEL) ...

Use PCOMM Scripts to Execute Remote PC Commands
IT Jungle, NY - May 14, 2008
VBScript can also create Excel documents, Word documents, access the PC or network file system, read and write text files, access a remote database, ...

Corticon Unveils the "Corticon Automated Customer Acquisition ...
PR Web (press release), WA - May 13, 2008
Corticon ACA Content Framework - Insurance object model supporting products, factors, rates and enrollment transactions, accessed through the Business ...

Data Points
MSDN Magazine - May 2, 2008
NET object model. EntityConnection is used to connect to the EDM, EntityCommand is used to issue a query against the EDM, and the results of the command are ...

More related news: database "object model" OR "relational model" - Google News

Related books at Amazon.com


Modern Database Management (8th Edition)
by Jeffrey A. Hoffer, Mary Prescott, Fred McFadden
Average Customer Review: 3.5 stars based on 14 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.

Databases Demystified (Demystified)
by Andrew Oppel
Average Customer Review: 5 stars based on 21 reviews.
Customer Review: There are two things in life that are difficult: databases and comedy. Fortunately, the author makes understanding databases far less difficult with his clear explanations and examples. I confess that some aspects of a database (and I have some experience) are still a mystery, but I hurriedly read this book because I have some much ...

Database Systems: Design, Implementation, and Management, Seventh Edition
by Peter Rob, Carlos Coronel
Average Customer Review: 3.5 stars based on 26 reviews.
Customer Review: This text covers database theory and some SQL (two chapters or so). I think it's generally good book as an intro to database systems. It will not make you into DBA or programmer, but you'll feel better grip of database concepts you may encounter in other more 'practical' books (like DB programming, or administration). To learn SQL f...

The American Church in Crisis: Groundbreaking Research Based on a National Database of over 200,000 Churches
by David T. Olson
Average Customer Review: 5 stars based on 2 reviews.
Customer Review: This book does an excellent job of bridging a well-researched assessment of the Church in America, with practical responses that the Church must make in order to fulfill the mission of the Kingdom of God. Olson approaches the reality of an American Church in decline with love and respect for the Body of Christ; while he gives church ...

Database Systems: Design, Implementation, and Management, Eighth Edition
by Peter Rob, Carlos Coronel
Average Customer Review: 3 stars based on 1 review.
Customer Review: Book does not come with the student content that it is suppose to come with. It is supposed to come with online appendices A though L and downloads for files used in each chapter. I would not advise to by a 130 dollar incomplete book. It was release in December of 2007 unprepared for people to use because it makes references to sites ...

More related books: Search Amazon.com for database model

 

Copyright © 2000-2008 Barry & Associates, Inc. All Rights Reserved.
You can use this material for your work or classes. Click here for our reprint policy.
www.service-architecture.com

 

 Information on becoming a sponsor

 

 

Google

 

Barry & Associates, Inc.