Re: foundations of relational theory?

In article <53pmb.22158$Fm2.11121_at_attbi_s04>, Marshall Spight <mspight_at_dnai.com> writes
>"Tony Gravagno" <g6q3x9lu53001_at_sneakemail.com.invalid> wrote in message
>news:u7gnov0pe694d7hdnbbf3u265vjddrup5o_at_4ax.com...
>> Also,
>> relational people want the DBMS to maintain referential integrity,
>> while Pick people assume that's the responsibility of the app
>> developer - neither view is "right" in terms long-lasting, quality
>> solutions, they're just different.
>
>There are specific practical benefits to enforcing integrity
>in the DBMS vs. enforcing them in the various applications.
>It's not a question of preferences.
>

Don't forget - when integrity is a matter of keeping the *multiple* tables that model a *single* entity in sync, the problem of integrity just DOES NOT EXIST for MV. Where in relational, one table is an attribute of another table (eg order detail is an attribute of invoice), we just don't have that relationship between tables. Integrity "just happens" for us.

Cheers,
Wol

-- 
Anthony W. Youngman - wol at thewolery dot demon dot co dot uk
Witches are curious by definition and inquisitive by nature. She moved in. "Let 
me through. I'm a nosey person.", she said, employing both elbows.
Maskerade : (c) 1995 Terry Pratchett