Résumé
Database Administration, database professionals now have a comprehensive sourcebook of strategies for delivering quality administration across today's challenging multi-DBMS environments. Filled with practical guidelines and strategies, this book provides the most comprehensive survey available of the administrator's world for the existing or aspiring database professional.
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.
Highlights include:
- The world of the DBA: types, tasks, daily issues, and much more
- The DBA environment—installation and upgrading issues, standards, and procedures
- Data modeling and normalization
- Database design and application design
- Performance management, including system, database, and application performance
- Ensuring data integrity and database security
- Database back-up and recovery strategies and disaster planning
- Storage management and data warehouse administration
- Connectivity, metadata management, Internet-enabled database access, and additional DBA tools
- Platform-independent coverage applicable for all the major DBMS products including DB2, Oracle, and SQL Server
Whether you're a database analyst, architect, or application engineer, this book will provide the strategies and solutions you need to navigate the rocky terrain of today's complex data environments.
Contents
- 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. Database Security.
- 15. Database Backup and Recovery.
- 16. Disaster Planning.
- 17. Data and Storage Management.
- 18. Data Movements and Distribution.
- 19. Data Warehouse Administration.
- 20. Database Connectivity.
- 21. Metadata Management.
- 22. DBA Tools.
- 23. DBA Rules of Thumb.
- Appendix 1. Database Fundamentals.
- Appendix 2. The DBMS Vendors.
- Appendix 3. DBA Tool Vendors.
- Appendix 4. DBA Web Resources.
L'auteur - Craig S. Mullins
is Director of DB2 Technology Planning for BMC Software, Inc. He has extensive experience in all facets of database systems development, including systems analysis and design, database and system administration, data analysis, and developing and teaching DB2 and Sybase classes. Craig has worked with DB2 since Version 1 and has experience in multiple roles, including programmer, DBA, instructor, and analyst.
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Addison Wesley |
Auteur(s) | Craig S. Mullins |
Parution | 10/07/2002 |
Nb. de pages | 704 |
Format | 18,7 x 23,4 |
Couverture | Broché |
Poids | 1085g |
Intérieur | Noir et Blanc |
EAN13 | 9780201741292 |
ISBN13 | 978-0-201-74129-2 |
Avantages Eyrolles.com
Nos clients ont également acheté
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse