Re: Oracle Takeover Bid of PeopleSoft Falls Through

From: karthik <anon_at_anon.com>
Date: Fri, 27 Jun 2003 22:22:02 -0500
Message-ID: <bdj11c$44j$1@mozo.cc.purdue.edu>

<<The equivalent table in the competing products ... zero.>>

Do you mean competing products dont understand foreign keys?

An absolute No.

True, Oracle ERP does have foreign keys. But do you know why other ERP systems may not?. This is because almost any good ERP will implement their own data dictionary with respect to foreign keys. Meaning, they will enforce the delete rules themselves. This is because error handling is much easier as it works across database platforms. In Oracles case, Oracle ERP does not work with other databases. So they can enforce delete/foreign key rules using the oracle database

I worked in a medium sized ERP firm and later was with sometime with Oracle. In the first firm, the foreign key rules were built with the installation - meaning the ERP has its own data dictionary. They were pretty impressive. They worked irrespective of the database platform. Looking back, i cant say it worked better or worse than Oracles.

But i do have heard horror stories of SAP systems creating unnecessary indexes bordering on the ridiculous. something like:

create index my index1 on mytable (column1)
create index my index2 on mytable (column1,column2)
create index my index3 on mytable (column1,column2,column3)

This is ridiculous.

Regards
karthik

Daniel Morgan wrote:

> Mikito Harakiri wrote:
>
>

>>"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
>>news:3EEB57EA.4177408A_at_exxesolutions.com...
>>
>>>Go for it Larry. And after you've bought it ... if they can't understand
>>
>>the concept of a foreign key ...
>>
>>>close 'em down.
>>
>>Hmm... Do oracle apps folks understand what referential constraint (aka
>>foreign key) is?

>
>
> Last time I checked the gl_interface table, alone, had 17 referential
> constraints.
>
> The equivalent table in the competing products ... zero.
> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
>
Received on Fri Jun 27 2003 - 22:22:02 CDT