Database Archiving

Considers a set of issues-legal, technological, and financial-affecting organizations faced with major database archiving requirements. This work shows how to design and implement a database archival process that is integral to procedures and systems. It provides information on building the business case for various types of archiving projects.

Autorentext
Jack E. Olson is a widely recognized database technology expert. His career includes significant contributions at IBM, BMC, Evoke, and now NEON Enterprise Software, where he serves as Chief Technology Office. Olson is author of Data Quality: The Accuracy Dimension, also published by Morgan Kaufmann. The inventor of record on several patents, he holds a BS from the Illinois Institute of Technology and an MBA from Northwestern University.

Klappentext

Data archiving is a critically important topic for IT departments. 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 book is focused solely on solving the problem of archiving database data, not on other forms of data such as emails or documents, which require different solutions. It begins with a basic overview of database archiving, provides the business case for undertaking a database archiving project, then details the methods and tools needed to accomplish the task.

Inhalt

Part 1: Archiving BasicsChapter 1: On Overview of Database Archiving Chapter 2: An Overview of Business IssuesChapter 3: Generic Archiving MethodologyChapter 4: Basic ComponentsPart 2: Establishing a Database Archiving ProjectChapter 5: Origins of a Database Archiving ProjectChapter 6: Resources NeededChapter 7: Locating Data Chapter 8: Locating MetadataChapter 9: Data and Metadata ValidationPart 3: Designing Database Archiving ApplicationsChapter 10: Designing for Archive IndependenceChapter 11: Modeling Archive DataChapter 12: Setting Archive PoliciesChapter 13: Changes to Data Structures and PoliciesPart 4: Database Archiving Application SoftwareChapter 14: The Archive DatabaseChapter 15: The Archive Extractor Component Chapter 16: The Archive Discard Component Chapter 17: The Archive Access Component Part 5: Administration of the Archive Chapter 18: Testing Your ApplicationChapter 19: Managing Archive Data over TimeChapter 20: Managing Users Chapter 21: Managing ChangesPart 6: Business and Legal IssuesChapter 22: Non-operational Sources of Data Chapter 23: The Archive and the legal departmentChapter 24: The Archiving ASPAppendix A: Generic Archiving Checklist Appendix B: Goals of a Database Archiving SystemAppendix C: Job Description of Data Archivist