successful-data-migration-wp-1555708.pdf

Please download to get full document.

View again

All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Share
Transcript
    An Oracle White Paper October 2011 Successful Data Migration  Successful Data Migration Part 1: The Importance of Data Quality .............................................. 2   Plotting a Smooth Path to Data Migration ...................................... 2   Why Migrate Your Data? ............................................................... 2   Does Data Get the Attention It Deserves? ..................................... 2   Migration Strategies ....................................................................... 3   Part 2: Formulating a Strategy ........................................................... 4   Challenges and Pitfalls of Classic Data Migration .......................... 4   Mapping a Faster Route to the Unknown ....................................... 5   Testing .......................................................................................... 6   Load and Explode .......................................................................... 6   The Risks of Overlooking Data Content ......................................... 6   The People Perspective ................................................................. 7   Part 3: Discovering Your Data ........................................................... 7   Discovering the Missing Links with Profiling and Auditing .............. 7   Redefining Data for Migration ........................................................ 8   Benefits of Data Validation ............................................................ 9   Part 4: Essential Steps to Success .................................................... 9   Phase 1: Planning ......................................................................... 9   Phase 2: Understanding the Data ................................................ 10   Phase 3: Designing and Building ................................................. 11   Phase 4: Executing ...................................................................... 12   Phase 5: Testing.......................................................................... 12   Phase 6: Follow-Up and Maintenance ......................................... 12   Conclusion ...................................................................................... 13    Successful Data Migration 2 Part 1: The Importance of Data Quality Plotting a Smooth Path to Data Migration Businesses spend billions of dollars migrating data between information-intensive applications. Yet up to 75 percent of new systems fail to meet expectations, often because flaws in the migration process result in data that is not adequately validated for the intended task. Because the system itself is seen as the investment, any data migration effort is often viewed as a necessary but unfortunate cost, leading to an oversimplified, underfunded approach. With an understanding of the hidden challenges, managing the migration as part of the investment is much more likely to deliver accurate data that supports the needs of the business and mitigates the risk of delays, budget overruns, and scope reductions that can arise. Why Migrate Your Data? Data migrations generally result from the introduction of a new system. This may involve an application migration or consolidation in which one or more legacy systems are replaced or the deployment of an additional system that will sit alongside the existing applications. Whatever the specific nature of any data migration, the ultimate aim is to improve corporate performance and deliver competitive advantage.  Accurate data is the raw material that maximizes the value of enterprise applications. However, when existing data is migrated to a new target application, it can become apparent that it contains inaccuracies, unknowns, and redundant and duplicate material. And although the data in the source system may be perfectly adequate for its current use, it may be wholly inadequate, in terms of content and structure, for the objectives of the target system.  Without a sufficient understanding of both source and target, transferring data into a more sophisticated application will amplify the negative impact of any incorrect or irrelevant data, perpetuate any hidden legacy problems, and increase exposure to risk. Does Data Get the Attention It Deserves? Data migration is usually part of a larger project deliverable, and typically the majority of business attention is focused on the package selection and configuration rather than on ensuring that the data that populates the new system is fit for the purpose. There are some clear reasons why data migration subprojects tend to be “planned” so cursorily. Choosing the new system is an exciting, strategic business activity that usually entails working with new technologies, suppliers, and opportunities. In short, it is the sexy part of the project. In contrast, data migration planning is seen as a simple matter of shifting data from one bucket to another via a process that is a necessary administrative burden and an extra cost. Thus, planning is often left until too late and the required resources and the difficulty of the migration are frequently underestimated. Migration is regarded as a mundane and thankless task, and in some instances, people know they are migrating themselves out of a job.  Successful Data Migration 3 Migration Strategies Organizations planning a data migration should consider which style of migration is most suitable for their needs. They can choose from several strategies, depending on the project requirements and available processing windows, but there are two principal types of migration: big bang migrations   and trickle migrations  . Big bang migrations involve completing the entire migration in a small, defined processing window. In the case of a systems migration, this involves system downtime while the data is extracted from the source system(s), processed, and loaded to the target, followed by the switching of processing over to the new environment.  This approach can seem attractive, in that it completes the migration in the shortest-possible time, but it carries several risks. Few organizations can live with a core system’s being unavailable for long, so there is intense pressure on the migration and the data verification and sign-off are on the critical path. Businesses adopting this approach should plan at least one dry run of the migration before the live event and also plan a contingency date for the migration in case the first attempt has to be aborted.  The reality is that few organizations ever do this. Big bang migrations are most often planned as a one-off requiring a shutdown over a weekend or a public holiday, meaning that the quality of the migrated data is often compromised. Key Drivers of Data Complexity A combination of trends is accelerating the need to manage data migration activity more effectively as part of a corporate data quality strategy: ã   Corporate growth . Mergers, acquisitions, and restructuring of disparate systems create new data and new datasources. ã   Compliance.  Data must be validated against regulations and standards such as Basel II and Sarbanes-Oxley (SOX). ã   Data volume.  Escalating amounts of data are increasing the burden of data management. ã   Data diversity.  Introduction of data in new formats—such as RFID, SMS, and e-mail— increases complexity. ã   Data decay.  Data is volatile; customer data typically deteriorates at a rate of 10 percent to 25 percent per year. ã   Data denial.  Organizations are often unaware of their data quality issues and lack the expertise or a senior sponsor to champion decisive action. ã   Technical advances.  Proliferation of new data devices, platforms, and operating systems also contributes to complexity. ã   Economic factors.  With pressure on margins, all corporate data must help organizations. compete more effectively
Related Search
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks
SAVE OUR EARTH

We need your sign to support Project to invent "SMART AND CONTROLLABLE REFLECTIVE BALLOONS" to cover the Sun and Save Our Earth.

More details...

Sign Now!

We are very appreciated for your Prompt Action!

x