Database Administration: The Complete Guide to Practices and Procedures

Front Cover
Addison-Wesley Professional, 2002 - Computers - 703 pages
1 Review

The first platform-independent guide to the discipline of database administration, this book presents best practices and procedures that apply to any database platform: Oracle, Microsoft, IBM, Sybase, even MySQL and Postgres. It will be an ideal resource for organizations that have deployed multiple databases -- and for professionals who want to move comfortably amongst database platforms. Craig Mullins begins with an up-to-date introduction to the field of database administration, outlining a broad range of DBA roles and responsibilities, and showing how evolving technology has changed the profession. He walks through creating the database environment; data modeling and normalization; database/application design; and change management. Next, he introduces best practices for maximizing availability, security, data integrity, and all aspects of system, database, and application performance. From data warehouse administration to Web-based data access, Database Administration: Practices and Procedures is a single source for authoritative guidance on every facet of database administration. For every database administrator, and for managers responsible for supervising database administrators.

 

What people are saying - Write a review

User Review - Flag as inappropriate

best book of oracle

Contents

Creating the Database Environment
49
Data Modeling and Normalization
89
Database Design
121
Application Design
159
Design Reviews
189
Database Change Management
203
CHAPTERS Data Availability
221
Performance Management
249
Data and Storage Management
465
Data Movement and Distribution
493
Data Warehouse Administration
515
Database Connectivity
537
Metadata Management
563
DBA Tools
577
DBA Rules of Thumb
607
Database Fundamentals
619

System Performance
267
Database Performance
295
Application Performance
319
Data Integrity
351
Database Security
385
Database Backup and Recovery
407
Disaster Planning
447
The DBMS Vendors
625
DBA Tool Vendors
631
DBA Web Resources
637
Bibliography
647
Index
661
Copyright

Other editions - View all

Common terms and phrases

About the author (2002)

Craig S. Mullins is a data management strategist for BMC Software. Craig has more than fifteen years of experience in all facets of database systems development, including developing and teaching DB2 and SQL Server classes, systems analysis and design, database and system administration, and data analysis. He has used DB2 for OS/390 since Version 1 and has experience with Oracle, Sybase, and Microsoft SQL Server. Craig has worked as a DBA, developer, instructor, and analyst in multiple industries.



0201741296AB05142002

Bibliographic information