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: brutally simple question - number of triggers on a table

Re: brutally simple question - number of triggers on a table

From: Tim Gorman <tim_at_evdbt.com>
Date: Fri, 22 Apr 2005 21:14:11 -0600
Message-ID: <BE8F19A3.26495%tim@evdbt.com>


> While not particularly fond of triggers, foreign keys are definitely
> mandatory. Always. No exceptions.

In a data warehouse, this is not true. RI constraints such as PK, UK, and FK constraints are themselves the exception.

RI constraints exist for the purpose of enforcing RI, plus a few ancillary roles like documentation, plus some Oracle-specific side purposes such as query rewrite integrity enforcement in materialized views.

The purpose of a data warehouse does not include enforcing either business rules or referential integrity. Its purpose is to accurately extract, transform, load, and present data provided from operational source systems.

This isn't to rationalize an expediency. Neither is RI enforcement irrelevant or inconvenient. Rather, RI enforcement is no more the responsibility of the data warehouse than law enforcement is the responsibility of plumbers. Simply not part of the job description.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 22 2005 - 23:22:54 CDT

Original text of this message

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