Cluster Mechanisms Supporting the Dynamic Construction of Complex Objects

Non-standard database applications require adequate modeling facilities for their application objects which in general have an internal structure to be maintained by the database system. For this purpose, the database system has to provide fast access to such an object as a whole as well as to its components. In systems which support complex objects with a statically established structure, clustering of the objects' components along this structure is a widespread means to enhance efficiency. Systems which support the dynamic definition of complex objects' structures, however, cannot predict the characteristics of accesses to the database, and therefore have more problems in finding a storage structure that is useful for at least the majority of the accesses. In this paper, we propose a cluster mechanism that supports the flexibility and dynamism of the molecule-atom data model at the efficiency of static structure clustering. We discuss different alternatives for its design, taking into account the query processing strategies of the underlying database system. We address some problems concerning optimization that emerge from the dynamic structure definition and show some possible solutions.

[1]  Jay Banerjee,et al.  Operations and Implementation of Complex Objects , 1988, IEEE Trans. Software Eng..

[2]  Klaus Meyer-Wegener,et al.  PRIMA - a DBMS Prototype Supporting Engineering Applications , 1987, VLDB.

[3]  Alejandro P. Buchmann,et al.  Molecular Objects, Abstract Data Types, and Data Models: A Framework , 1984, VLDB.

[4]  Hans-Jörg Schek,et al.  The relational model with relation-valued attributes , 1986, Inf. Syst..

[5]  Timos K. Sellis Efficiently supporting procedures in relational database systems , 1987, SIGMOD '87.

[6]  Bernhard Mitschang,et al.  Ein Molekül-Atom-Datenmodell für Non-Standard-Anwendungen: Anwendungsanalyse, Datenmodellentwurf und Implementierungskonzepte , 1988, Informatik-Fachberichte.

[7]  Michael Stonebraker,et al.  Extending a database system with procedures , 1987, TODS.

[8]  Hamid Pirahesh,et al.  A snapshot differential refresh algorithm , 1986, SIGMOD '86.

[9]  Peter Dadam,et al.  A DBMS prototype to support extended NF2 relations: an integrated view on flat tables and hierarchies , 1986, SIGMOD '86.

[10]  Hans-Jörg Schek,et al.  A Storage System for Complex Objects , 1986, OODBS.

[11]  Alon Itai,et al.  Maintenance of views , 1984, SIGMOD '84.

[12]  Laurian M. Chirica,et al.  The entity-relationship model: toward a unified view of data , 1975, SIGF.

[13]  Bernhard Mitschang Towards a Unified View of Design Data and Knowledge Representation , 1988, Expert Database Conf..

[14]  Eric N. Hanson,et al.  A performance analysis of view materialization strategies , 1987, SIGMOD '87.

[15]  Michael Stonebraker,et al.  Implementation of integrity constraints and views by query modification , 1975, SIGMOD '75.

[16]  Frank Wm. Tompa,et al.  Efficiently updating materialized views , 1986, SIGMOD '86.

[17]  A. Sikeler Supporting Object-oriented Processing by Redundant Storage Structures , 1989 .

[18]  Irving L. Traiger,et al.  A history and evaluation of System R , 1981, CACM.

[19]  Bruce G. Lindsay,et al.  Database Snapshots , 1980, VLDB.

[20]  Theo Härder,et al.  Parallelism in Processing Queries on Complex Objects , 1988, Proceedings [1988] International Symposium on Databases in Parallel and Distributed Systems.