Database Administration: The Complete Guide to DBA Practices and Procedures, Rough Cuts, 2nd Edition
- By Craig S. Mullins
- Published Oct 5, 2012 by Addison-Wesley Professional.
Rough Cuts
- Available to Safari Subscribers
- About Rough Cuts
Rough Cuts are manuscripts that are developed but not yet published, available through Safari. Rough Cuts provide you access to the very latest information on a given topic and offer you the opportunity to interact with the author to influence the final publication.
Description
- Copyright 2013
- Dimensions: 7" x 9-1/8"
- Pages: 936
- Edition: 2nd
- Rough Cuts
- ISBN-10: 0-13-301275-1
- ISBN-13: 978-0-13-301275-0
This is the Rough Cut version of the printed book.
Database Administration, Second Edition, is the definitive, technology-independent guide to the modern discipline of database administration. Packed with best practices and proven solutions for any database platform or environment, this text fully reflects the field’s latest realities and challenges. Drawing on more than thirty years of database experience, Mullins focuses on problems that today’s DBAs actually face, and skills and knowledge they simply must have.
Mullins presents realistic, thorough, and up-to-date coverage of every DBA task, including creating database environments, data modeling, normalization, design, performance, data integrity, compliance, governance, security, backup/recovery, disaster planning, data and storage management, data movement/distribution, data warehousing, connectivity, metadata, tools, and more.
This edition adds new coverage of “Big Data,” database appliances, cloud computing, and NoSQL. Mullins includes an entirely new chapter on the DBA’s role in regulatory compliance, with substantial new material on data breaches, auditing, encryption, retention, and metadata management. You’ll also find an all-new glossary, plus up-to-the-minute DBA rules of thumb.
Sample Content
Table of Contents
How to Use This Book xxxiii
Acknowledgments xxxv
About the Author xxxvii
Chapter 1: What Is a DBA? 1
Why Learn Database Administration? 3
A Unique Vantage Point 4
The Management Discipline of Database Administration 9
Evaluating a DBA Job Offer 14
Database, Data, and System Administration 15
DBA Tasks 20
DBMS Release Migration 29
The Types of DBAs 31
Staffing Considerations 37
Multiplatform DBA Issues 42
Production versus Test 44
The Impact of Newer Technology on DBA 46
DBA Certification 56
The Rest of the Book 58
Review 58
Chapter 2: Creating the Database Environment 61
Defining the Organization’s DBMS Strategy 61
Installing the DBMS 75
Upgrading DBMS Versions and Releases 82
Database Standards and Procedures 92
DBMS Education 103
Summary 104
Review 104
Suggested Reading 105
Chapter 3: Data Modeling and Normalization 107
Data Modeling Concepts 108
The Components of a Data Model 113
Discovering Entities, Attributes, and Relationships 124
Conceptual, Logical, and Physical Data Models 125
What Is Normalization? 128
The Normal Forms 128
Normalization in Practice 135
Additional Data Modeling Issues 135
Summary 136
Review 137
Suggested Reading 138
Chapter 4: Database Design 141
From Logical Model to Physical Database 141
Database Performance Design 150
Denormalization 160
Views 175
Data Definition Language 177
Temporal Data Support 177
Summary 180
Review 181
Suggested Reading 182
Chapter 5: Application Design 185
Database Application Development and SQL 186
Defining Transactions 205
Locking 210
Batch Processing 221
Summary 222
Review 222
Suggested Reading 223
Chapter 6: Design Reviews 227
What Is a Design Review? 227
Types of Design Reviews 232
Design Review Output 239
Additional Considerations 240
Summary 241
Review 241
Suggested Reading 242