What do you think?
Rate this book
Database Administration: Practices and Procedures
Best practices for database administration -- regardless of database platform -- An ideal resource for both database administrators and IT organizations supporting multiple database platforms.
-- Covers data modeling and normalization, database/application design, availability, security, data integrity, database performance, and much more.
-- In-depth, up-to-the-minute coverage of backup, recovery, disaster planning, storage management, and data distribution.
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.
-- Covers data modeling and normalization, database/application design, availability, security, data integrity, database performance, and much more.
-- In-depth, up-to-the-minute coverage of backup, recovery, disaster planning, storage management, and data distribution.
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.
First published June 14, 2002
13 people are currently reading
90 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 3 of 3 reviews
December 16, 2019
Best Book ever
July 5, 2013
This book is a guide to the discipline of modern database administration and gives detailed instructions and requirements of database administration. It is an excellent book for learning database administration activities, processes and procedures. All stages from creating a database to managing and maintaining the database are detailed. This book is useful for novice DBAs, database professionals and system administrators.
The author gives real-time solutions and examples from database administration experience and explains how to successfully deal with the problems and issues of managing and maintaining databases in software projects.
This book consists of 24 chapters, each detailing a specific topic, such as roles and responsibilities of database administrator; database design; database change management; performance management systems; database and application performances; database security, and rules of thumb for databases such as Oracle, DB2, SQL Server and Sybase. This book also gives a comprehensive sequential overview of a DBA job.
The appendix section provides an extremely useful list of DBMS vendors, DBA tool vendors, DBA web resources, and sample DBA job postings.
Reviewed by Sreerekha Bakaraju MBCS, Software Professional
The author gives real-time solutions and examples from database administration experience and explains how to successfully deal with the problems and issues of managing and maintaining databases in software projects.
This book consists of 24 chapters, each detailing a specific topic, such as roles and responsibilities of database administrator; database design; database change management; performance management systems; database and application performances; database security, and rules of thumb for databases such as Oracle, DB2, SQL Server and Sybase. This book also gives a comprehensive sequential overview of a DBA job.
The appendix section provides an extremely useful list of DBMS vendors, DBA tool vendors, DBA web resources, and sample DBA job postings.
Reviewed by Sreerekha Bakaraju MBCS, Software Professional
Displaying 1 - 3 of 3 reviews