Accessing out-of-tuple data: A performance study

摘要

In an OR-DBMS, multi-megabyte attributes generally store only metadata within the tuple; the data itself is in external objects. The objects and the tuples generally start on the same node in a shared-nothing system, but tuples move around without their data during query processing. In this paper, we study how to execute a method on an attribute when the tuple is on one node, and the data is on another. We study four techniques, based on whether to ship the method or the data and whether to ship one-by-one or in larger units. We present a series of performance studies, which establish that the effect of the various solutions on the disk utilization is far more significant than their effect on the network load.