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.
"One of Craig's hallmarks is his ability to write in a clear, easy-to-read fashion. The main purpose of any technical book is to transfer information from writer to reader, and Craig has done an excellent job. He wants the reader to learn―and it shows." ―Chris Foot, Senior Oracle Certified Instructor, Contemporary Technologies
"I think every business manager and every IT manager should have a copy of this book."―Dan Hotka, Senior Technical Advisor, Quest Software Inc.
With 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.
0201741296B05142002
