Relational database operations (selection, projection, join, etc.) can be implemented with 100% parallelism if each relation is stored as a set of bit vectors containing projections on subsets of the bits of a tuple (Ullmann 1988, 1990). This representation is approximate in that spurious tuples, called false drops, may be recovered along with the genuine tuples. In small-scale experiments, the
... [Show full abstract] number of projections required to maintain the expected number of false drops at a low, constant value was reported to be linearly proportional to the number of tuples stored in the database (Ullmann 1988). We show that a previous estimate for the number of false drops (Roberts 1979), given in the context of Bloom filters (Bloom 1970), also demonstrates a near-linear behaviour, but seriously underestimates the number of false drops, due to an assumption of independence between the projections which is no longer valid for the parallel database hardware. We give an improved estimate for the number of false drops which agrees well with the experimental results. This allows us to determine optimal parameters for the parallel database hardware.