The Development of an XML-Based Data Warehouse System
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.
KeywordsData Warehouse Data Cube Fact Table Priority User Star Schema
Unable to display preview. Download preview PDF.
- 1.Gupta, A., et. al, “Aggregate-Query Processing in Data Warehousing Environments”, Proceedings of the 21st International VLDB Conference, (1995)Google Scholar
- 2.Chen, L., and Frolick, M., “Web-Based Data Warehousing: Fundamentals, Challenges, and Solutions”, Information Systems Management, (2000)Google Scholar
- 3.Ceponkus, A., and Hoodbhoy, F., Applied XML: A Toolkit for Programmers, Wiley (pub.), (2000)Google Scholar
- 4.Chaudhuri, S., and Dayal, U., “An Overview of Data Warehousing and OLAP Technology”, ACM SIGMOD Record, Vol. 26, No. 1, 1997.Google Scholar
- 5.Han, J., and Nishio, S., “Generalization-based data mining in OODB using an object cube model”, Data and Knowledge Engineering, vol. 25 1998.Google Scholar
- 6.Stamper, D., Business Data Communications, The Benjamin/Cummings Publishing Company, Inc., 1991.Google Scholar
- 7.Huang, S., and Lin, Y., “Actual Application Examples for Building Data Warehouse”, The Fifth Seminar on Information Research Management, 1999.Google Scholar
- 9.Moeller, R., Distributed Data Warehousing Using Web Technology, AMACOM, 2001.Google Scholar
- 10.Roy, J. and Ramanujun, A., “Building an XML application: key management issues”, Proceedings of XML Europe 2000 Conference, 2000.Google Scholar