JUSTIFYING DATABASE NORMALIZATION - A COST-BENEFIT MODEL

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
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(저널논문)
  • Hit : 479
  • Download : 4
  • Cited 0 times in thomson ci
This item is cited by other documents in WoS
⊙ Detail Information in WoSⓡClick to seewebofscience_button
⊙ Cited 6 items in WoSClick to see citing articles inrecords_button

qr_code

  • mendeley

    citeulike


rss_1.0 rss_2.0 atom_1.0