Book description
"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
Table of contents
- Copyright
- Preface
- Acknowledgments
- About the Author
-
1. What Is a DBA?
- The DBA: Revered or Reviled?
- Why Learn Database Administration?
- The Management Discipline of Database Administration
- Database, Data, and System Administration
- DBA Tasks
- Types of DBAs
- Staffing Considerations
- Multiplatform DBA Issues
- Test and Production
- New Technology and the DBA
- DBA Certification
- The Rest of the Book
- Review
- 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
- Defining Availability
- Cost of Downtime
-
Availability Problems
- Loss of the Data Center
- Network Problems
- Loss of the Server Hardware
- Disk-Related Outages
- Operating System Failure
- DBMS Software Failure
- Application Problems
- Security and Authorization Problems
- Corruption of Data
- Loss of Database Objects
- Loss of Data
- Data Replication and Propagation Failures
- Severe Performance Problems
- Recovery Issues
- DBA Mistakes
- Outages: Planned and Unplanned
- Ensuring Availability
- Summary
- Review
- Suggested Reading
- 9. Performance Management
- 10. System Performance
- 11. Database Performance
-
12. Application Performance
- Designing Applications for Relational Access
- Relational Optimization
- Additional Optimization Considerations
- Reviewing Access Paths
-
SQL Coding and Tuning for Efficiency
-
SQL Rules of Thumb
- Rule 1: “It Depends!”
- Rule 2: Be Careful What You Ask For
- Rule 3: KISS
- Rule 4: Retrieve Only What Is Needed
- Rule 5: Avoid Cartesian Products
- Rule 6: Judicious Use of OR
- Rule 7: Judicious Use of LIKE
- Rule 8: Know What Works Best
- Rule 9: Issue Frequent COMMITs
- Rule 10: Beware of Code Generators
- Rule 11: Consider Stored Procedures
- Additional SQL Tuning Tips
- Identifying Poorly Performing SQL
-
SQL Rules of Thumb
- Summary
- Review
- Suggested Reading
-
13. Data Integrity
- Types of Integrity
- Database Structure Integrity
-
Semantic Data Integrity
- Entity Integrity
- Unique Constraints
- Data Types
- Default Values
-
Check Constraints
- Check Constraint Benefits
- Check Constraint Examples
- Triggers
- Referential Integrity
- DELETE Rule
- Pendant DELETE
- Setting Up Relationships
- Declarative RI Implementation Concerns
- DBMS Support for Referential Integrity
- Referential Integrity Using Triggers
- User-Managed vs. System-Managed RI
- RI vs. Check Constraints vs. Program Logic
- RI Rules of Thumb
- Summary
- Review
- Suggested Reading
- 14. Database Security
-
15. Database Backup and Recovery
- Preparing for Problems
-
Image Copy Backups
- Full vs. Incremental Backups
- Database Objects and Backups
- DBMS Control
- Concurrent Access Issues
- Backup Consistency
- Log Archiving and Backup
- Determining Your Backup Schedule
- DBMS Instance Backup
- Designing the DBMS Environment for Recovery
- Alternate Approaches to Database Backup
- Document Your Backup Strategy
- Database Object Definition Backups
- Recovery
- Alternatives to Backup and Recovery
- Summary
- Review
- Suggested Reading
- 16. Disaster Planning
- 17. Data and Storage Management
- 18. Data Movement and Distribution
-
19. Data Warehouse Administration
- What Is a Data Warehouse?
- Administering the Data Warehouse
- Summary
- Review
- Suggested Reading
- 20. Database Connectivity
- 21. Metadata Management
- 22. DBA Tools
- 23. DBA Rules of Thumb
- A. Database Fundamentals
- B. The DBMS Vendors
- C. DBA Tool Vendors
- D. DBA Web Resources
- Bibliography
Product information
- Title: Database Administration: The Complete Guide to Practices and Procedures
- Author(s):
- Release date: June 2002
- Publisher(s): Addison-Wesley Professional
- ISBN: 9780201741292
You might also like
book
Database Administration: The Complete Guide to DBA Practices and Procedures, Second Edition
is the definitive, technology-independent guide to the modern discipline of database administration. Packed with best practices …
book
Fundamentals of Database Management Systems, Second Edition
Gillenson's new edition of Fundamentals of Database Management Systems provides concise coverage of the fundamental topics …
book
Pro SQL Server Relational Database Design and Implementation: Best Practices for Scalability and Performance
Learn effective and scalable database design techniques in SQL Server 2019 and other recent SQL Server …
book
Microsoft SQL Server 2012 Bible
Harness the powerful new SQL Server 2012 Microsoft SQL Server 2012 is the most significant update …