SAMSTARplus: An Automatic Tool for Generating Multi- Dimensional Schemas from an Entity-Relationship Diagram
Jinho Kim, Donghoo Kim, Suan Lee, Yang‐Sae Moon, Il-Yeol Song, Ritu Khare, Yuan An · Revista de Informática Teórica e Aplicada · 2010
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.