O'Reilly logo

SQL All-in-One For Dummies®, 2nd Edition by Allen G. Taylor

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2: Protecting Against User Errors and Conflicts

In This Chapter

arrow Dealing with human errors: More trouble in paradise

arrow Resolving operational errors

arrow Taking the ACID test

arrow Preventing mix-ups with transactions

arrow Understanding lock types

arrow Getting locks and the recovery system in tune

arrow 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required