Abstract Logical relational database design, because of its implementation-independent nature, has been successfully formalized. Physical relational database design, because of its implementation-dependent nature, has remained largely unformalized and disconnected, not only from logical design but also from conceptual database design. The paper suggests a model for the physical design process that has proven useful in a number of practical development projects. The model demonstrates that a seamless join between conceptual, logical and physical design work is feasible. It illustrates how the process of annotating a conceptual model with physical detail provides a useful framework for driving the process of physical relational database design.
[1]
Paul Beynon-Davies.
Relational Database Systems: A Pragmatic Approach
,
1991
.
[2]
James Martin.
Managing the data-base environment
,
1983
.
[3]
E. Bono.
The Mechanism of Mind
,
1969
.
[4]
Paul Beynon-Davies.
Relational Database Design
,
1992
.
[5]
E. F. Codd,et al.
The Relational Model for Database Management, Version 2
,
1990
.
[6]
Gottfried Vossen.
Data models, database languages and database management systems
,
1990,
International computer science series.
[7]
Michael J. R. Shave.
Entities, Functions and Binary Relations: Steps to a Conceptual Schema
,
1981,
Comput. J..