Home 
Resources CM Yellow Pages Articles and Whitepapers Archiving Data to Increase Data Warehouse Performance
Resources CM Yellow Pages Articles and Whitepapers Archiving Data to Increase Data Warehouse Performance
Archiving Data to Increase Data Warehouse Performance
Address
Joe Short jmshort2@hotmail.com
Customers turn to data archiving to address data warehouse performance, availability woes
by Stephen Swoyer
When organizations are concerned about the size and performance of their data warehouses, they often turn to data-quality or data-profiling tools to help solve the problem. Thanks to a technology that got its start in relational database environments, these customers have another option as well. Data archiving describes the process of moving aged or infrequently accessed information out of data warehouse and into near-line or off-line storage. Logical links remain, so as far as the data warehouse is concerned, nothing has changed. But in many cases, the size of a data warehouse can be dramatically compacted in this fashion. Advocates say this results in improved data warehouse performance and—paradoxically—better availability.
When organizations are concerned about the size and performance of their data warehouses, they often turn to data-quality or data-profiling tools to help solve the problem. Thanks to a technology that got its start in relational database environments, these customers have another option as well. Data archiving describes the process of moving aged or infrequently accessed information out of data warehouse and into near-line or off-line storage. Logical links remain, so as far as the data warehouse is concerned, nothing has changed. But in many cases, the size of a data warehouse can be dramatically compacted in this fashion. Advocates say this results in improved data warehouse performance and—paradoxically—better availability.
Reviews (0)
Be the first to review this listing!