Semi-automatic conceptual data modeling using entity and relationship instance repositories

  • Authors:

  • Ornsiri Thonggoom;Il-Yeol Song;Yuan An

  • Affiliations:

  • The iSchool at Drexel University, Philadelphia, PA;The iSchool at Drexel University, Philadelphia, PA;The iSchool at Drexel University, Philadelphia, PA

  • Venue:
  • ER'11 Proceedings of the 30th international conference on Conceptual modeling
  • Year:
  • 2011

Quantified Score

Hi-index 0.00

Visualization

Abstract

Data modelers frequently lack experience and have incomplete knowledge about the application being designed. To address this issue, we propose new types of reusable artifacts called Entity Instance Repository (EIR) and Relationship Instance Repository (RIR), which contain ER modeling patterns from prior designs and serve as knowledge-based repositories for conceptual modeling. We explore the development of automated data modeling tools with EIR and RIR. We also select six data modeling rules used for identification of entities in one of the tools. Two tools were developed in this study: Heuristic-Based Technique (HBT) and Entity Instance Pattern WordNet (EIPW). The goals of this study are (1) to find effective approaches that can improve the novice modelers' performance in developing conceptual models by integrating patternbased technique and various modeling techniques, (2) to evaluate whether those selected six modeling rules are effective, and (3) to validate whether the proposed tools are effective in creating quality data models. In order to evaluate the effectiveness of the tools, empirical testing was conducted on tasks of different sizes. The empirical results indicate that novice designers' overall performance increased 30.9-46.0% when using EIPW, and increased 33.5-34.9 % when using HBT, compared with the cases with no tools.