Joining distributed complex objects: Definition and performance

The performance of a non-standard distributed database system is strongly ifluenced by complex objects. The effective exploitation of parallelism in querying them and a suitable structure to store them are required in order to obtain acceptable response times in these database environments where performance tends to be critical. In this paper we use an hierarchical complex object model with object references and define several join operations for these complex objects which we will call tuple objects. These join queries for tuple-objects can be categorized into materialized, functional and value-based joins. An analytical performance evaluation gives insight into which distributed storage structures for tuple-objects are most effective with regard to executing the different kinds of tuple-object joins.

[1]  David J. DeWitt,et al.  Storage management for objects in EXODUS , 1989 .

[2]  Setrag Khoshafian,et al.  Object identity , 1986, OOPSLA 1986.

[3]  David J. DeWitt,et al.  A data model and query language for EXODUS , 1988, SIGMOD '88.

[4]  David J. DeWitt,et al.  GAMMA - A High Performance Dataflow Database Machine , 1986, VLDB.

[5]  Henk Blanken,et al.  Representing complex objects in a distributed database: a performance evaluation , 1990 .

[6]  Hans-Jörg Schek,et al.  Foundations of Data Organization and Algorithms , 1989, Lecture Notes in Computer Science.

[7]  Peter Pistor,et al.  Designing A Generalized NF2 Model with an SQL-Type Language Interface , 1986, VLDB.

[8]  Jay Banerjee,et al.  Queries in object-oriented databases , 1988, Proceedings. Fourth International Conference on Data Engineering.

[9]  David J. DeWitt,et al.  The Architecture of the EXODUS Extensible DBMS , 1986, On Object-Oriented Database System.

[10]  Patrick Valduriez,et al.  Join indices , 1987, TODS.

[11]  David J. DeWitt,et al.  Parallel database systems: the future of database processing or a passing fad? , 1990, SGMD.

[12]  David J. DeWitt,et al.  The Object-Oriented Database System Manifesto , 1994, Building an Object-Oriented Database System, The Story of O2.

[13]  Eugene Wong,et al.  Query processing in a system for distributed databases (SDD-1) , 1981, TODS.

[14]  David Maier,et al.  Efficient assembly for complex objects , 1991, SIGMOD '91.

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

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

[17]  Wil Plouffe,et al.  Complex Objects and Their Use in Design Transactions , 1983, Engineering Design Applications.

[18]  Peter Dadam,et al.  The Advanced Information Management Prototype , 1987, NF².

[19]  Henk M. Blanken,et al.  Geographic data modelling in TM , 1991 .

[20]  Theo Härder,et al.  An Approach to Implement Dynamically Defined Complex Objects , 1991, PRISMA Workshop.

[21]  Henk Blanken,et al.  Three-phase parallel join model , 1990 .

[22]  Patrick Valduriez,et al.  Implementation Techniques of Complex Objects , 1986, VLDB.

[23]  Hans-Jörg Schek,et al.  Architecture and implementation of the Darmstadt database kernel system , 1987, SIGMOD '87.

[24]  Michael J. Carey,et al.  A performance evaluation of pointer-based joins , 1990, SIGMOD '90.

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