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