Damn. I've been wracking my brain all day trying to figure out how to say
this.
Thanks, Dennis.
--Walt Weaver
Bozeman, Montana
-----Original Message-----
Sent: Thursday, November 29, 2001 1:55 PM
To: Multiple recipients of list ORACLE-L
Henry - The issue isn't the major RDBMS vendors, although there can be
interesting variations among them when it comes to how RI is implemented.
Most successful ERP packages have been around for a number of years, so they
have had to be available on many platforms. On some of those platforms the
popular database alternative might not have RI.
Another aspect from the vendor's point of view is being able to
create a package that will work at many, many sites and not require many
support calls, especially not require an experienced DBA. While in fact, as
you and I know, a serious package on Oracle should be supported by an
experienced DBA, when you are in a competitive sales situation, success is
spelled by "don't give the customer a reason not to buy our product." If the
customer doesn't have a DBA and they get the idea your package requires a
good DBA and your competitor is giving out hints that their package doesn't,
then the customer might just do something stupid and buy from your
competitor.
I'll give you an example of this. I don't know anything about Oracle
Applications (honest!). However, somebody told me that when it is installed,
no indexes are created. If true, that means that a DBA will need to figure
out the most common access paths for my site and create indexes. As an
ignorant purchaser, I could easily conclude that Oracle Applications were
difficult to administer.
I fully realize that from the point of view of the experienced DBA
there are a lot of reasons why life would be better if the idiot vendor
would implement RI, or many other things. I am just saying that the picture
looks different from the vendor's point of view, and the minuses probably
outweigh the plusses, and certainly for an existing product it must be
weighed against other development priorities. And if you decide to add it,
then you must figure a way to allow all existing customers to upgrade
without causing them a lot of problems and generating a lot of complaints.
Oh well, that is probably more than you wanted to know.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Thursday, November 29, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L
Just curious, but which of the major RDBMSs don't have RI?
Henry
-----Original Message-----
Sent: Thursday, November 29, 2001 10:55 AM
To: Multiple recipients of list ORACLE-L
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.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Henry Poras
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Weaver, Walt
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
