Using a knowledge learning framework to predict errors in database design

Sabah Currim, Sudha Ram, Alexandra Durcikova, Faiz Currim

Research output: Contribution to journalArticle

3 Scopus citations

Abstract

Conceptual data modeling is a critical but difficult part of database development. Little research has attempted to find the underlying causes of the cognitive challenges or errors made during this stage. This paper describes a Modeling Expertise Framework (MEF) that uses modeler expertise to predict errors based on the revised Bloom's taxonomy (RBT). The utility of RBT is in providing a classification of cognitive processes that can be applied to knowledge activities such as conceptual modeling. We employ the MEF to map conceptual modeling tasks to different levels of cognitive complexity and classify current modeler expertise levels. An experimental exercise confirms our predictions of errors. Our work provides an understanding into why novices can handle entity classes and identifying binary relationships with some ease, but find other components like ternary relationships difficult. We discuss implications for data modeling training at a novice and intermediate level, which can be extended to other areas of Information Systems education and training.

Original languageEnglish (US)
Pages (from-to)11-31
Number of pages21
JournalInformation Systems
Volume40
DOIs
StatePublished - Jan 1 2014

Keywords

  • Analysis of errors
  • Database design
  • Entity Relationship modeling
  • Modeling expertise
  • Revised Bloom's taxonomy

ASJC Scopus subject areas

  • Software
  • Information Systems
  • Hardware and Architecture

Fingerprint Dive into the research topics of 'Using a knowledge learning framework to predict errors in database design'. Together they form a unique fingerprint.

  • Cite this