Implementation Selection for Object-Role Models

The focus of this paper is database design in the context of converting a conceptual data model into an internal representation. For a given conceptual data model, an access pro-le speciies statistical information about (retrieval and update) requests to be performed, while a data proole speciies a statistical characterization of the database contents. The corresponding time/space trade-oo and update/retrieval trade-oo are usually very untrans-parent, especially in the case of large databases with many diierent fact types, combined with complex prooles. In this paper we describe a general strategy for examining the trade-oos for a given application, and for constructing and trying-out several (diierent) databases for the same conceptual data model (multiprototyping).

[1]  T. L. Vincent,et al.  Optimality in parametric systems , 1981 .

[2]  Patrick van Bommel,et al.  Towards Database Optimization by Evolution , 1992, CISMOD.

[3]  David A. Bell,et al.  The use of simulated annealing for clustering data in databases , 1990, Inf. Syst..

[4]  Patrick van Bommel,et al.  A Randomised Schema Mutator for Evolutionary Database Optimisation , 1993, Aust. Comput. J..

[5]  Lawrence. Davis,et al.  Handbook Of Genetic Algorithms , 1990 .

[6]  Patrick van Bommel,et al.  Reducing the search space for conceptual schema transformation , 1992, Data Knowl. Eng..

[7]  György Kovács,et al.  Transformation of database populations and operations from the conceptual to the internal level , 1994, Inf. Syst..

[8]  Isamu Kobayashi Classification and transformations of binary relationship relation schemata , 1986, Inf. Syst..

[9]  David E. Goldberg,et al.  Genetic Algorithms in Search Optimization and Machine Learning , 1988 .

[10]  Olga De Troyer RIDL*: a tool for the computer-assisted engineering of large databases in the presence of integrity constraints , 1989, SIGMOD '89.

[11]  G. M. Nijssen,et al.  Conceptual schema and relational database design - a fact oriented approach , 1989 .

[12]  C. M. R. Leung,et al.  Relational database design using the NIAM conceptual schema , 1988, Inf. Syst..

[13]  F. Glover,et al.  In Modern Heuristic Techniques for Combinatorial Problems , 1993 .

[14]  小林 功武 CLASSIFICATION AND TRANSFORMATIONS OF BINARY RELATIONSHIP RELATION SCHEMATA , 1986 .

[15]  Terry A. Halpin A Fact-Oriented Approach to Schema Transformation , 1991, MFDBS.

[16]  Arthur H. M. ter Hofstede,et al.  Semantics and verification of object-role models , 1991, Inf. Syst..

[17]  Olga De Troyer On data schema transformations , 1993 .

[18]  Peretz Shoval,et al.  ADDS: A System for Automatic Database Schema Design Based on the Binary-Relationship Model , 1987, Data Knowl. Eng..