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
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
A case of data warehousing project management
Information and Management
The benefits of data warehousing: why some organizations realize exceptional payoffs
Information and Management
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
Automated data warehousing for rule-based CRM systems
ADC '03 Proceedings of the 14th Australasian database conference - Volume 17
Data Warehouse Design: A Schema-Transformation Approach
SCCC '02 Proceedings of the XII International Conference of the Chilean Computer Science Society
Multidimensional normal forms for data warehouse design
Information Systems
Multidimensional Data Modeling for Complex Data
ICDE '99 Proceedings of the 15th International Conference on Data Engineering
Features to consider in a data warehousing system
Communications of the ACM - Blueprint for the future of high-performance networking
Integrating heterogeneous data warehouses using XML technologies
Journal of Information Science
Transforming an Operational System Model to a Data Warehouse Model: A Survey of Techniques
SWSTE '05 Proceedings of the IEEE International Conference on Software - Science, Technology & Engineering
An OPM-based Method for Transformation of Operational System Model to Data Warehouse Model
SWSTE '05 Proceedings of the IEEE International Conference on Software - Science, Technology & Engineering
Building the Data Warehouse
Design and development of a tool for integrating heterogeneous data warehouses
DaWaK'05 Proceedings of the 7th international conference on Data Warehousing and Knowledge Discovery
A systematic approach for transformation of ER schema to dimensional schema
Proceedings of the 7th International Conference on Frontiers of Information Technology
DEXA'11 Proceedings of the 22nd international conference on Database and expert systems applications - Volume Part II
Hi-index | 0.07 |
Many IT practitioners and researchers advocate that data models of data warehouses should incorporate the sources of their data in order to achieve maximum efficiency. As the source data are probably derived from system designed with ER diagrams, a great deal of research has been devoted to the design of methodologies for building multidimensional models based on source ER diagrams. However, to the best of our knowledge, no algorithm has been proposed that can systematically translate an entire ER diagram into a multidimensional model with hierarchical snowflake structures. In this paper, we propose an algorithm that achieves the above goal because it incorporates two features, namely, grain preservation and the minimal distance from each dimension table to the fact table. The grain preservation feature guarantees that the translated multidimensional model will maintain cohesive granularity among the entities. Meanwhile, the minimal distance feature guarantees that if an entity can be connected to the fact table in the multidimensional model by more than one path, the path with the smallest number of hops will always be chosen. The first feature is derived by translating ambiguous relationships between entities into weighting factors stored in bridge tables and enhancing fact tables with unique primary keys. The second feature results from including a revised shortest path algorithm in the translating algorithm, with the distance being calculated as the number of relationships required between entities. A prototype system based on the methodology is also developed, and snapshots of the screens used for the system's execution are presented.