Re: foundations of relational theory?

Originally posted by Marshall Spight

> "cmurthi" <xyzcmurthi_at_quest.with.a.w.net> wrote in message news-
> :3F9C53BD.4030006_at_quest.with.a.w.net"]news:3F9C53BD.4030006_at_quest.wit-
> h.a.w.net[/url]...

> > Yes to the last; the integrity is up to the application.

>

> There are a number of problems that come from having

> applications enforce integrity. One nasty one is that bugs

> in the code translate into corrupted data. Another is

> that the integrity code needs to be in every application,

> and can get out of sync.

>

>

> Marshall

Some of this was discussed earlier in this or a related thread. No conclusions were arrived at (surprised?), but I have to restate the value of modular shareable code. I also think Chandru might have been talking about an application running *within* the DBMS. Obviously, if an application is external to the DBMS then the "hooks" on the DBMS side between application and database must enforce integrity constraints. It really wouldn't be right to expect the external application to enforce database integrity. I see that more clearly now as a result of this discussion. Did I mention that there is also less in the way of "references between tables" (new term I just made up) that need to be maintained? I did? Oh OK.

Regards

Mike.

--
Posted via http://dbforums.com