Database archiving: how to keep lots of data for a very long time
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Amsterdam [u.a.]
Elsevier [u.a.]
2009
|
| Schriftenreihe: | The MK/OMG press
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | Literaturverz. S. 283 - 284 |
| Beschreibung: | XVIII, 291 S. graph. Darst. 24cm |
| ISBN: | 9780123747204 0123747201 |
Internformat
MARC
| LEADER | 00000nam a22000002c 4500 | ||
|---|---|---|---|
| 001 | BV036801094 | ||
| 003 | DE-604 | ||
| 005 | 20110113 | ||
| 007 | t | ||
| 008 | 101126s2009 d||| |||| 00||| eng d | ||
| 020 | |a 9780123747204 |9 978-0-12-374720-4 | ||
| 020 | |a 0123747201 |9 0-12-374720-1 | ||
| 035 | |a (OCoLC)884080808 | ||
| 035 | |a (DE-599)BSZ290856442 | ||
| 040 | |a DE-604 |b ger | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-525 | ||
| 082 | 0 | |a 005.74 |2 22 | |
| 084 | |a ST 270 |0 (DE-625)143638: |2 rvk | ||
| 084 | |a ST 274 |0 (DE-625)143641: |2 rvk | ||
| 100 | 1 | |a Olson, Jack |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Database archiving |b how to keep lots of data for a very long time |c Jack E. Olson |
| 264 | 1 | |a Amsterdam [u.a.] |b Elsevier [u.a.] |c 2009 | |
| 300 | |a XVIII, 291 S. |b graph. Darst. |c 24cm | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 0 | |a The MK/OMG press | |
| 500 | |a Literaturverz. S. 283 - 284 | ||
| 650 | 4 | |a Digital preservation | |
| 650 | 4 | |a Databases | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020717285&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-020717285 | ||
Datensatz im Suchindex
| _version_ | 1804143493052891137 |
|---|---|
| adam_text | Titel: Database archiving
Autor: Olson, Jack
Jahr: 2009
Contents
Preface xiii
Acknowledgments xvii
PART 1 Archiving Basics
CHAPTER 1 Database Archiving Overview 3
1.1 A Definition of Database Archiving 4
1.2 Forms of Data Archiving 6
1.3 The Data Lifeline 12
1.4 Types of Data Objects 15
1.5 Data Retention Requirements Versus Data Archives 16
1.6 The Database Archives and Other Database Types 19
CHAPTER 2 The Business Case for Database Archiving 21
2.1 Why Database Archiving Is a Problem Today 21
2.2 Implications of Not Keeping Data 25
2.3 Data Volume Issues 27
2.4 Change Management 30
2.5 Current Database Archiving Practices 31
CHAPTER 3 Generic Archiving Methodology 33
3.1 The Methodology 33
3.2 Define Motivation for Archiving 35
3.3 Identify Objects to Archive 39
3.4 Determine When to Put Objects in the Archive 42
3.5 Determine How Long to Keep Objects in the Archive 44
3.6 Determine What to Do with Discarded Objects 47
3.7 Determine Who Needs Access to Archives and How 47
3.8 Determine the Form of Archive Objects 48
3.9 Determine Where the Archive Will Be Kept 50
3.10 Determine Operational Processes Needed 57
3.11 Determine Necessary Administrative Processes 59
3.12 Determine Required Change Processes 59
CHAPTER 4 Components of a Database Archiving System 63
4.1 The Database Archiving Organization 63
4.2 Archive Application Data Gathering 64
4.3 Archive Application Design 65
vii
4.4 Archive Data Extraction 65
4.5 Archive Data Management 66
4.6 Archive Access 66
4.7 Archive Administration 67
PART 2 Establishing a Database
Archiving Project_____________________________
CHAPTER 5 Origins of a Database Archiving Application 71
5.1 Problems That Lead to Database Archiving Solutions 72
5.2 Recognizing Problems 73
5.3 Assignment of Problems for Initial Study 75
5.4 Initial Problem Study Components 75
5.5 Determining the Basic Strategy for the
Archiving Application 78
5.6 The Application Strategy Chart 83
CHAPTER 6 Resources Needed 85
6.1 People 85
6.2 Authority 87
6.3 Education 88
6.4 Repository 88
6.5 Archive Server 89
6.6 Software Tools 89
6.7 Disk Storage 90
CHAPTER 7 Locating Data 93
7.1 Inventorying Data 93
7.2 Picking the Archivist s Data 99
7.3 Documenting Data Sources 100
CHAPTER 8 Locating Metadata 103
8.1 Metadata Definitions 103
8.2 Where to Find Metadata 109
8.3 Selecting a Version of the Metadata 113
8.4 Classifying Data 114
8.5 Documenting Metadata 117
8.6 Keeping Up with Changes 118
CHAPTER 9 Data and Metadata Validation 121
9.1 Matching Data to Metadata 121
9.2 Assessing Data Quality 123
9.3 Assessing Metadata Quality 124
9.4 Validating Data Classification 125
9.5 Documenting Validation Activities 125
9.6 Repeating Validation Activities 126
PART 3 Designing Database Archiving
Applications_________________________________
CHAPTER 10 Designing for Archive Independence 129
10.1 Independence from Application Programs 129
10.2 Independence from DBMS 132
10.3 Independence from Systems 133
10.4 Independence from Data Formats 133
CHAPTER 11 Modeling Archive Data 137
11.1 The Source Data Model 137
11.2 The Target Data Model 142
11.3 Model Representations 147
CHAPTER 12 Setting Archive Policies 149
12.1 Extract Policies 149
12.2 Archive Storage Policies 154
12.3 Archive Discard Policies 157
12.4 Validation and Approval 159
CHAPTER 13 Changes to Data Structures and Policies 161
13.1 Archiving System Strategies for Handling
Metadata Changes 161
13.2 Metadata Change Categories 163
13.3 Changes to the Archive Data Model 170
13.4 Managing the Metadata Change Process 171
13.5 Changes to Archive Policies 172
13.6 Maintaining an Audit Trail of Changes 176
PART 4 Database Archiving Application
Software____________________________________
CHAPTER 14 The Archive Data Store 181
14.1 Archive Database Choices 182
14.2 Important Features 185
14.3 False Features 193
14.4 How Choices Stack Up 195
CHAPTER 15 The Archive Data Extraction Component 197
15.1 The Archive Extractor Model 198
15.2 Extractor Implementation Approaches 200
15.3 Execution Options 203
15.4 Integrity Considerations 205
15.5 Other Considerations 209
CHAPTER 16 The Archive Discard Component 215
16.1 Data Structure Considerations 215
16.2 Implementation Form 219
16.3 Integrity Considerations 220
16.4 Operational Considerations 222
16.5 Audit Trail 225
CHAPTER 17 The Archive Access Component 229
17.1 Direct Programming Access 229
17.2 Access Through Generic Query and Search Tools 231
17.3 Access Through Report Generators and BI Tools 231
17.4 Selective Data UNLOAD 232
17.5 Accessing Original Data 234
17.6 Metadata Services 236
17.7 Other Access Considerations 236
PART 5 Administration of the Database
Archive___________________________________
CHAPTER 18 Ongoing Auditing and Testing 243
18.1 Responsibility for Ongoing Auditing and Testing 244
18.2 Auditing Activities 244
18.3 Testing Activities 248
18.4 Frequency of Audits and Tests 250
CHAPTER 19 Managing the Archive Over Time 251
19.1 Managing the Archive Database 251
19.2 Managing the Archive Repository 253
19.3 Using Hosted Solutions 255
19.4 Managing Archive Users 256
CHAPTER 20 Nonoperational Sources of Data 261
20.1 Retired Applications 261
20.2 Data from Mergers and Acquisitions 263
20.3 e-Discovery Applications 264
20.4 Business Intelligence Data 266
20.5 Logs, Audit Trails, and Other Miscellaneous Stuff 267
Final Thoughts 269
Appendix A Generic Archiving Checklist 271
Appendix B Goals of a Database Archiving System 275
Appendix C Job Description of a Database Archive Analyst 277
Glossary 279
References 283
Index 285
|
| any_adam_object | 1 |
| author | Olson, Jack |
| author_facet | Olson, Jack |
| author_role | aut |
| author_sort | Olson, Jack |
| author_variant | j o jo |
| building | Verbundindex |
| bvnumber | BV036801094 |
| classification_rvk | ST 270 ST 274 |
| ctrlnum | (OCoLC)884080808 (DE-599)BSZ290856442 |
| dewey-full | 005.74 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.74 |
| dewey-search | 005.74 |
| dewey-sort | 15.74 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01295nam a22003612c 4500</leader><controlfield tag="001">BV036801094</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20110113 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">101126s2009 d||| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780123747204</subfield><subfield code="9">978-0-12-374720-4</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0123747201</subfield><subfield code="9">0-12-374720-1</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)884080808</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BSZ290856442</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-525</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.74</subfield><subfield code="2">22</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 270</subfield><subfield code="0">(DE-625)143638:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 274</subfield><subfield code="0">(DE-625)143641:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Olson, Jack</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Database archiving</subfield><subfield code="b">how to keep lots of data for a very long time</subfield><subfield code="c">Jack E. Olson</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Amsterdam [u.a.]</subfield><subfield code="b">Elsevier [u.a.]</subfield><subfield code="c">2009</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XVIII, 291 S.</subfield><subfield code="b">graph. Darst.</subfield><subfield code="c">24cm</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">The MK/OMG press</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Literaturverz. S. 283 - 284</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Digital preservation</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Databases</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020717285&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-020717285</subfield></datafield></record></collection> |
| id | DE-604.BV036801094 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T22:48:32Z |
| institution | BVB |
| isbn | 9780123747204 0123747201 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-020717285 |
| oclc_num | 884080808 |
| open_access_boolean | |
| owner | DE-525 |
| owner_facet | DE-525 |
| physical | XVIII, 291 S. graph. Darst. 24cm |
| publishDate | 2009 |
| publishDateSearch | 2009 |
| publishDateSort | 2009 |
| publisher | Elsevier [u.a.] |
| record_format | marc |
| series2 | The MK/OMG press |
| spelling | Olson, Jack Verfasser aut Database archiving how to keep lots of data for a very long time Jack E. Olson Amsterdam [u.a.] Elsevier [u.a.] 2009 XVIII, 291 S. graph. Darst. 24cm txt rdacontent n rdamedia nc rdacarrier The MK/OMG press Literaturverz. S. 283 - 284 Digital preservation Databases HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020717285&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Olson, Jack Database archiving how to keep lots of data for a very long time Digital preservation Databases |
| title | Database archiving how to keep lots of data for a very long time |
| title_auth | Database archiving how to keep lots of data for a very long time |
| title_exact_search | Database archiving how to keep lots of data for a very long time |
| title_full | Database archiving how to keep lots of data for a very long time Jack E. Olson |
| title_fullStr | Database archiving how to keep lots of data for a very long time Jack E. Olson |
| title_full_unstemmed | Database archiving how to keep lots of data for a very long time Jack E. Olson |
| title_short | Database archiving |
| title_sort | database archiving how to keep lots of data for a very long time |
| title_sub | how to keep lots of data for a very long time |
| topic | Digital preservation Databases |
| topic_facet | Digital preservation Databases |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020717285&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT olsonjack databasearchivinghowtokeeplotsofdataforaverylongtime |