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 $128.95

$120.99

or 4 interest-free payments of $30.25 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 $89.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 Business & Management Business Mathematics & Systems Computing & I.T.Databases Data Warehousing Information Retrieval Library & Info Sciences Library & Information Services Computer Science

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.

The God We Made

The Threat and Promise of Artificial Intelligence; Quarterly Essay 102

The New Age of Sexism

How the AI Revolution is Reinventing Misogyny

Final Fantasy VII Rebirth

Material Ultimania

Screensaver

A Judgement-Free Guide to Your Child's First Smartphone

Careless People

A story of where I used to work

The Amazing Generation

Open to Work

How to Get Ahead in the Age of AI

If Anyone Builds It, Everyone Dies

The Case Against Superintelligent AI

Doppelganger

A Trip Into the Mirror World

How to Win At Chess

The Ultimate Guide for Beginners and Beyond

The Unofficial Sims Cookbook

From Baked Alaska to Silly Gummy Bear Pancakes, 85+ Recipes to Satisfy the Hunger Need

Famesick

How We Learn

The New Science of Education and the Brain

The Explosive Child: Sixth Edition

A New Approach for Understanding and Parenting Easily Frustrated, Chronically Inflexible Children

Super Nintendo

How One Japanese Company Helped the World Have Fun

Python Crash Course

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

Final Fantasy IX Picture Book

Vivi and Grandpa's Memories for the Sky

The Infinity Machine

Demis Hassabis, DeepMind and the Quest for Superintelligence

Cisco Networking All-in-One For Dummies

The E-Myth Revisited

Why Most Small Businesses Don't Work and What to Do About It

Microsoft 365 Excel All-in-One For Dummies

Excel for Dummies

The Official Stardew Valley Cookbook

Co-Intelligence

Living and Working with AI

Minecraft - The Complete Handbook Collection

Minecraft

This product is categorised by