文章基本信息

标题：Cleansing and Migrating Data
作者：Regina Kwon
期刊名称：Baseline
印刷版ISSN：1541-3004
出版年度：2002
卷号：September 2002
出版社：Ziff Davis Enterprise Inc.

Cleansing and Migrating Data

Regina Kwon

This chart and timeline show the total costs of cleansing multiple databases and migrating the information to a data warehouse. The example is based on a manufacturer that is reengineering its business processes and must upgrade almost all of its systems. Baseline's hypothetical firm has $550 million in annual revenue, 3,000 employees and 2.25 million records. The company has divided its project into three rounds that target six databases each. Tasks include assessing data for cleanliness and completeness; mapping fields to the target warehouse; and both programmatic and manual data manipulation. Project planners may regard these tasks and costs as representative of projects of this size and scope, but should tailor assumptions to meet their own requirements. Put together a project plan to cleanse and migrate your databases (Zipped MS Project 98) Calculate your hardware and software costs (Excel 2000)