RE: Primary Keys optional?
- From: William B Ferguson <wbfergus@xxxxxxxx>
- To: "Khemmanivanh, Somckit" <somckit.khemmanivanh@xxxxxxxxxxxxxxxx>
- Date: Thu, 17 Aug 2006 14:44:40 -0600
It's rarely good practice to ever depend on an application for data
validation and integrity. Things (and applications) change.
Depend on the database for these simple and basic steps instead of the
application. And, if the application does do data validation and
integrity, nothing is broken anyway by enabling it at the database level.
-----------------------------------------------------------------------------
Bill Ferguson
U.S. Geological Survey - Minerals Information Team
PO Box 25046, MS-750
Denver Federal Center
Denver, Colorado 80225
Voice (303)236-8747 ext. 321 Fax (303)236-4208
~ Think on a grand scale, start to implement on a small scale ~
"Khemmanivanh, Somckit" <somckit.khemmanivanh@xxxxxxxxxxxxxxxx>
08/17/2006 02:39 PM
To
<wbfergus@xxxxxxxx>, <jkstill@xxxxxxxxx>
cc
<andert@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>,
<oracle-l-bounce@xxxxxxxxxxxxx>
Subject
RE: Primary Keys optional?
Could the data validations/verification be done at the App level?
Of course, the developers should have know this if that were the case...
Other related posts:
