Database Archiving : How to Keep Lots of Data for a Very Long Time - Jack E. Olson

Instant online reading.
Don't wait for delivery!
Go digital and save!

Database Archiving

How to Keep Lots of Data for a Very Long Time

By: Jack E. Olson

Write A Review

Paperback | 11 November 2008

At a Glance

Paperback
312 Pages

Dimensions(cm)
23.5 x 19.68 x 1.91

Paperback

RRP $116.95

$110.75

or 4 interest-free payments of $27.69 with

Ships in 5 to 7 business days

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 how to solve these challenges without compromising the operation of current systems. It shows how to do all this as part of a standardized archival process that requires modest contributions from team members throughout an organization, rather than the superhuman effort of a dedicated team.

* Exhaustively considers the diverse set of issues-legal, technological, and financial-affecting organizations faced with major database archiving requirements.

* Shows how to design and implement a database archival process that is integral to existing procedures and systems.

* Explores the role of players at every level of the organization-in terms of the skills they need and the contributions they can make.

* Presents its ideas from a vendor-neutral perspective that can benefit any organization, regardless of its current technological investments.

* Provides detailed information on building the business case for all types of archiving projects

Industry Reviews

"This is a thorough discourse on data archiving--what it is, how to approach it, and how to execute on it." --John Schley, Data Architect at Principal Financial Group

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $79.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Library & Info Sciences Business & Management Business Mathematics & Systems Computing & I.T.Databases Data Warehousing

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.

Database Archiving

How to Keep Lots of Data for a Very Long Time

At a Glance

Paperback

Industry Reviews

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Computing & I.T.

How a Game Lives

The Art of Death Stranding 2

On the Beach

Microsoft Power BI For Dummies

For Dummies (Computer/Tech)

Pokemon Colour & Design

Release Your Inner Artist with The Original 151 Pokemon

The Amazing Generation

The Bitcoin Standard

The Decentralized Alternative to Central Banking

Python Crash Course

3rd Edition - A Hands-On, Project-Based Introduction to Programming

SPSS Statistics

5th Edition - A Practical Guide

Don't Burn Anyone at the Stake Today

(and other lessons from history about living through an information crisis)

Designing Data-Intensive Applications

Big Ideas Behind Reliable, Scalable, and Maintainable Systems

The AI Con

How To Fight Big Tech's Hype and Create the Future We Want

If Anyone Builds It, Everyone Dies

The Case Against Superintelligent AI

Nexus

A Brief History of Information Networks from the Stone Age to AI

How to Win At Chess

The Ultimate Guide for Beginners and Beyond

Certified Kubernetes Administrator (CKA) Study Guide

In-Depth Guidance and Practice

This Is for Everyone

Atlas of the Invisible

Maps & Graphics That Will Change How You See the World

Arcane 12-Month Undated Planner

Gaming

Creative Machines

AI, Art & Us

Grey Area

Dark Web Data Collection and the Future of OSINT

Machine Learning For Dummies

For Dummies (Computer/Tech)

iPhone For Dummies, 2026 Edition

iPhone for Dummies

AI in Early Education

Integrating Artificial Intelligence for Inclusive and Effective Learning

Beginner's Step-by-Step Coding Course

Learn Computer Programming the Easy Way

This product is categorised by