Database Administration: The Complete Guide to Practices and Procedures
Part tutorial and part reference, 'Database administration' explains and examines each of the components that comprise the discipline of database administration. The book opens by providing an overview of the responsibilities of database administrators (DBAs) along with the various ''flavors'' of DBAs and their tasks. From there, the book proceeds chronologically through every task a DBA is likely to encounter. Although designed as a comprehensive survey of the entire DBA environment, the book's individual chapters are also well suited for quick look-up of specific information.
What people are saying - Write a review
We haven't found any reviews in the usual places.
Creating the Database Environment
Data Modeling and Normalization
Database Change Management
CHAPTERS Data Availability
Data and Storage Management
Data Movement and Distribution
Data Warehouse Administration
DBA Rules of Thumb
access paths application development application program backup and recovery base check constraint clustering columns configuration create data cache data integrity data type data warehouse database administration database applications database change database design database environment database log database objects database performance database security database server DBA tools DBMS products DBMS vendors DBMSs defined DELETE denormalization design review disk downtime efficient ensure entity example files foreign key functionality Furthermore image copy backups impact implementation ISBN Java lock logical data model metadata Microsoft SQL Server modified monitor multiple operating system optimizer options Oracle organization outage parameters physical database primary key problems query recover referential referential integrity relational database request rows specific SQL Server SQL statements storage stored procedures structures Sybase system catalog tablespace tasks tion transaction log triggers tuning UNLOAD updated