Legacy Issues in Migrating Data for New Data Warehouse
Journal Title: GRD Journal for Engineering - Year 2016, Vol 1, Issue 9
Abstract
This paper tries to propose a solution for various issues that uncover while migrating the data from old legacy systems to new systems. Business organizations implement new Software Application System to replace the functionalities of their major processes by their old legacy systems from time to time. Data Migration is the procedure of relocating data from one framework then onto the other while changing the capacity, database or application. Complexities arise when there is a try to take the information (data) right from the legacy framework (system) and change or modify it to fit into the new framework (system). Mostly the structure and the data types of the old legacy systems are different in relation to the new system being implemented; the difference is simply not constrained to the table names, field names, properties or sizes. The types of databases are distinct, as also the entity relationships in the new framework may not compatible with the earlier legacy systems. To get the legacy data into its new application format, a certain number of modifications and transformations must take place. These modifications and transformations are known as 'Data Conversion'. During the implementation of new framework, the current structure which is being used by the old legacy system is taken into account and is mapped to the new framework being designed and implemented.
Authors and Affiliations
Sushant S. Sule, Pravin S. Metkewar, Syed Khizer
Keywords
Related Articles
- EP ID EP219797
- DOI -
- Views 90
- Downloads 0
A Study to Detect Urban Changes and its Relationship to Flash Flood in Thiruvanathapuram City
Thiruvanathapuram is the capital city of Kerala state. As the city is completely effected by flood, but within in the local bodies there are few low-lying areas which are susceptible to flash flood. The urban expansion w...
Numerical Study of Natural Ventilation in BIPV Trombe Wall
To reduce energy consumption in buildings, passive solutions have been developed greatly like increasing the insulation of exterior walls. One way to improve the energy efficiency of buildings is to design multi-function...
Electronic Medication System to Assist the Elderly
Not taking prescribed medication on time can have serious health consequences. Anyone who cares for someone with a chronic illness for very long will soon realize there is much to be learned about how to organize medicat...
Finite Element Analysis and Experimentation of Carbon Fibre Chain Drive
Chain drives are most important systems used in industry to carry the products and to transmit the power. But limitation is the chain drive suffers premature elongation due to wear and so that the costs of production wil...
Evaluation of Sediment Transport Function Using Different Fall Velocity Equations
Study of sediment transport in river morphological problems requires proper relation to be established for the estimation of the terminal velocity, also known as fall velocity of particles. A large number of formulas hav...