A grain preservation translation algorithm: From ER diagram to multidimensional model
Information Sciences: an International Journal
Dimensional hierarchies: implementation in data warehouse logical scheme design
CompSysTech '07 Proceedings of the 2007 international conference on Computer systems and technologies
Proceedings of the International Conference on Advances in Computing, Communication and Control
A systematic approach for transformation of ER schema to dimensional schema
Proceedings of the 7th International Conference on Frontiers of Information Technology
Complexity study on "Carry-along Sort" algorithm
ACAI '11 Proceedings of the International Conference on Advances in Computing and Artificial Intelligence
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 |
This paper addresses DW design problems, with the goal of improving the DW logical design process. Some of the existing work in transformation oriented methodologies for DW design construct the DW starting from an Entity-Relationship model of the source database, and arrive to a conceptual or high-level-logical dimensional model of the DW. We propose a mechanism for obtaining the DW logical schema through pre-defined transformations applied to the source logical schema, which can be used as a complement to the existing DW designmethodologies. The transformations allow a refined logical design of the DW and provide a trace of the design and a mapping between the source and DW logical structures.