Re: Can these constraint be implemented in an RDBMS ?
Date: Tue, 02 Mar 2004 12:18:46 GMT
Message-ID: <4044793f.9804438_at_news.wanadoo.es>
On Tue, 2 Mar 2004 11:15:40 +0100, "ben brugman" <ben_at_niethier.nl>
wrote:
>> There is a clear contradiction. Oracle and SQL-Server are not RDBMSs.
Oracle and SQL Server are not truly Relational Database Management
Systems, they violate The Relational Model in many ways.
No. I can't. They don't exist.
>Do you have a solution for the problem if this requirement (Oracle or
It does not seem very difficult.
>
>Can you clearify this a bit more ?
>SQL-server)
>is dropped.
summarize SetAccounts join Accounts per SetAccounts { Set } add Sum(Amount) as Amount;
create constraint MaxAmount
IsEmpty(Accounts where Amount > 100000000);
create constraint IndividualAccountsNotNegative
IsEmpty((Accounts join IndividualAccounts) where Amount < 0);
create constraint SetAccountsNotNegative
IsEmpty(SetAccountsAmount where Amount < 0);
create constraint MinimumAmount
IsEmpty(SetAccountsAmount join SetMinimums where Amount < MinimumAmount);
> The imaginairy customer still likes to make a choice between at
>least two 'RDBMSs'.
Then he would have to build at least two RDBMSs by himself :)
Regards
Alfredo
Received on Tue Mar 02 2004 - 13:18:46 CET