Chapter 2: Protecting Against User Errors and Conflicts
In This Chapter
Dealing with human errors: More trouble in paradise
Resolving operational errors
Taking the ACID test
Preventing mix-ups with transactions
Understanding lock types
Getting locks and the recovery system in tune
Using timestamps
After you have done everything you can do to minimize the possibility of problems due to hardware faults and Internet threats (which I discuss in Book IV, Chapter 1), you still have to worry about yet other things that can damage the data in your database or degrade performance.
Several additional potential sources of error exist. Here are a few of the most important:
♦ The database design could be faulty, leading to modification anomalies or poor performance.
♦ The database application written ...
