Book description
With the amount of data a business accumulates now doubling every 12 to 18 months, IT professionals need to know how to develop a system for archiving important database data, in a way that both satisfies regulatory requirements and is durable and secure. This important and timely new book explains how to solve these challenges without compromising the operation of current systems. It shows how to do all this as part of a standardized archival process that requires modest contributions from team members throughout an organization, rather than the superhuman effort of a dedicated team.- Exhaustively considers the diverse set of issues—legal, technological, and financial—affecting organizations faced with major database archiving requirements
- Shows how to design and implement a database archival process that is integral to existing procedures and systems
- Explores the role of players at every level of the organization—in terms of the skills they need and the contributions they can make.
- Presents its ideas from a vendor-neutral perspective that can benefit any organization, regardless of its current technological investments
- Provides detailed information on building the business case for all types of archiving projects
Table of contents
- Brief Table of Contents
- Table of Contents
- Copyright
- Dedication
- Preface
- Acknowledgments
-
Part 1. Archiving Basics
- Chapter 1. Database Archiving Overview
- Chapter 2. The Business Case for Database Archiving
-
Chapter 3. Generic Archiving Methodology
- 3.1. The Methodology
- 3.2. Define Motivation for Archiving
- 3.3. Identify Objects to Archive
- 3.4. Determine When to Put Objects in the Archive
- 3.5. Determine How Long to Keep Objects in the Archive
- 3.6. Determine What to do with Discarded Objects
- 3.7. Determine Who Needs Access to Archives and How
- 3.8. Determine the Form of Archive Objects
- 3.9. Determine Where the Archive will be Kept
- 3.10. Determine Operational Processes Needed
- 3.11. Determine Necessary Administrative Processes
- 3.12. Determine Required Change Processes
- Summary
- Chapter 4. Components of a Database Archiving System
-
Part 2. Establishing a Database Archiving Project
-
Chapter 5. Origins of a Database Archiving Application
- An archiving organization
- 5.1. Problems that Lead to Database Archiving Solutions
- 5.2. Recognizing Problems
- 5.3. Assignment of Problems for Initial Study
- 5.4. Initial Problem Study Components
- 5.5. Determining the Basic Strategy for the Archiving Application
- 5.6. The Application Strategy Chart
- Summary
- Chapter 6. Resources Needed
- Chapter 7. Locating Data
- Chapter 8. Locating Metadata
- Chapter 9. Data and Metadata Validation
-
Chapter 5. Origins of a Database Archiving Application
- Part 3. Designing Database Archiving Applications
- Part 4. Database Archiving Application Software
- Part 5. Administration of the Database Archive
- Appendix Final Thoughts
- Appendix A. Generic Archiving Checklist
- Appendix B. Goals of a Database Archiving System
- Appendix C. Job Description of a Database Archive Analyst
- Glossary
- Glossary
- Bibliography
- Index
Product information
- Title: Database Archiving
- Author(s):
- Release date: July 2010
- Publisher(s): Morgan Kaufmann
- ISBN: 9780080884424
You might also like
book
MCITP Administrator: Microsoft® SQL Server™ 2005 Database Server Infrastructure Design Study Guide
This comprehensive book guides readers through Microsoft's brand-new SQL 2005 administrator exam: Designing a Database Server …
book
Beginning Backup and Restore for SQL Server: Data Loss Management and Prevention Techniques
Be guided through the techniques to back up and restore databases and files in SQL Server. …
book
Archives in the Digital Age
Archiving has become an increasingly complex process. The challenge is no longer how to store the …
video
Oracle 12c New Features, Part I LiveLessons
4+ Hours of Video Instruction Overview In the wake of the release of Oracle Database 12 …