Another factor is that when RI was first introduced, people tended to
overuse it and then performance was bad. I don't think this is such a
problem today, but I think many ERP packages were either developed before RI
was common to all SQL databases, or were discouraged by the initial
problems. But I agree that the main factor has been that they try to be
compatible with all databases and the easiest way is to maintain their own
data dictionary and not implement RI in the database.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Nov 29 2001 - 10:53:42 CST
