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

Song, Il‐Yeol; Khare, Ritu; An, Yuan; Lee, Suan; Kim, Sang-Pil; Kim, Jin-Ho; Moon, Yang-Sae

doi:10.1007/978-3-540-87877-3_42

Cited by 33 publications

(37 citation statements)

References 1 publication

Supporting

Mentioning

Contrasting

Order By: Relevance

“…This prerequisite is not easy to fulfill in many real organizations and in order to solve this problem, current automatable methods directly work over relational databases (i.e., getting up-to-date data). To our knowledge, only three exceptions exist to this rule [20,19,13], which automate the process from ER schemas (the first one) and ontologies (the other two). Consequently, all these methods (or stages within hybrid approaches) follow a supply-driven paradigm and thus, rely on a thorough analysis of the sources.…”

Section: Multidimensional Modelingmentioning

confidence: 99%

A Comprehensive Framework on Multidimensional Modeling

Romero

Abelló

2011

Advances in Conceptual Modeling. Recent Developments and New Directions

View full text Add to dashboard Cite

Abstract. In this paper we discuss what current multidimensional design approaches provide and which are their major flaws. Our contribution lays in a comprehensive framework that does not focus on how these approaches work but what they do provide for usage in real data warehouse projects. So that, we do not aim at comparing current approaches but set up a framework (based on four criteria: the role played by enduser requirements and data sources, the degree of automation achieved and the quality of the output produced) highlighting their drawbacks, and the need for further research on this area.

show abstract

Section: Multidimensional Modelingmentioning

confidence: 99%

A Comprehensive Framework on Multidimensional Modeling

Romero

Abelló

2011

Advances in Conceptual Modeling. Recent Developments and New Directions

View full text Add to dashboard Cite

show abstract

“…Many works have dealt with designing DW models; e.g., [4,6,12,14,19], to mention a few, but the list is long. However, in most works, it seems that the more the process gets automated, the more the integration of requirements is overlooked on the way.…”

Section: Related Workmentioning

confidence: 99%

GEM: Requirement-Driven Generation of ETL and Multidimensional Conceptual Designs

Romero

Simitsis

Abelló

2011

Lecture Notes in Computer Science

View full text Add to dashboard Cite

At the early stages of a data warehouse design project, the main objective is to collect the business requirements and needs, and translate them into an appropriate conceptual, multidimensional design. Typically, this task is performed manually, through a series of interviews involving two different parties: the business analysts and technical designers. Producing an appropriate conceptual design is an errorprone task that undergoes several rounds of reconciliation and redesigning, until the business needs are satisfied. It is of great importance for the business of an enterprise to facilitate and automate such a process. The goal of our research is to provide designers with a semi-automatic means for producing conceptual multidimensional designs and also, conceptual representation of the extract-transform-load (ETL) processes that orchestrate the data flow from the operational sources to the data warehouse constructs. In particular, we describe a method that combines information about the data sources along with the business requirements, for validating and completing -if necessary-these requirements, producing a multidimensional design, and identifying the ETL operations needed. We present our method in terms of the TPC-DS benchmark and show its applicability and usefulness.

show abstract

“…Likewise, an automatic tool for generating star schema from an Entity-Relationship Diagram (ERD) was introduced by [30]. A prototype named SAMSTAR was presented, which was used for the automatic generation of star schema from an ERD.…”

Section: Integration Of Datamentioning

confidence: 99%