Old And New Systems Of The Amazon Data Migration

For the future development, Joyo-Amazon will provide excellent service, more enriched types of products and goods, thus improve the world-class leader in B2C platform. We want to ensure that consumers will be more likely to enjoy shopping in our web site.Joyo-Amazon superior extension of the Suzhou company is still using Joyo operation and management system, the old system, foreign companies operating processes and advanced mode of operation is very different, leading to the old system to the operation of statistical data and data analysis a result, the Suzhou company is correct, the introduction of effective management of foreign companies experience success almost no role. Therefore, companies need to have a set of Suzhou and similar foreign companies, while at the same time operating system suitable for China's national conditions, so that the production company in Suzhou, management data can be comparable and foreign companies, which can be applied to correct the management of foreign companies experience.From the original opening to the old system was replaced by the new system, in which they are used often during the accumulation of a large number of valuable historical data, historical data, many of which are the smooth opening of the new system required. In addition, the historical data analysis is also carried out an important basis for decision-making. Data migration needs historical data cleansing, transformation, and loading system to the new process. Data migration is mainly applied to an old system to switch to another set of the new system, one or more sets of the old system to switch to a new system with the need for the old system historical data conversion to the new system in the case.Firstly, the present dissertation reviews some theories and approaches of data transformation. Some basic concepts are also presented. The analysis of request is detailed. The principles and the executability of this project are documented. Finally, the resolution of our project is decided. Java language is employed in our study. XML document is used as destination and source when data set is transferring. Java and XML are both isolation of platform. The study use XML to describe the request of ETL procedure, including extraction, transformation and loading. After these elements are confirmed, the dissertation shows how XML document is coded and how it will be treated as the basis for the following development. In the last chapter, the dissertation shows the sequence graphics of our system, UML description and Graphic User Interface. Since data cleaning and data transformation are key modules. The parts of their details are listed too.Our system has successfully compled data transformation from Joyo system to Joyo-Amazon system. Java language and XML schema are both isolation of operation system. When coding, we greatly apply the characteristics of OOP in Java. Besides, we have left a lot interface for other functions. Thus, our system are extensible and easily to be extended to other operation system and resolution project.