| Publisher | Oracle | ||
|---|---|---|---|
| Format | HTML | Date added | 01 Jul 2006 |
| Topics | Database Management, Database Applications | ||
| Downloads | 34 | ||
Acme Insurance Company is ready to archive data more than three years old to tape and to delete it from the production database. The company's IT architects have suggested an archive strategy that also uses transportable tablespaces, and the production tables have been carefully partitioned on the transaction date with this specific objective in mind. The plan would be perfect, but there is a problem. As part of other projects, the IT architects are planning incremental changes to the structure of the production tables. The company's lead DBA has been called back from his vacation to find a way to make the archiving strategy work in a world of changing database structures. His solution is to use XML as the format for the archived data.
Did you find this white paper useful?
30 out of 50 users found this white paper useful
Related white papers
Realising the benefits of going green
Cross over to greener communications with improved data accuracy. Many organisations have processes in place to improve the quality of their contact data to address business drivers, such as cost reduction...
Creating a Dynamic Infrastructure through Virtualization
In almost every case,the transformation to a dynamic infrastructure will involve virtualization.Many IT professionals think of virtualization specifically in terms of servers.IBM,however,has a broader perspective,in which virtualization is seen as...
Dynamic Infrastructure Helping Build a Smarter PlanetDelivering Superior Business and IT Services with Agility and Speed
In this smarter world, we need our infrastructure to propel us forward, not hold us back. This infrastructure becomes instrumented, interconnected and intelligent to bring together the business and IT...
IBM Virtualization Services
Virtualization is a powerful technology and can have profound effects on the datacenter; however, it should be viewed as a component of an overall IT strategy that will be able...
MSC Industrial Direct- customer case study
"Following a company merger, MSC Industrial Direct Co. found that duplicate customer records were disrupting the business workflow and causing sales compensation issues. MSC Industrial Direct Co. implemented the Pitney Bowes Business...
Customer Data Quality Platform from Pitney Bowes Business Insight - a Butler Group Technology Audit report
Pitney Bowes Customer Data Quality Platform (CDQP) is a domain-specific customer data quality management system that enables tasks such as integration, cleansing, matching, profiling, monitoring, and enriching the data with...
Data Quality Considerations for a Master Data Management Structure
Companies acquiring companies. Human Resources sharing information with Finance. Businesses spanning multiple countries. What do all of these scenarios have in common? The sharing of data. What is the critical...
