Hot Spots: Database archiving to the rescue


This article can also be found in the Premium Editorial Download "Storage magazine: Surprise winner: BlueArc earns top NAS quality award honors."

Download it now to read this article plus other related content.

This task is very complicated as organizations create multiple copies of nonproduction data for development purposes. Tracking the copies becomes unwieldy, especially if engineering resources are geographically separated from product teams or if the work is outsourced to contractors. While database admins make copies to test new application upgrades or features, the downstream risk may manifest itself in the theft of a laptop that has a copy of the information because of the lack of processes and control over the extra data sets.

The trend to outsource application and database development, coupled with the retention of more information to meet record-retention regulations such as HIPAA, exacerbates the security risk. There are also significant costs associated with constantly copying data. More storage is required to keep the information and all copies of a database are typically backed up nightly. Storage and tape costs can get out of hand if there are an excessive number of database copies to be kept and protected.

The benefits of database archiving
One collaborative opportunity for the storage and database groups is database archiving, which can manage and store database information more efficiently and securely. Database archiving products can create a subset of a database; subsetting is used to truncate, insert or delete data from the original database. By creating a smaller database, organizations can reduce storage capacity while maintaining

Requires Free Membership to View

enough data to complete application development and testing.

This was first published in June 2007

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: