> Yes, referential integrity is frequently forgotten by people > who design DBs, don't know why, maybe its sloppiness or they > want to be hired later on to "clean up" the database? > > ... > > As for DBAs using triggers for RI on local DB tables - this > is old school, not needed for something like 10 years with > large DBs (don't know about MySQL & 10 years). As mentioned > by you, declarative RI is the way to go.
I run into this somewhat often with DBAs who learned on very, very old mainframe databases, where declarative referential integrity wasn't an option. It is sometimes difficult to convince them why DRI is better, believe it or not. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242150 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
