|
|

Calculator: Data Warehousing's Big Sleep
By Regina Kwon
2003-08-13
Article Views: 454
Article Rating:    / 0
0803_DormantData.xls
| Rate This Article: |
|
| Add This Article To: |
|
|
Dormant data—information that never has been and never will be accessed—can give a data warehouse a heart attack. Find out whether your systems are at risk. The cost of storage may be falling, but are you reaping the benefits? Probably not, according to Bill Inmon, creator of the data warehouse concept. "We're using storage at a rate that far surpasses the rate at which prices are dropping," he says.
Corporate data warehouses, which collect far more detail than standard databases and retain information historically, account for a significant proportion of storage costs. But the usefulness of a warehouse doesn't necessarily increase as you stuff more data into it. Rather, many data warehouses suffer from an abundance of "dormant data"data that has never been accessed and probably never will be.
Such excess "clogs up the efficiency of data for all users," says Inmon. "If you get enough cholesterol in your bloodstream, you have a heart attack. It's the same with dormant data." Superfluous data can also aggravate the complexity of storage systems, which are becoming increasingly hard to manage.
Besides performance, there's cost to consider. Disk-storage vendors like to advertise falling prices, but "the ratio of disk to nondisk prices has been fairly constant for almost 10 years," says Inmon.
Once you add the complexity of managing live data, the cost of keeping data on disks far outweighs the cost of keeping it on "near line" media, such as DVDs or tapes. Inmon has found that for every dollar a company pays to run a disk-based storage system, it would pay only 13.4 cents for a near-line setup of similar size.
Before you count your chickens, however, you need to know how much dormant data you actually have.
To estimate the size of unused information within your data warehouse, click on the Tool icon above and download the interactive calculator.
|
|
 |
 |
 |
| FEATURED CONTENT
|

IT Failing at Being 'Green'
Lack of resources is hindering control of data center energy consumption, a study finds.
How to Plan for Disaster Recovery
Disasters happen to businesses of any size. They can take a variety of forms—ranging from fire and flood to janitorial accidents. Consultant Dave Sobel, CEO of Evolve Technologies, explains how you should plan for what is probably inevitable.
HP Engineers Claim 'Memristor' Breakthrough
HP Labs engineers claim they have discovered a long-sought circuit element that could lead to new ways of creating memory.
|
|
Sponsored by HP | |
|
| DOWNLOADABLE ROI CALCULATORS & TOOLS FROM BASELINE |
Calculate Cost and ROI of Spam, VOIP, RFID, Sarbanes-Oxley and more...
Featured Calculators:
See More Tools!
By Category| Planners |Calculators | Quizzes
|
| |
|
 |
 |
 |
 |
|
|