Database archiving how to keep lots of data for a very long time

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...

Descripción completa

Detalles Bibliográficos
Autor principal: Olson, Jack E. (-)
Formato: Libro electrónico
Idioma:Inglés
Publicado: San Francisco, Calif. : Oxford : Morgan Kaufmann ; Elsevier Science [distributor] c2009.
Edición:1st edition
Colección:MK/OMG Press
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627468306719
Tabla de Contenidos:
  • Front Cover; Database Archiving How to Keep Lots of Data for a Very Long Time; Copyright Page; Dedication Page; Contents; Preface; Organizations that are Likely to Need Database Archiving; Acknowledgments; Part 1: Archiving Basics; Chapter 1: Database Archiving Overview; 1.1 A Definition of Database Archiving; 1.2 Forms of Data Archiving; 1.3 The Data Lifeline; 1.4 Types of Data Objects; 1.5 Data Retention Requirements Versus Data Archives; 1.6 The Database Archives and Other Database Types; Summary; Chapter 2: The Business Case for Database Archiving
  • 2.1 Why Database Archiving is a Problem Today2.2 Implications of not Keeping Data; Summary; Chapter 3: Generic Archiving Methodology; 3.2 Define Motivation for Archiving; 3.4 Determine When to Put Objects in the Archive; 3.6 Determine What to do with Discarded Objects; 3.11 Determine Necessary Administrative Processes; Chapter 4: Components of a Database Archiving System; 4.5 Archive Data Management; 4.7 Archive Administration; Part 2: Establishing a Database Archiving Project; Chapter 5: Origins of a Database Archiving Application; 5.2 Recognizing Problems
  • 5.3 Assignment of Problems for Initial Study5.5 Determining the Basic Strategy for the Archiving Application; Chapter 6: Resources Needed; 6.5 Archive Server; Summary; Chapter 7: Locating Data; Summary; Chapter 8: Locating Metadata; 8.3 Selecting a Version of the Metadata; 8.4 Classifying Data; Summary; Chapter 9: Data and Metadata Validation; 9.4 Validating Data Classification; 9.6 Repeating Validation Activities; Summary; Part 3: Designing Database Archiving Applications; Chapter 10: Designing for Archive Independence; 10.2 Independence from DBMS; 10.3 Independence from Systems; Summary
  • Chapter 11: Modeling Archive DataSummary; Chapter 12: Setting Archive Policies; Chapter 13: Changes to Data Structures and Policies; 13.3 Changes to the Archive Data Model; 13.4 Managing the Metadata Change Process; Summary; Part 4: Database Archiving Application Software; Chapter 14: The Archive Data Store; 14.1 Archive Database Choices; Chapter 15: The Archive Data Extraction Component; 15.1 The Archive Extractor Model; 15.4 Integrity Considerations; Summary; Chapter 16: The Archive Discard Component; 16.3 Integrity Considerations; 16.4 Operational Considerations; Summary
  • Chapter 17: The Archive Access Component17.2 Access Through Generic Query and Search Tools; 17.4 Selective Data Unload; 17.6 Metadata Services; Part 5: Administration of the Database Archive; Chapter 18: Ongoing Auditing and Testing; 18.1 Responsibility for Ongoing Auditing and Testing; 18.3 Testing Activities; Chapter 19: Managing the Archive Over Time; 19.3 Using Hosted Solutions; Chapter 20: Nonoperational Sources of Data; Summary; Final Thoughts; Appendix A: Generic Archiving Checklist; Appendix B: Goals of a Database Archiving System
  • Appendix C: Job Description of a Database Archive Analyst