JUSTIFYING DATABASE NORMALIZATION - A COST-BENEFIT MODEL

Cited 0 time in webofscience Cited 0 time in scopus
  • Hit : 544
  • Download : 4
During the information systems development process within an organization, data resource is typically analyzed in the form of a data model. During this data analysis phase, the data model is further refined so that it obeys certain rules of good behavior. Normalization is the process of grouping data into such well refined structures. Determining an appropriate normal form has not been clear to database systems analysts. This paper proposes an effective methodology for determining normal forms by employing a cost/benefit model coupled with a decision tree. Three primary variables that impact the benefits and costs of normalization are addressed. The resulting cost/benefit analysis enables database analysts to produce more cost-effective normalized databases.
Publisher
PERGAMON-ELSEVIER SCIENCE LTD
Issue Date
1995-01
Language
ENG
Article Type
Article
Citation

INFORMATION PROCESSING MANAGEMENT, v.31, no.1, pp.59 - 67

ISSN
0306-4573
DOI
10.1016/0306-4573(94)E0011-P
URI
http://hdl.handle.net/10203/4580
Appears in Collection
KSIM-Journal Papers(저널논문)

qr_code

  • mendeley

    citeulike


rss_1.0 rss_2.0 atom_1.0