Skip to main content
SpringerLink
Log in

Data Warehouse Design for E-Commerce Environments

  • Conference paper
Advances in Conceptual Modeling (ER 1999)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 1727))

Included in the following conference series:

Abstract

Data warehousing and electronic commerce are two of the most rapidly expanding fields in recent information technologies. In this paper, we discuss the design of data warehouses for e-commerce environments. We discuss requirement analysis, logical design, and aggregation in e-commerce environments. We have collected an extensive set of interesting OLAP queries for e-commerce environments, and classified them into categories. Based on these OLAP queries, we illustrate our design with data warehouse bus architecture, dimension table structures, a base star schema, and an aggregation star schema. We finally present various physical design considerations for implementing the dimensional models. We believe that our collection of OLAP queries and dimensional models would be very useful in developing any real-world data warehouses in e-commerce environments.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Anahory, S. and Murray, D., Data Warehousing in the Real World, Addison Wesley, 1997.

    Google Scholar 

  2. Adamson, C. and Venerable, M., Data Warehouse Design Solutions, John Wiley, 1998.

    Google Scholar 

  3. Axel, M. and Song, I.-Y., “Data Warehouse Design for Pharmaceutical Drug Discovery Research,” Proc. of 8th International Conference and Workshop on Database and Expert Systems Applications (DEXA97), September 1–5, 1997, Toulouse, France, pp. 644–650.

    Google Scholar 

  4. Buchner, A. and Mulvenna, M. (1998). Discovering Internet Market Intelligence Through Online Analytical Web Usage Mining. SIGMOD Record, Vol. 27, No.4, December 1998, pp. 54–61.

    Article  Google Scholar 

  5. Bello, R.G., Dias, K., Downing, A., Feenan, J., and others (1998). Materialized Views in Oracle, Proc. of the 24th VLDB Conf., New York, 1998, pp. 659–664.

    Google Scholar 

  6. Dinter, B., Sapia, C, Hofling, G., and Blaschka, M., The OLAP Market: State of the Art and Research Issues, Proc. of Int’l Workshop on Data Warehousing and OLAP, Washington, D.C., 1998, pp. 22–27.

    Google Scholar 

  7. Forrester Research Inc. Home page at http://www.forrester.com/

  8. Golfarelli, M. and Rizzi, S., A Methodological Framework for Data Warehouse Design, Proc. of Int’l Workshop on Data Warehousing and OLAP, Washington, D.C., 1998, pp. 3–9.

    Google Scholar 

  9. International Data Corp. Home page at http://www.idc.com/

  10. Kimball, R. (1996). The Data Warehouse Toolkit. New York: John Wiley & Sons, Inc.

    Google Scholar 

  11. Kimball, R., A Dimensional Manifesto, DBMS, August 1997, pp. 58–70.

    Google Scholar 

  12. Kimball, R. (1999). “Clicking with Your Customer,” Intelligent Enterprise, Vol.2, No.1, pp. 70–74.

    Google Scholar 

  13. Kimball, R., Reeves, L., Ross, M., & Thornthwaite, W. (1998). The Data Warehouse Lifecycle Toolkit. New York: John Wiley & Sons, Inc.

    Google Scholar 

  14. Krippendorf, M. and Song, I.-Y, “Translation of Star Schema into Entity-Relationship Diagrams,” Proc. of 8th International Conference and Workshop on Database and Expert Systems Applications (DEXA97), September 1–5, 1997, Toulouse, France, pp. 390–395.

    Google Scholar 

  15. Lohse, G.L. and Spiller, P. (1998). “Electronic Shopping,” Communications of the ACM, Vol.41, No.7, pp. 81–88.

    Article  Google Scholar 

  16. Maier, D. and Cannon, C., Building a Better Data Warehouse, Prentice Hall, 1998.

    Google Scholar 

  17. Sapia, C, Blaschka, M., Hofling, G., and Dinter, B., “Extending the E/R Model for the Multidimensional Paradigm,” Advances in Database Technologies (ER’98 Workshop Proceedings), Springer-Verlag, pp. 105–116.

    Google Scholar 

  18. Song, I.-Y., and LeVan-Schultz, K., “Data Warehouse Design for E-Commerce Environments,” Technical Report, College of Information Science and Technology, Drexel University, Philadelphia, Pennsylvania, 1999.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. College of Information Science and Technology, Drexel University, Philadelphia, PA, 19104

    Il-Yeol Song & Kelly LeVan-Shultz

Authors
  1. Il-Yeol Song
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Kelly LeVan-Shultz
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Department of Computer Science, Louisiana State University, 298 Coates Hall, Baton Rouge, LA, 70803, USA

    Peter P. Chen

  2. Department of Computer Science, Brigham Young University, Provo, UT, 84602, USA

    David W. Embley

  3. INSA-LISI, 20 Avenue Albert Einstein, F-69621, Villeurbanne Cedex, France

    Jacques Kouloumdjian

  4. Marriott School of Management, Brigham Young University, P.O. Box 23087, Provo, UT, 84602-3087, USA

    Stephen W. Liddle

  5. School of Computer and Information Science, University of South Australia, Mawson Lakes, 5095, South Australia

    John F. Roddick

Rights and permissions

Reprints and permissions

Copyright information

© 1999 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Song, IY., LeVan-Shultz, K. (1999). Data Warehouse Design for E-Commerce Environments. In: Chen, P.P., Embley, D.W., Kouloumdjian, J., Liddle, S.W., Roddick, J.F. (eds) Advances in Conceptual Modeling. ER 1999. Lecture Notes in Computer Science, vol 1727. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-48054-4_30

Download citation

  • DOI: https://doi.org/10.1007/3-540-48054-4_30

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-66653-0

  • Online ISBN: 978-3-540-48054-9

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation