| Preface | p. xiii |
| Acknowledgments | p. xvii |
| Archiving Basics | |
| Database Archiving Overview | p. 3 |
| A Definition of Database Archiving | p. 4 |
| Forms of Data Archiving | p. 6 |
| The Data Lifeline | p. 12 |
| Types of Data Objects | p. 15 |
| Data Retention Requirements Versus Data Archives | p. 16 |
| The Database Archives and Other Database Types | p. 19 |
| The Business Case for Database Archiving | p. 21 |
| Why Database Archiving Is a Problem Today | p. 21 |
| Implications of Not Keeping Data | p. 25 |
| Data Volume Issues | p. 27 |
| Change Management | p. 30 |
| Current Database Archiving Practices | p. 31 |
| Generic Archiving Methodology | p. 33 |
| The Methodology | p. 33 |
| Define Motivation for Archiving | p. 35 |
| Identify Objects to Archive | p. 39 |
| Determine When to Put Objects in the Archive | p. 42 |
| Determine How Long to Keep Objects in the Archive | p. 44 |
| Determine What to Do with Discarded Objects | p. 47 |
| Determine Who Needs Access to Archives and How | p. 47 |
| Determine the Form of Archive Objects | p. 48 |
| Determine Where the Archive Will Be Kept | p. 50 |
| Determine Operational Processes Needed | p. 57 |
| Determine Necessary Administrative Processes | p. 59 |
| Determine Required Change Processes | p. 59 |
| Components of a Database Archiving System | p. 63 |
| The Database Archiving Organization | p. 63 |
| Archive Application Data Gathering | p. 64 |
| Archive Application Design | p. 65 |
| Archive Data Extraction | p. 65 |
| Archive Data Management | p. 66 |
| Archive Access | p. 66 |
| Archive Administration | p. 67 |
| Establishing a Database Archiving Project | |
| Origins of a Database Archiving Application | p. 71 |
| Problems That Lead to Database Archiving Solutions | p. 72 |
| Recognizing Problems | p. 73 |
| Assignment of Problems for Initial Study | p. 75 |
| Initial Problem Study Components | p. 75 |
| Determining the Basic Strategy for the Archiving Application | p. 78 |
| The Applciation Strategy Chart | p. 83 |
| Resources Needed | p. 85 |
| People | p. 85 |
| Authority | p. 87 |
| Education | p. 88 |
| Repository | p. 88 |
| Archive Server | p. 89 |
| Software Tools | p. 89 |
| Disk Storage | p. 90 |
| Locating Data | p. 93 |
| Inventorying Data | p. 93 |
| Picking the Archivist's Data | p. 99 |
| Documenting Data Sources | p. 100 |
| Locating Metadata | p. 103 |
| Metadata Definitions | p. 103 |
| Where to Find Metadata | p. 109 |
| Selecting a Version of the Metadata | p. 113 |
| Classifying Data | p. 114 |
| Documenting Metadata | p. 117 |
| Keeping Up with Changes | p. 118 |
| Data and Metadata Validation | p. 121 |
| Matching Data to Metadata | p. 121 |
| Assessing Data Quality | p. 123 |
| Assessing Metadata Quality | p. 124 |
| Validating Data Classification | p. 125 |
| Documenting Validation Activities | p. 125 |
| Repeating Validation Activities | p. 126 |
| Designing Database Archiving Applications | |
| Designing for Archive Independence | p. 129 |
| Independence from Application Programs | p. 129 |
| Independence from DBMS | p. 132 |
| Independence from Systems | p. 133 |
| Independence from Data Formats | p. 133 |
| Modeling Archive Data | p. 137 |
| The Source Data Model | p. 137 |
| The Target Data Model | p. 142 |
| Model Representations | p. 147 |
| Setting Archive Policies | p. 149 |
| Extract Policies | p. 149 |
| Archive Storage Policies | p. 154 |
| Archive Discard Policies | p. 157 |
| Validation and Approval | p. 159 |
| Changes to Data Structures and Policies | p. 161 |
| Archiving System Strategies for Handling Metadata Changes | p. 161 |
| Metadata Change Categories | p. 163 |
| Changes to the Archive Data Model | p. 170 |
| Managing the Metadata Change Process | p. 171 |
| Changes to Archive Policies | p. 172 |
| Maintaining an Audit Trail of Changes | p. 176 |
| Database Archiving Application Software | |
| The Archive Data Store | p. 181 |
| Archive Database Choices | p. 182 |
| Important Features | p. 185 |
| False Features | p. 193 |
| How Choices Stack Up | p. 195 |
| The Archive Data Extraction Component | p. 197 |
| The Archive Extractor Model | p. 198 |
| Extractor Implementation Approaches | p. 200 |
| Execution Options | p. 203 |
| Integrity Considerations | p. 205 |
| Other Considerations | p. 209 |
| The Archive Discard Component | p. 215 |
| Data Structure Considerations | p. 215 |
| Implementation Form | p. 219 |
| Integrity Considerations | p. 220 |
| Operational Considerations | p. 222 |
| Audit Trail | p. 225 |
| The Archive Access Component | p. 229 |
| Direct Programming Access | p. 229 |
| Access Through Generic Query and Search Tools | p. 231 |
| Access Through Report Generators and BI Tools | p. 231 |
| Selective Data UNLOAD | p. 232 |
| Accessing Original Data | p. 234 |
| Metadata Services | p. 236 |
| Other Access Considerations | p. 236 |
| Administration of the Database Archive | |
| Ongoing Auditing and Testing | p. 243 |
| Responsibility for Ongoing Auditing and Testing | p. 244 |
| Auditing Activities | p. 244 |
| Testing Activities | p. 248 |
| Frequency of Audits and Tests | p. 250 |
| Managing the Archive Over Time | p. 251 |
| Managing the Archive Database | p. 251 |
| Managing the Archive Repository | p. 253 |
| Using Hosted Solutions | p. 255 |
| Managing Archive Users | p. 256 |
| Nonoperational Sources of Data | p. 261 |
| Retired Applications | p. 261 |
| Data from Mergers and Acquisitions | p. 263 |
| e-Discovery Applications | p. 264 |
| Business Intelligence Data | p. 266 |
| Logs, Audit Trails, and Other Miscellaneous Stuff | p. 267 |
| Final Thoughts | p. 269 |
| Generic Archiving Checklist | p. 271 |
| Goals of a Database Archiving System | p. 275 |
| Job Description of a Database Archive Analyst | p. 277 |
| Glossary | p. 279 |
| References | p. 283 |
| Index | p. 285 |
| Table of Contents provided by Ingram. All Rights Reserved. |
