RE: interesting snippet from Oracle FUD paper

From: Go-Faster Consultancy Ltd. <info_at_go-faster.co.uk>
Date: Thu, 20 Jan 2011 13:54:14 -0000
Message-ID: <FFAF200E56BB48CF9725C4BFB7413753_at_GOFASTER4>

With PeopleSoft the numbers vary with product and version, but they are reasonable to within an order of magnitude (neglecting multiple copies of working storage tables)..
I interpreted PK to mean that database constraint Yes, unique indexes do enforce uniqueness, but there are some nullable key columns!    

regards

---

David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
mailto:david.kurtz_at_go-faster.co.uk
web: www.go-faster.co.uk
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
<http://www.psftdba.com/>

DBA Blogs: PeopleSoft: http://blog.psftdba.com <http://blog.psftdba.com/> , Oracle: http://blog.go-faster.co.uk <http://blog.go-faster.co.uk/> PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba  

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Toon Koppelaars
Sent: Thursday, January 20, 2011 1:42 PM To: niall.litchfield_at_gmail.com
Cc: ORACLE-L
Subject: Re: interesting snippet from Oracle FUD paper Importance: High

How is that number determined?

You can have PK enforcement using non-unique indexes...

On Thu, Jan 20, 2011 at 2:31 PM, Niall Litchfield
<niall.litchfield_at_gmail.com> wrote:

There is an Oracle whitepaper comparing RAC (wonderful, performant and simple) with SQL Server 2008 (awful, slow and complex :)) In it there is an interesting table for ERP schemas. Now I know some of apps predates declarative referential integrity, but that was introduced an awfully long time ago now.

                        Tables   Primary Key Indexes     
Peoplesoft               7,493                 6,438     
Oracle eBusiness (ERP)   8,155                   800  
SAP                     16,500                16,329 

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info





-- 
Toon Koppelaars
RuleGen BV
Toon.Koppelaars_at_RuleGen.com
www.RuleGen.com
TheHelsinkiDeclaration.blogspot.com

(co)Author: "Applied Mathematics for Database Professionals"
www.rulegen.com/am4dp-backcover-text





--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 20 2011 - 07:54:14 CST