Understanding database design expertise

Veda C. Storey, Cheryl Bagley Thompson, Sudha Ram

Research output: Contribution to journalArticlepeer-review

17 Scopus citations


Database design is a complex and time-consuming process. In order to automate database design, an understanding of the nature of expertise that goes into the design process is needed. Although a number of expert systems have been developed to assist or replace a database designer, database design expertise has not been examined in any detail. This paper proposes a conceptual framework for explaining this type of expertise. The components of the framework are applied to each phase of the design process and used to provide guidelines for the level of expertise developers might strive to obtain. Several representative systems are analyzed, based on the framework, to explore the degree to which expertise is being captured. Implications for the future development of database design expert systems are discussed.

Original languageEnglish (US)
Pages (from-to)97-124
Number of pages28
JournalData and Knowledge Engineering
Issue number2
StatePublished - Aug 1995


  • Conceptual design
  • Database design
  • Database design systems
  • Entity-Relationship model
  • Expert systems
  • Expertise
  • Logical design
  • Relational model
  • Requirements analysis

ASJC Scopus subject areas

  • Information Systems and Management


Dive into the research topics of 'Understanding database design expertise'. Together they form a unique fingerprint.

Cite this