Advertisement

The Development of an XML-Based Data Warehouse System

  • Shi-Ming Huang
  • Chun-Hao Su
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 2412)

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.

Keywords

Data Warehouse Data Cube Fact Table Priority User Star Schema 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Reference

  1. 1.
    Gupta, A., et. al, “Aggregate-Query Processing in Data Warehousing Environments”, Proceedings of the 21st International VLDB Conference, (1995)Google Scholar
  2. 2.
    Chen, L., and Frolick, M., “Web-Based Data Warehousing: Fundamentals, Challenges, and Solutions”, Information Systems Management, (2000)Google Scholar
  3. 3.
    Ceponkus, A., and Hoodbhoy, F., Applied XML: A Toolkit for Programmers, Wiley (pub.), (2000)Google Scholar
  4. 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. 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. 6.
    Stamper, D., Business Data Communications, The Benjamin/Cummings Publishing Company, Inc., 1991.Google Scholar
  7. 7.
    Huang, S., and Lin, Y., “Actual Application Examples for Building Data Warehouse”, The Fifth Seminar on Information Research Management, 1999.Google Scholar
  8. 8.
    Huang, S., et. al, “Developing an XML Gateway for Business-to-Business Commerce”, Proceedings of The 1st International Conference on Web Information Systems Engineering, Hong Kong, China, Vol. 2, 2000, pp. 67–74.CrossRefGoogle Scholar
  9. 9.
    Moeller, R., Distributed Data Warehousing Using Web Technology, AMACOM, 2001.Google Scholar
  10. 10.
    Roy, J. and Ramanujun, A., “Building an XML application: key management issues”, Proceedings of XML Europe 2000 Conference, 2000.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2002

Authors and Affiliations

  • Shi-Ming Huang
    • 1
  • Chun-Hao Su
    • 1
  1. 1.Department of Information ManagementNational Chung Cheng UniversityMin-HsiungTaiwan, R.O.C.

Personalised recommendations