The robust capability for physical design present in Rdb means the DBA must make many choices for each piece of the database. This section discusses the choices, makes recommendations that will work well for most applications, and addresses how to decide which pieces should not use the general recommendations. Topics covered include export import, backup restore and load unload sequences. A discussion of which method is preferable in which context is also included. The laboratory includes restructuring of the student's database.
Any computer system has the potential to fail at some point.
Rdb's backup and journaling capability reduce the chance of data loss when failures occur. This section discusses Rdb's capabilities in the area of performance monitoring and tuning. This is, essentially, an introduction to the interpretation of RMU dynamic and static analysis of the database. Some points to look for are addressed and commonly encountered symptoms of poorly performing databases are displayed. Inc. JCC and the JCC logo are trademarks of JCC Consulting, Inc. VAX and VMS are trademarks of Digital Equipment Corporation.