Relational division: four algorithms and their performance
- 7 January 2003
- conference paper
- Published by Institute of Electrical and Electronics Engineers (IEEE)
Abstract
Three known algorithms for relational division, the algebra operator used to express universal quantification (for-all conditions) and an algorithm called hash-division are outlined. By comparing the algorithms analytically and experimentally, it is shown that the algorithm provides performance competitive with or superior to that of techniques used to date, namely techniques using sorting or aggregate functions. Furthermore, the algorithm can eliminate duplicates in the divisor on the fly, ignores duplicates in the dividend, and allows two kinds of partitioning, either of which can be used to resolve hash table overflow or to efficiently implement the algorithm on a multiprocessor system.Keywords
This publication has 4 references indexed in Scilit:
- Design and implementation of the wisconsin storage systemSoftware: Practice and Experience, 1985
- Implementation techniques for main memory database systemsPublished by Association for Computing Machinery (ACM) ,1984
- Implementing a relational database by means of specialzed hardwareACM Transactions on Database Systems, 1979
- Optimizing the performance of a relational algebra database interfaceCommunications of the ACM, 1975