©Copyright by Kazimierz Subieta.

This chapter is under construction.

Complexity of a Data Model vs. Complexity of Queries

by Kazimierz Subieta

Back to Description of SBA and SBQL.

We start from the very popular text Object-Relational DBMS - The Next Wave by Michael Stonebraker. He presents a picture showing the great advantage of object-relational DBMS applications over object-oriented DBMS applications, which looks as follows:

A Classification of DBMS Applications

However, there are dozens of implemented query languages addressing object-oriented DBMS. First our implementation of object-oriented SBQL in the Loqis DBMS was operating in 1989, earlier than the idea of object-relational databases have appeared. Many research groups implemented various object-oriented query languages. Our group implemented it several times, for academic prototypes and commercial products. So we strongly disagree with the above picture and consider it as incompetent or as an attempt to make a false commercial stereotype in favor of some particular technologies .

In the context of SBA and SBQL we consider more fairly what is good and wrong in object-relational database models and what they imply for query languages. We would like to prove in this section quite otherwise thesis: why object-relational database model is a very bad idea if one considers seriously the implementation and use of query languages.

First we compare SQL and SBQL on a very simple example.

 

 

 

 

 

 Why the idea of object-relational databases is very bad and why SQL-99 is a non-implementable eclectic monster.


Last modified: December 14, 2005