Re: Normalization, Natural Keys, Surrogate Keys
Date: Fri, 31 May 2002 18:46:55 GMT
c_cozianu_at_hotmail.com (Costin Cozianu) writes:
[_excellent_ discussion snipped]
> No, using surrogate keys is terrible for a logical design and the
> flexibility comes only with sacrficing data quality goals. The only
> considerations that justify surrogate keys, is the inability of RDBMS
> to efficiently manipulate at the physical level (dsik layout) keys
> that are multiple columns and big in size. Also, no database that I
> know of has an otpion like ON UPDATE CASCADE for foreign key to
> allow for update propagations.
> But feel free to disagree.
FWIW, MS SQL Server 2000 supports ON UPDATE CASCADE.
-- Daryl Richter Lead Programmer, Exelon Power Team http://www.exeloncorp.com/powerteamReceived on Fri May 31 2002 - 20:46:55 CEST