Re: what tools/procedures can be used for developping databases?

From: jlfoster <jlfoster_at_sprintpcs.kawm.INVALID>
Date: Fri, 17 Nov 2006 10:16:47 -0800
Message-ID: <vKGdnT5V2dA0YcDYnZ2dnUVZ_t-dnZ2d@got.net>

"Bram Mertens" <bram-mertens_at_linux.be> wrote in message news:wKd7h.188981$s37.2977935_at_phobos.telenet-ops.be...

> jlfoster wrote:

>> "Best practices" and "SQL" do not belong in the same document.
>>
>>
> Would you care to elaborate on that please?
>
> Are you implying that there is no good way to support multiple versions
> of a database (or data model)?
>
> How do you generate SQL "patches" and what procedures do you follow when
> applying them to a database?
>
> Thanks in advance.

SQL DBMS' have to convert the SQL commands into relational algebra anyway, so there ought to be a DBMS which exposes the relational algebra. Life would be easier for the DBMS and for the user/developer alike. SQL was originally intended to be a 'simple' query language for end-user, and just look how that turned out. Received on Fri Nov 17 2006 - 12:16:47 CST