This week introduces the basic techniques to protect and repair the database . We will cover the basic concepts of database performance tuning, which is useful for large databases. Upon completion of this chapter, you will have the following understanding:

1. Understand the types of possible failures in database system.
2. Understand the concept of transaction log.
3. Understand the role and importance of control file in the database system.
4. Know how to backup a database.
5. Know the basic technique to recover a database in case of crashes.
6. Understand the concept of tuning.
7. Understand the concept of index.
8. Understand the types of indices and when each can be used.
9. Understand the basic procedure of SQL tuning.

Students: Only a very small portion of the content for this week is covered by your textbook. You will need to do some research beyond the textbook. I highly recommend students get familiar with Oracle documents. You will get used to the authentic information from the source once you become a professional working in the field.

Have fun.

School of Technology
College of Business & Applied Sciences
Eastern Illinois University