Drexel University Home Pagewww.drexel.edu DREXEL UNIVERSITY LIBRARIES HOMEPAGE >>

iDEA: Drexel E-repository and Archives > Drexel Academic Community > College of Information Science and Technology > Research Day Posters (IST) > Automated conceptual modeling using entity and relationship instance patterns

Please use this identifier to cite or link to this item: http://hdl.handle.net/1860/3329

Title: Automated conceptual modeling using entity and relationship instance patterns
Authors: Thonggoom, Ornsiri
Song, Il-Yeol
An, Yuan
Issue Date: 15-Apr-2010
Series/Report no.: IST Research Day 2010 posters
Abstract: Conceptual data modeling is difficult because it requires for a designer to understand the application domain and to translate the requirements into a data model. However, designers frequently have incomplete knowledge about the application being designed. In this research, we explore knowledge-based and pattern-based approaches that help database designers develop quality data models. Our methodology is based on database reverse engineering concept. We develop new types of reusable artifacts, called entity instance pattern (EIP) and relationship instance pattern (RIP), which are repositories of entity instances and relationship instances, respectively. EIP and RIP are automatically extracted from the prior successful relational database schemas. The patterns in EIP and RIP are also extended with Dimensional Design Patterns (DDPs), WordNet, and case studies. This research aims to develop effective knowledge-based systems with EIP and RIP repositories. Two knowledge-based systems are examined in this study: heuristic-based technique (HBT) and ER-Pattern (ER-P). We evaluate the usefulness of our proposed artifacts and determine the effective processes that can be used in creating quality conceptual data models. The main contributions of this study are to find effective approaches that can improve the designer’s performance in developing conceptual data models and to validate whether the proposed rules in HBT are effective in creating quality data models.
URI: http://hdl.handle.net/1860/3329
Appears in Collections:Research Day Posters (IST)

Files in This Item:

File Description SizeFormat
Thonggoom, Ornsiri.pdf49.54 MBAdobe PDFView/Open
View Statistics

Items in iDEA are protected by copyright, with all rights reserved, unless otherwise indicated.


Valid XHTML 1.0! iDEA Software Copyright © 2002-2010  Duraspace - Feedback