18. Data and Storage Management

All DBMSs rely on data files to store data, and these files, or data sets, reside on storage media, or devices. Storage management is thus a key part of the database operations required of a DBA. Typically, storage means fixed disk drives or disk subsystems, but storage can also mean nonvolatile storage, solid-state devices, removable storage, optical storage, or tape devices.

Since the DBA deals with database management systems that store data, a good part of the DBA’s job will involve planning for the actual storage of database data. In order to perform this part of the job, the DBA must be conversant in the actual physical mechanisms available for data storage. Furthermore, the DBA must understand the ways in ...

Get Database Administration: The Complete Guide to DBA Practices and Procedures, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.