The development of an XML-based data warehouse system

Abstract

Along with the enterprise globalization and Internet popularization, the Internet-based Data Warehouse System (DWS) has gradually replaced the traditional DWS and becomes its mainstream structure. The manager can easily obtain and share the data on the distribution system using the Internet. Through the multiple data source collections, the quality and broad base of DWS can be increased and thus help managers to make more decisive policies. However, utilizing the basic client/server structure of DWS can increase many tolerances and cost based problems. This paper uses the XML to establish the Internet based DWS and utilize the advantage of its flexibility, self-definition, self description and low cost to improve the unavoidable defect of the client/server DWS. We also use pull and push method approaches to determine what information can be shared on the Internet or delivered through e-mail. In this work, we show that the DWS architecture can not only improve the scalability and speed but also enhance the system security. In addition, it can be applied for both traditional client/server DWS and web-based DWS. We present a case study to prove the validity of this system architecture and create a prototype system to show the feasibility of this system architecture.