Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Primary & Foreign key constraints

RE: Primary & Foreign key constraints

From: Miguel Urosa <murosa_at_smseuropa.com>
Date: Thu, 25 May 2000 09:37:09 +0200
Message-Id: <10508.106620@fatcity.com>

        If I don't remember bad, one premise of Relational Database is that Referential Integrity must be on database.

        Regards.

        Miguel.

> -----Mensaje original-----
> De: Jared Still [SMTP:jkstill_at_bcbso.com]
> Enviado el: mi=E9rcoles 24 de mayo de 2000 19:39
> Para: Multiple recipients of list ORACLE-L
> Asunto: RE: Primary & Foreign key constraints

>=20
>=20
>=20

> I think that any new OLTP application should be=20
> designed with RI in the database.
>=20

> I'll go even further and state that most of the=20
> application logic should be in the database as well.
>=20

> With Data Marts ( maybe Data Warehouses also ), the
> picture is somewhat cloudy.=20
>=20

> Your DW may not need RI. The DM likely will though
> so that Star Joins will work. The RI does not=20
> have to be enforced however, it just needs to exist
> for the optimizer to work properly.
>=20

> Jared
>=20
>=20

> On Wed, 24 May 2000, Abdul Aleem wrote:
>=20

> > Jared,
> >=20
> > I do not think, I practice ;). The tables in a database should have =
a PK
> to
> > uniquely identify each record. Then comes normalization. For =
normalized
> > tables, you have to have a FK. These are the basic RDBMS rules. =
Unless
> some
> > has not learnt them or forget ;)
> >=20
> > Now if you tell me what purpose does a database without RI solves, =
AND
> what
> > do you THINK?
> >=20
> > Regards,
> >=20
> > Aleem
> >=20
> > =09
> > On Mon, 22 May 2000, Abdul Aleem wrote:
> >=20
> > > There are no merits to this practice. I would say that the
> > person who
> > > designs a database without FK and PK is highly
> > unprofessional (an idiot) and
> > > has absolutely no idea of RDBMS design. This can lead to
> > current and future
> > > problems.=20
> >=20
> >=20
> > Come on Abdul, tell us what you really think! ;)
> >=20
> >=20
> > Jared Still
> > =09
> > --=20
> > Author: Abdul Aleem
> > INET: abchaudhary-ho_at_beaconhouse.edu.pk
> >=20
> > 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: ListGuru_at_fatcity.com (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).
> >=20
>=20
>=20

> Jared Still
> Certified Oracle DBA and Part Time Perl Evangelist ;-)
> Regence BlueCross BlueShield of Oregon
> jkstill_at_bcbso.com - Work - preferred address
> jkstill_at_teleport.com - private
>=20
>=20

> --=20
> Author: Jared Still
> INET: jkstill_at_bcbso.com
>=20

> 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: ListGuru_at_fatcity.com (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
Received on Thu May 25 2000 - 02:37:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US