A better DBMS Matrix

I believe we'd be better served by a change in the vertical axis of the DBMS Matrix. Handling queries is not a valid way to classify DBMSs. Many DBMSs handle queries, including relational, object, and object-relational. Navigation performance is a way to classify DBMSs. If we draw a new matrix taking navigation into consideration, a clearer, more accurate picture results, as shown in the following figure. By the way, it is assumed that all DBMSs in this matrix handle queries. Nevertheless, I have noted this in the left axis just so there is not mistaking this fact.

This matrix indicates that if you have a business need for high performance on complex data, you should be looking at ODBMSs. It is terribly wrong to discount ODBMSs based on the erroneous idea that they do not handle queries. It is more accurate to see that they handle queries and provide high performance navigation for complex data -- often, that navigation involves queries.

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

Object-oriented database management system (OODBMS) definition When an object database should be used ODBMS FAQ Caching for object database management systems Architectures that use object database products Everyday uses of object databases ODBMS myths > Object database problems? Article suggestions

Myth: ODBMSs have a steep learning curve Myth: ODBMSs are slow Myth: ODBMS do not support queries > Myth: ODBMS products do not scale

Stonebraker's DBMS Matrix >

Errors in Stonebraker's DBMS Matrix Navigating objects Query navigation A better DBMS Matrix >

Related recent articles from Google News

Saturn Corporation Targets Fundraisers, Direct Marketers With ... CRM Today - May 13, 2008 "CACHÉ enabled us to meet all of those objectives while also eliminating object-relational database impedance mismatch to provide the high level of ...

Dutch health charity deploy new CRM E-Health Europe, UK - May 12, 2008 ... and processes while also eliminating object-relational database impedance mismatch to provide the high level of performance that our customers expect. ...

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