Defining Data Integrity
With respect to Oracle, data integrity often means that the data in the database consistently adheres to the business rules of the organization in question. The means by which this data remains consistent can be through application code, through the use of database triggers, and through declarative integrity constraints.
How any given business maps the business rules to these methods for designing in integrity is, usually, a combined decision made by the database administrator advising the designer. The administrator is primarily concerned with the implementation methods chosen by the designer and with balancing performance needs against the integrity requirements and the chosen method of implementation.
Application Code ...
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
