Addison Wesley - Database Administration, The Complete Guide.pdf
(
6857 KB
)
Pobierz
625667785 UNPDF
Database Administration: The Complete Guide to Practices and Procedures
By
Craig S. Mullins
Publisher : Addison Wesley
Pub Date : June 14, 2002
•
Ta b l e
o f
ISBN : 0-201-74129-6
Contents
Pages : 736
Copyright
Preface
How to Use This Book
Acknowledgments
About the Author
Chapter 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
Chapter 2. Creating the Database Environment
Defining the Organization's DBMS Strategy
Installing the DBMS
Upgrading DBMS Versions and Releases
DBMS Education
Summary
Review
Chapter 3. Data Modeling and Normalization
The Components of a Data Model
Conceptual, Logical, and Physical Data Models
What Is Normalization?
The Normal Forms
Normalization in Practice
Additional Data Modeling Issues
Summary
Review
Suggested Reading
Chapter 4. Database Design
From Logical Model to Physical Database
Database Performance Design
Denormalization
Views
Data Definition Language
Review
Chapter 5. Application Design
Database Application Development and SQL
Defining Transactions
Database Standards and Procedures
Data Modeling Concepts
Discovering Entities, Attributes, and Relationships
Summary
Suggested Reading
Locking
Batch Processing
Summary
Review
Suggested Reading
Chapter 6. Design Reviews
What Is a Design Review?
Types of Design Reviews
Design Review Output
Review
Chapter 7. Database Change Management
Change Management Requirements
Impact of Change on Database Structures
Summary
Review
Chapter 8. Data Availability
Cost of Downtime
Availability Problems
Ensuring Availability
Review
Suggested Reading
Chapter 9. Performance Management
Defining Performance
Summary
Suggested Reading
Types of Changes
Defining Availability
Summary
Monitoring vs. Management
Service-Level Management
Types of Performance Tuning
DBMS Performance Basics
Review
Suggested Reading
Chapter 10. System Performance
The Larger Environment
DBMS Installation and Configuration Issues
System Monitoring
Summary
Review
Suggested Reading
Chapter 11. Database Performance
Techniques for Optimizing Databases
Summary
Review
Suggested Reading
Chapter 12. Application Performance
Relational Optimization
Additional Optimization Considerations
Reviewing Access Paths
SQL Coding and Tuning for Efficiency
Summary
Suggested Reading
Performance Tuning Tools
Summary
Database Reorganization
Designing Applications for Relational Access
Review
Chapter 13. Data Integrity
Types of Integrity
Database Structure Integrity
Semantic Data Integrity
Summary
Review
Suggested Reading
Chapter 14. Database Security
Database Security Basics
Granting and Revoking Authority
Authorization Roles and Groups
Other Database Security Mechanisms
Auditing
External Security
Summary
Suggested Reading
Chapter 15. Database Backup and Recovery
Image Copy Backups
Alternatives to Backup and Recovery
Summary
Review
Suggested Reading
Chapter 16. Disaster Planning
The Need for Planning
Backing Up the Database for Disaster Recovery
Disaster Prevention
Review
Preparing for Problems
Recovery
General Disaster Recovery Guidelines
Plik z chomika:
mistreich
Inne pliki z tego folderu:
Biblia Access 2003.rar
(20520 KB)
Addison Wesley - Database Administration, The Complete Guide.pdf
(6857 KB)
(Access)---Microsoft Access Database Tutorial.rar
(810 KB)
Access 2003 Biblia.pdf
(1853 KB)
Access Database Design And Programming.rar
(928 KB)
Inne foldery tego chomika:
Esperanto
Kuchnia
NLP
webmastering
Zgłoś jeśli
naruszono regulamin