JUSTIFYING DATABASE NORMALIZATION - A COST-BENEFIT MODEL

Cited 11 time in webofscience Cited 0 time in scopus
  • Hit : 841
  • 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
English
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
MT-Journal Papers(저널논문)
Files in This Item
This item is cited by other documents in WoS
⊙ Detail Information in WoSⓡ Click to see webofscience_button
⊙ Cited 11 items in WoS Click to see citing articles in records_button

qr_code

  • mendeley

    citeulike


rss_1.0 rss_2.0 atom_1.0