A Web-Based Data Warehouse Planning - A Large-Scale Project Management Information System in Taiwan

Abstract

This chapter describes a data warehouse planning project to develop a large-scale management information system for a Taiwan government agency in managing a nationwide multi-billion science and technology project management and control process. The planning and consulting period lasted through the time period of 1997 and 1998. The outsourcing and implementation tasks are expected to continue through 2000. In this chapter, we present the framework and model of the data warehouses developed by the committee during the planning and consulting stage. Our focus is on the data design and module design for a multi-dimensional database system. The data design aims to provide an integral model for the internal and external data sources. A core view of the multi-dimensional database is developed. The module design attempts to give an analytic model of the field, division, project, and agent performance along the dimension hierarchies. Actual versus budget and actual versus forecast analysis along with the time series analysis and ad hoc analysis are supported in the systems.