Maintaining data integrity

Data Integrity Data integrity means that data in a database adheres to business rules. There are three primary ways in which data integrity can be maintained: Application code Database triggers Declarative integrity constraints Mapping the business rules using one of the three methods is a design decision. The database administrator is primarily concerned with implementing the methods chosen by the designer and balancing the performance needs against integrity requirements.

34p trinh02 28-01-2013 51 5   Download

Avoiding Locking Scenarios • Best Practices – Application – Use least restrictive isolation level that maintains the data integrity requirements of the application – Reduce Isolation level of specific statements by using statement level isolation (i.e.

3p hangkute_1 27-08-2010 73 7   Download