Home > Ask the Storage Technology Experts > Questions & Answers
Ask The Storage Expert: Questions & Answers
EMAIL THIS

Taking stock of data archiving and retrieval practices

Brett Cooper EXPERT RESPONSE FROM: Brett Cooper

Pose a Question
Other Storage Categories
Meet all Storage Experts
Become an Expert for this site
>
QUESTION POSED ON: 05 January 2003
We're trying to understand the best practices for data archiving and data retrieval.

1. We have to have an archive infrastructure that is hierarchical (business lines up to parent co. up to corp.)

2. We have to keep all transactional sales data for royalty reporting and licensee reporting.

3. We have to keep lots of financial data.

4. We have a diverse DB infrastructure (some with AS/400, Oracle, SAP, SQL, and such).

Any ideas where to get started?

>
EXPERT RESPONSE
I believe the most important thing to do is to take stock of the processes and transactions that you have in place and then look at a specific process for re-engineering.

What happens in most cases is that many IT organizations get ahead of themselves and try to re-engineer the large processes without taking a smaller approach and focusing on a best practice smaller process as a test. The goal of trying a smaller project out is to mitigate risk in a new process and find out what process re-engineering the group can handle before trying to tackle larger, more noticeable. You will need to look at the goals upfront and understand what the improvements you want to make are and put that into a quantifiable measurement.

For example, the company requires a restore in 24 hours. How often does the IT organization make this requirement, 50% of the time, 60% of the time? Then when you migrate to a new methodology does the new methodology increate the mean time to recovery or decrease it? You now have a stated goal up front. Look at the stated goals in terms of cost, complexity, performance and time. Each of these variables can determine the effectiveness of the overall solution.

Also, involve your end-customers in the re-engineering process since they may see their needs differently then the IT organization and at the end of the process the end-customer is the one who will judge if the solution is effective and flexible enough to meet their needs.

One thing to look at is adapting the tape arrays with a front-side disk cache. In this way one can consolidate the current tape environment into an archiving infrastructure and focus the disk-based backup technologies on the day-to-day backup operations, saving archival for a weekly or monthly activity (all depending on your requirements; don't forget about the federal government requirements for off sites). The nice thing about disk-based backup is that it adapts to the current environment without causing any major unplanned downtime as many of the leading disk-based backup applications treat disk-based backup devices as any other logical storage device. You may want to work with your storage provider of choice to understand the specific trade-offs in your environment.

Brett

Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our discussion forums.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

TechTarget Storage Media
Storage Magazine View this month\\'s issue and subscribe today.
Storage Decisions Apply online for free conference admission.
SearchStorage.com
HomeNewsMagazineTopicsLearningWebcastsWhite PapersBlogsEventsAbout Us

About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2000 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts