On the automatic generation of optimal internal schemata

摘要

A Data Base Design, problem using the most modern techniques is usually divided into Conceptual Schema Design, External Schemata Design and Internal Schema Design. Currently, each of these design steps is done manually with few computerised aids.A method is described for deriving automatically the Internal Schema from the Conceptual and External Schemata. The method is proved to generate the optimal Internal Schema and to be easily amendable to updates in the Conceptual and External Schemata.