Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Primary Keys optional?
I worked onsite at Baan Development for Oracle Development, so I know them
well. Acutally I live pretty close to their main offices here in the
Netherlands :-)
On 8/18/06, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>
> I'm not trying to promote the creation of tables w/o PKs, but just FYI -
> I work with the Baan ERP application (you've probably never heard of it,
> but I think they used to be #5 behind SAP, Oracle, etc. - Boeing is
> their largest customer) and they do not use PKs or any RI in the
> database - they use unique indexes with not null constraints, and they
> manage all the RI w/in the application. Not ideal, but I must admit
> they've done a pretty good job of implementing it this way - it's never
> caused us any problems in the 8yrs I've been working with it. I've
> heard that some of the other big ERPs (maybe even SAP - anyone know?)
> are designed similarly.
>
> Another thing to consider in letting the app manage the RI is that you
> can't easily view the relationships for reporting purposes when trying
> to use Crystal or some other 3rd party reporting tool.
>
> Regards,
> Brandon
>
>
>
>
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Anjo Kolk Owner and Founder OraPerf Projects tel: +31-577-712000 mob: +31-6-55340888 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 17 2006 - 17:42:07 CDT
![]() |
![]() |