Transforming Conceptual Models to Object-Oriented Database Designs: Practicalities, Properties, and Peculiarities

摘要

More work is needed on devising practical, but theoretically well-founded procedures for doing object-oriented database (OODB) design. Besides being practical and having formal properties, these design procedures should also be flexible enough to allow for peculiarities that make applications unique. In this paper, we present and discuss an OODB design procedure that addresses these problems. The procedure we discuss is practical in the sense that it is based on a common family of conceptual models and in the sense that it does not expect users to supply esoteric, difficult-to-discover, and hard-to-understand constraints (such as multivalued dependencies), nor does it make hard-to-check and easy-to-overlook assumptions (such as the universal relation assumption). At the same time, the procedure is well-founded and formal, being based on a new theoretical result that characterizes properties of interest in designing complex objects. It is also flexible and adaptable to the peculiarities of a wide variety of applications.