JournalsKart submission@journalskart.com 8882640642, 011-43101010
Register Login
Volume 12 Issue 2 July-December 2021
IITM Journal of Management and IT |Articles

The Role of Data Warehousing in the Infrastructure of E-Commerce

Dr. Akhilesh Saini Dr Akhilesh Saini
Associate Professor (Computer Science), Ch. K.R.Godara Memorial College, Bashir, Tibbi, India
View PDF Volume 12 Issue 2 July-December 2021 10.65301/iitm.2021.12.2.598 ↗
Dr. Akhilesh Saini Dr Akhilesh Saini . (2021). The Role of Data Warehousing in the Infrastructure of E-Commerce. IITM Journal of Management and IT, 12(2), 39-47.
Published by
Article outline
Article info

Abstract

A data warehouse is a repository of data that can be analyzed to gain a better knowledge about the “goings on” in a company. The value of better knowledge can lead to superior decision making. Although this architecture has been around for a long time its use is not wide spread. Many researchers have noted the absence of its penetration in business. So, while on the one hand we find a rapid growth in the e-commerce industry and advances in hardware and software, on the other hand, very few companies seem to know how to use data warehousing technologies to succeed in e-commerce. There are companies that have successfully incorporated a data warehouse and have become pioneers and leaders in e-commerce. This article presents the success of Amazon. com in the business to consumer sector of e-commerce and the success of Wal-Mart as the leader in the business to business sector of e-commerce. Data warehousing and electronic-commerce are two of the most rapidly expanding  elds in recent information technologies. In this paper, we discuss the design of data warehouses for e- commerce environment. We discuss requirement analysis, logical design, and physical design issues in e-commerce environments. We have collected an extensive set of interesting OLAP queries for e-commerce environments, and classi ed 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  nally 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. 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.

Keywords

E-Commerce

References

  1. Bichler, M; Kalagnanam, J; Katirciglu, K; King, A.J. (2002). Application of Flexible Pricing in Business to Business Electronic Commerce. IBM Systems Journal, Armonk. Vol 41, num 2, pp287-302
  2. Business Week (1999). Q & A: Jeff Bezos: Amazon.com. Business Week, num 3631, pp 137-41. The Review Of Business Information Systems Volume 8, Number 3 20
  3. Chan, P. S. & Pollard, D. (2003). Succeeding in the dotcom Economy. Challenges for the Bricks and Mortar Company. International Journal of Management. Vol 20, num 1, pp11-17.
  4. Clemons, E. K., & Weber, B. W. (1994). Segmentation, differentiation, and flexible pricing: Experiences with information technology and segment-tailored strategies. Journal of Management Information Systems, 11(2), 9–29.
  5. Feldman. D. (2002). The Pricing Puzzle. Marketing Research. Vol 14, num 4, pp 14-19.
  6. Golicic, S. L., D. F. Davis, T. M. McCarthy and J. T. Mentzer. (2001). “Bringing Order One Out Of Chaos: Forecasting E-Commerce”. The Journal of Business Forecasting. Spring 2001, pp 11-17.
  7. Hamm, S. & Hoff, R, D. (2000). Using the Net to Catch and keep Customers. Strategic Decision. Vol 16, num 7, pp20-22, June
  8. Harris Interactive. (2002). Bricks and Mortar Mass Retailers Capture Mainstream Shoppers Online. Walmart.com Claims No.1 Spot for Mass Retailers in June 2001. WWW. Harrisinteractivee.com Downloaded 9/9/03.
  9. Johnson. M. (1999). Collaborating Data Modeling: CPFR Implementation Guidelines. Proceedings o f the Annual Conference of the Council of Logistics Management 1999.
  10. Lee, S.J. Siau, K. (2001). A Review of Data Mining Techniques. Industrial Management + Data Systems. Vol 101, num 1, pp 41-48.
  11. Machlis. S. (1998). Amazon.com, Wal-Mart pushes web branding. Computer World, Vol 32, no 32, pp 13.
  12. Mellahi, K & Johnson. M (2000). Does it Pay to be a first mover in e-economy? The Case of Amazon.com. Management Decision. Vol 38, num 7, pp 445-455.
  13. Monroe, B.K; Cox, J.L. (2001). Pricing practices that endanger Profits. Marketing Management, Vol 10, num 3, and pp 42-46.
  14. Mullaney, T. (2000). Walmart.com and Amazon.com –The race Isn’t even close. Business Week Online. December 18, 2000.
  15. Sung, N, H.& Lee, J, K. (2000). Knowledge assisted Dynamic Pricing for Large scale retailers. Decision Support System. Vol 28, pp 347-363.
  16. Shipley, D. & Jobber, D. (2001). Integrative Pricing via the Pricing Wheel. Industrial Marketing Management. Vol. 30, pp 301-314.
  17. Wal-Mart Relies on NCR Data Warehouse to Help Manage its Business. Sss.ncr.com. 2000.
  18. Westerman, P. (2001). Data Warehousing: Using the Wal-Mart Model. San Francisco: Morgan Kaufmann Publishers.
Citation copied to clipboard