Re: Dreaming About Redesigning SQL

Seun Osewa wrote:
>
> 2) I still think there are some problems with the principle of "let
> the user only have to know the database at the logical level; separate
> the model from the implementation". It is nice if the user does not
> have to know anything about implementation to in order to execute
> queries and manipulate data. Its nice to let the DBA and DBMS be the
> one to worry about these things.

What is especially nice is that this separation, aka data independendence, is what gives you the flexibility that was the main raison d'etre of the relational model and one of the main reasons for its succes.

> But in order to do this properly the
> DBA _needs_ to know how the user is _likely_ to make use of the data.
> The user should be able to supply _hints_ to the DBMS to help it to
> optimize the way it lays out data, etc. [...]
>
> 3) I guess that's what all the commercial RDMSs are already doing ;)

Indeed.

• Jan Hidders