Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Database Administration: The Complete Guide to Practices and Procedures 1st Edition

4.8 out of 5 stars 13 customer reviews
ISBN-13: 078-5342741292
ISBN-10: 0201741296
Why is ISBN important?
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used
Condition: Used - Good
Condition: Used: Good
Comment: This item is gently used in good or better condition. If it is a textbook it may not have supplements. It may have some moderate wear and possibly include previous owner's name, some markings and/or is a former library book. We ship within 1 business day and offer no hassle returns. Big Hearted Books shares its profits with schools, churches and non-profit groups throughout New England. Thank you for your support!
Access codes and supplements are not guaranteed with used items.
31 Used from $2.44
More Buying Choices
7 New from $34.97 31 Used from $2.44

Top 20 lists in Books
Top 20 lists in Books
View the top 20 best sellers of all time, the most reviewed books of all time and some of our editors' favorite picks. Learn more

Editorial Reviews

From the Back Cover

"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.


About the Author

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.


Product Details

  • Paperback: 736 pages
  • Publisher: Addison-Wesley Professional; 1 edition (June 24, 2002)
  • Language: English
  • ISBN-10: 0201741296
  • ISBN-13: 978-0201741292
  • Product Dimensions: 7.4 x 1.6 x 8.9 inches
  • Shipping Weight: 2.4 pounds
  • Average Customer Review: 4.8 out of 5 stars  See all reviews (13 customer reviews)
  • Amazon Best Sellers Rank: #270,211 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

Format: Paperback
This book has three things going for it:
(1) It describes the DBA function as it exists in the real world. More importantly, it breaks the categories of "DBA" out into specialities, such as system DBA, data architect, analysts and modelers, developers and data warehouse DBAs - each speciality is vastly different in practice - and provides skill profiles and roles and responsibilities for each.

(2) Proposes an organizational structure for all DBAs, regardless of database (DB2, Oracle, SQL Server, etc.) and skill. As a consultant who specializes in IT organizational management and processes I heartily endorse this structure. It's also consistent with recommendations made in "IT Organization: Building A Worldclass Infrastructure " by Harris Kern, Stuart Galup and Guy Nemiro, and "Building Operational Excellence: Strategies to Improve It People and Processes" by Dale Kutnick and Bruce Allen.

(3) A complete and comprehensive listing of tasks and responsibilities for DBAs, ranging from creating the database environment to data warehouse administration, and everything in between (data modelling, performance and capacity management, tuning, back-up and recovery, etc.)

While achieving the recommendations for organizational structure is a daunting and complex task, assimilating the extensive list of tasks and recommendations can be accomplished quickly. One way to attain immediate value from this book at the organizational level is to derive database administration policies and processes from this book, and refer to this book for the procedures.

The ideal audience for this book includes IT managers who need to understand the complexity and scope of the DBA function under their cognizance, senior DBAs who want to implement consistent procedures, and HR specialists who develop job descriptions and recruit DBAs.
1 Comment 26 of 27 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
1. This is one of very few titles on general database administration. Most other similar books focus on particular DBMS products.
2. It has a very comprehensive and broad coverage on the subject. The table of contents speaks for itself. Due to its extensiveness, the coverage by and large stays at the strategic and conceptual level, which serves its purpose very well.
3. It compares features of major database products on handling similar jobs.
4. The author clearly has extensive real life DBA experience with different DBMS products and has shared that with a very easy to understand language.
5. It has good resource links.
6. This book would be a great introduction and reference to those who are not only interested in a particular DBMS product but would also like to have a holistic view of database administration.
7. Finally the book has 660 pages before the index rather than 352 pages as stated on this site.
Comment 20 of 20 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
This is a well-written, well-organized guide to the practice of data base administration. Unlike other books on general database theory or relational database theory, this book focuses more directly on the theory and reality of database administration as practiced by database professionals today, and does so without catering too much to any specific product implementation. As such, Database Administration is very well suited to anyone interested in surveying the job of a DBA or those in similar but more specific roles such as data modeler or database performance analyst.
Yet, even with that direct focus on database administration, the author succeeds in covering a great deal of ground and cutting a rather wide swathe across the database spectrum, doing so with rigor and expertise and the benefit of experience. While the book will not and is not intended to serve as a reference substitute for product documentation, it will nonetheless enhance your knowledge, and I find it of such quality and utility that I recommend it to anyone in the database field in general. Consider it a base text to serve alongside Date and Codd.
Among the nice touches, the author includes discussion of database denormalization, often missing in discussions on database design. Chapters end with both a set of review questions and a Suggested Reading section, and I find myself in agreement with most of the suggestions. An excellent Bibliography section follows the text. I would have liked to see some discussion of the difference between relational domains in theory and their implementation in practice, particularly as it impacts the design of integrity constraints. Even so, Database Administration is an excellent book and I highly recommend it.
- Sal Ricciardi
Comment 14 of 15 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
This was a good introductory book about all the different

terms and concepts in generic database administration.

This book does more to cover from the managers perspective of all the

extra stuff that managers would think about in terms of data

loss, disaster recovery, recovery, etc.
Comment 4 of 4 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
This book by Craig Mullins is wonderfully insightful and truly important. Mullins describes the role and duties of data administrators and database administrators in modern organizations with remarkable insight and clarity. The book is lengthy, and somewhat dated. Yet, the essential truths recorded within resonate still. Any professional charged with data administration or database administration responsibilities in a large modern organization could profit greatly from reading this excellent and important book.
Comment 3 of 3 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews