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