Database Administration The Complete Guide to DBA Practices and Procedures

by Mullins, Craig S.

• ISBN13: 9780321822949
• ISBN10: 0321822943
• Edition: 2nd
• Format: Paperback
• Copyright: 2012-10-11
• Publisher: Addison-Wesley Professional

Summary

Craig Mullins'Database Administration, Second Editionis the definitive, technology-independent guide to the modern discipline of database administration. Packed with best practices and proven solutions for any database environment, this book fully reflects the field's latest realities and challenges. Drawing on his unsurpassed database experience, Mullins focuses on the problems today's DBAs actually face, and the skills and knowledge they simply must have. Mullins covers every aspect of the DBA role, including creating database environments; data modeling and normalization; design; performance; data integrity; compliance and governance; security; backup/recovery; disaster planning; data and storage management; data movement/distribution; data warehousing; database connectivity; metadata; tools, and more. This edition's updates and improvements include: * New coverage of "Big Data," database appliances, cloud computing, NoSQL, and other crucial trends * An all-new chapter on regulatory compliance and the DBA * New material on data breaches, auditing, data encryption, data retention, database archiving, data masking and sound metadata management policies * Coverage of important new features in leading databases (e.g. temporal data, multi-level security) * End of chapter questions that reinforce readers'understanding and can serve as project-oriented classroom assignments * New glossary and updated DBA "rules of thumb"

Author Biography

Craig S. Mullins is President and Principal Consultant of Mullins Consulting, a leading data and database management consultancy. Mullins has more than thirty years of experience in all facets of database administration and development, in industries ranging from manufacturing and finance to education and research. He covered database administration as Research Director for Gartner Group and authored DB2 Developer’s Guide, SixthEdition,the number one guide to DB2 for z/OS. Mullins publishes The Database Site (thedatabasesite.com) and presents at industry events worldwide. IBM named him Information Management Champion for his work in the DB2 community.

Table of Contents

Introduction: The Purpose of the Book
1. What is a DBA?
2. Creating the Database Environment
3. Data Modeling and Normalization
4. Database Design
5. Application Design
6. Design Reviews
7. Database Change Management
8. Data Availability
9. Performance Management
10. System Performance
11. Database Performance
12. Application Performance
13. Data Integrity
14. Regulatory Compliance and Governance
15. Database Security
16. Database Backup and Recovery
17. Disaster Planning
18. Data and Storage Management
19. Data Movement and Distribution
20. Data Warehouse Administration
21. Database Connectivity
22. Metadata Management
23. DBA Tools
24. DBA Rules of Thumb
Appendix 1. Database Concepts and Fundamentals
Appendix 2. DBMS Vendors
Appendix 3. DBA Tool Vendors
Appendix 4. DBA Web Resources
Bibliography
Glossary