An approach to efficient database design incorporating usage information

摘要

In this paper, a logical database design approach which tries to benefit from both data dependencies and usage information is presented. The approach incorporates a model which extends the traditional data dependency model of relational database theory by combining the natural (functional) and usage views of data. A comprehensive algorithm designing an efficient relational schema on the basis of the model is also presented.