SAMSTAR: An Automatic Tool for Generating Star Schemas from an Entity-Relationship Diagram

Authors:
Il-Yeol Song;Ritu Khare;Yuan An;Suan Lee;Sang-Pil Kim;Jinho Kim;Yang-Sae Moon
Affiliations:
College of Information Science and Technology, Drexel University, Philadelphia, U.S.A. PA19104;College of Information Science and Technology, Drexel University, Philadelphia, U.S.A. PA19104;College of Information Science and Technology, Drexel University, Philadelphia, U.S.A. PA19104;Department of Computer Science, Kangwon National University, Kangwon, Korea 200-701;Department of Computer Science, Kangwon National University, Kangwon, Korea 200-701;Department of Computer Science, Kangwon National University, Kangwon, Korea 200-701;Department of Computer Science, Kangwon National University, Kangwon, Korea 200-701
Venue:
ER '08 Proceedings of the 27th International Conference on Conceptual Modeling
Year:
2008

Citing 1
Cited 3

SAMSTAR: a semi-automated lexical method for generating star schemas from an entity-relationship diagram

Proceedings of the ACM tenth international workshop on Data warehousing and OLAP

Hetero-homogeneous hierarchies in data warehouses

APCCM '10 Proceedings of the Seventh Asia-Pacific Conference on Conceptual Modelling - Volume 110
Integrating Star and Snowflake Schemas in Data Warehouses

International Journal of Data Warehousing and Mining
Discovering diverse association rules from multidimensional schema

Expert Systems with Applications: An International Journal

Quantified Score

Hi-index	0.00

Visualization

Abstract

While online transaction processing (OLTP) databases are modeled with Entity-Relationship Diagrams (ERDs), data warehouses constructed from these OLTP DBs are usually represented as star schema. Designing data warehouse schemas, however, is very time consuming. We present a prototype system, SAMSTAR, which automatically generates star schemas from an ERD. The system takes an ERD drawn by ERwin Data Modeler as an input and generates star schemas. SAMSTAR uses the Connection Topology Value [1] which is the syntactic structural information embedded in an ERD. SAMSTAR displays the resulting star schemas on a computer screen graphically. With this automatic generation of star schema, this system helps designers reduce their efforts and time in building data warehouse schemas.