Justifying database normalization: a cost/benefit model
作者:
Highlights:
•
摘要
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.
论文关键词:Database systems,Database analysis,Normal forms,Normalization decision,Cost/benefit model,Decision tree,Binary decisions,Graphical decision support
论文评审过程:Received 5 October 1993, Accepted 24 March 1994, Available online 4 October 2002.
论文官网地址:https://doi.org/10.1016/0306-4573(95)80006-F