TY - JOUR
T1 - Understanding database design expertise
AU - Storey, Veda C.
AU - Thompson, Cheryl Bagley
AU - Ram, Sudha
N1 - Funding Information:
This research was supported by the National Science Foundation under Research Initiation Award IRI-9209252, and by the National Center for Nursing Research, NIGH, NR06309-02. The authors wish to thank Robert C. Goldstein, University of British Columbia, and Niki Fowler for useful comments on a previous version of this manuscript. * Communicating author. Emaih [email protected]
PY - 1995/8
Y1 - 1995/8
N2 - 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.
AB - 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.
KW - Conceptual design
KW - Database design
KW - Database design systems
KW - Entity-Relationship model
KW - Expert systems
KW - Expertise
KW - Logical design
KW - Relational model
KW - Requirements analysis
UR - http://www.scopus.com/inward/record.url?scp=0029354616&partnerID=8YFLogxK
UR - http://www.scopus.com/inward/citedby.url?scp=0029354616&partnerID=8YFLogxK
U2 - 10.1016/0169-023X(95)00012-H
DO - 10.1016/0169-023X(95)00012-H
M3 - Article
AN - SCOPUS:0029354616
SN - 0169-023X
VL - 16
SP - 97
EP - 124
JO - Data and Knowledge Engineering
JF - Data and Knowledge Engineering
IS - 2
ER -