Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Need for primary keys
Hi Brian,
What about use of unique indexes? Maybe, in your db there exists unique indexes instead.
And I wonder if this is a datewarehouse or an OLTP database. We have a DWH for example. We got no PKs in partitioned tables, we prefer using local unique indexes, instead of using global PKs in partitioned tables. It has lots of advantages.
Also 3nf mostly suits with OLTP systems. Discussion of this topic may help to envision our thoughts.
Regards,
Derya.
On 6/1/07, Jared Still <jkstill_at_gmail.com> wrote:
>
> On 6/1/07, amar kumar padhi <amar.padhi_at_gmail.com> wrote:
> >
> > Hi Brain,
> > - Constraints require Normalization and there are deviations in design
> > methodologies. For performance and data accessibility reasons, some
> > projects prefer not to normalize above 2F, some go till 3F.
> >
>
> Non 3nf will lead to data errors.
>
> For that matter, not going to 4nf will lead to data errors.
> There are alternatives for reporting.
>
> Materialized views for instance.
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 08 2007 - 01:41:37 CDT
![]() |
![]() |