Efficient Modeling Techniques

This paper demonstrates theoretical and practical approaches for designing and implementing complex data models. It is based on research work made for developing the OODBMS ODABA as well as on practical experiences. Two medium object models will be used as examples: the Integrated Metadata System for statistical offices Bridge, developed within the frame of the ACIDOSIS project (EUROSTAT) and an administration system for large enterprises Belami. Both consist of more than 100 persistent object types (including more than 300 relationships) and about 300 additional transient classes (implementation classes). Those correspond to a relational database model with 500-1000 physical tables.