A dimensional modeling manifesto
DBMS - Special issue on data warehousing
Communications of the ACM
Data warehouse design solutions
Data warehouse design solutions
A methodological framework for data warehouse design
Proceedings of the 1st ACM international workshop on Data warehousing and OLAP
The OLAP market: state of the art and research issues
Proceedings of the 1st ACM international workshop on Data warehousing and OLAP
Data Warehousing in the Real World: A Practical Guide for Building Decision Support Systems
Data Warehousing in the Real World: A Practical Guide for Building Decision Support Systems
The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom
VLDB '98 Proceedings of the 24rd International Conference on Very Large Data Bases
Extending the E/R Model for the Multidimensional Paradigm
ER '98 Proceedings of the Workshops on Data Warehousing and Data Mining: Advances in Database Technologies
The Translation of Star Schema into Entity-Relationship Diagrams
DEXA '97 Proceedings of the 8th International Workshop on Database and Expert Systems Applications
Data Warehouse Design for Pharmaceutical Drug Discovery Research
DEXA '97 Proceedings of the 8th International Workshop on Database and Expert Systems Applications
The Data Warehouse Lifecycle Toolkit
The Data Warehouse Lifecycle Toolkit
| Hi-index | 0.00 |
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.