Search dba-db2.com
*Use the Comments section for questions
Recent Posts
DB2 enforcing business rules on data
15 January,2011 by Tom Collins
When designing data and related business rules, there are a number of concepts available to the DBA . Consider the following in
Primary Key definition
Foreign key definitions
User-defined distinct data types.
Nulls-allowed columns
Not null columns.
Column value constraint rules.
Before and after triggers. – (UPDATE,INSERT,DELETE)
Generated row change timestamps.
Distinct Data
Unique indexes.
Non-unique indexes
In summary , these concepts serve a purpose – and can be used effectively to maintain business data. This must be weighed up against performance and maintenance considerations
Ref:Jack Vamvas(http://www.dba-db2.com)
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright
Posted by: |