info:eu-repo/semantics/article
SAMSTARplus: An Automatic Tool for Generating Multi- Dimensional Schemas from an Entity-Relationship Diagram
Autor
Kim, Jinho
Kim, Donghoo
Lee, Suan
Moon, Yang-Sae
Song, Il-Yeol
Khare, Ritu
An, Yuan
Resumen
This paper presents a tool that automatically generates multidimensional schemas for data warehouses from OLTP entity-relationship diagrams (ERDs). Based on user’s input parameters, it generates star schemas, snowflake schemas, or a fact constellation schema by taking advantage of only structural information of input ERDs. Hence, SAMSTARplus can help users reduce efforts for designing data warehouses and aids decision making.