A methodological framework for data warehouse design
Proceedings of the 1st ACM international workshop on Data warehousing and OLAP
starER: a conceptual model for data warehouse design
Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Event-entity-relationship modeling in data warehouse environments
Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Proceedings of the eighth international conference on Information and knowledge management
The entity-relationship model—toward a unified view of data
ACM Transactions on Database Systems (TODS) - Special issue: papers from the international conference on very large data bases: September 22–24, 1975, Framingham, MA
Designing data marts for data warehouses
ACM Transactions on Software Engineering and Methodology (TOSEM)
The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom
Building the Data Warehouse,3rd Edition
Building the Data Warehouse,3rd Edition
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
A Logical Approach to Multidimensional Databases
EDBT '98 Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology
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
Conceptual Design of Data Warehouses from E/R Schema
HICSS '98 Proceedings of the Thirty-First Annual Hawaii International Conference on System Sciences-Volume 7 - Volume 7
Data Warehouse Design: A Schema-Transformation Approach
SCCC '02 Proceedings of the XII International Conference of the Chilean Computer Science Society
Multidimensional Data Modeling for Complex Data
ICDE '99 Proceedings of the 15th International Conference on Data Engineering
Data warehouse scenarios for model management
ER'00 Proceedings of the 19th international conference on Conceptual modeling
Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
| Hi-index | 0.00 |
Many practitioners and researchers advocate that the designs of the data models of the data warehouses should incorporate the source data as much as possible to answer the finest levels of queries. On the other hand, the source data are very likely to come from systems designed with ER Diagrams. Therefore, many researches have been devoted to design methodologies to build multidimensional model based on corresponding source ER diagrams. However, to the best of our knowledge, no algorithm has been proposed to systematically translates an entire ER Diagram into a multidimensional model with hierarchical snowflake structures. The algorithm proposed in the paper promised to do so with two characteristics, namely, grain preservation and minimal distance from each table to the fact table. Grain preservation characteristic guarantees that translated multidimensional model has cohesive granularity among entities. The minimal distance characteristics guarantees that if an entity can be connected to the fact table in the derived model with more than one paths, the one with the shortest hops will always be chosen. The first characteristic is achieved by translating problematic relationships between entities with weight_factor attributes in bridging tables and enhancing fact tables with unique primary keys. The second characteristic is achieved by including a revised shortest path algorithm in the translating algorithm with the distance being calculated as the number of relationships required between entities.