Data Warehouse Design for E-Commerce Environments
ER '99 Proceedings of the Workshops on Evolution and Change in Data Management, Reverse Engineering in Information Systems, and the World Wide Web and Conceptual Modeling
Ternary relationships: semantic requirements and logically correct alternatives
Advanced topics in database research vol. 1
A grain preservation translation algorithm: From ER diagram to multidimensional model
Information Sciences: an International Journal
An efficient and grain preservation mapping algorithm: from ER diagram to multidimensional model
ISSADS'05 Proceedings of the 5th international conference on Advanced Distributed Systems
| Hi-index | 0.00 |
The star schema is widely accepted as an appropriate underlying table structure for data warehouses, but enterprise data is frequently defined in terms of entity-relationship diagrams. A key issue for data warehouse designers is how to move from legacy OLTP designs into the star schema. In this paper, we examine the semantics and constraints of the star schema in some of its different forms and translate them into analogous ERDs. These different forms include the simple, multi-star, and snowflaked star schema, and several variations on facts and dimensions, such as multiple fact and outboard dimension tables. We outline transformation rules for each case and show a series of examples. These heuristics will be useful in mapping and maintaining consistency between OLTP databases and data warehouses.