Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Relational Theory isn't dead
Message
 
 
To
05/03/1999 12:28:38
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00194550
Message ID:
00194682
Views:
21
>I probably would have agreed 100% a year ago. But now, with the discussion of n-Tier development, I think you can divorce (or view separately) the two.
>
>For example, the database arguable exists outside of any application that might access it. (If we start thinking enterprise-wide applications.) So if your database depends in anyway on your application to maintain integrity, what happens when another division writes and application that accesses pieces of the database?
>
>>I do not know if you can totally divorce the 2. {snip} Conversely, sound application design is essential to data integrity as well.

I guess the assumption that all data integrity checks are contained in the stored procedures of the database, default values, triggers, etc. I (and perhaps many) do not always think in these terms. While I do have some stored procedures (e.g., RI, PK generator which is called by code placed in the default value of the PK field), I do not always follow strict DB modeling. Now if I were designing a DB where the front-end were unknow or variable, then I would dang sure build all the integrity constraints into the DB.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform