Synonyms
Definition
A semijoin program is a query execution plan for queries to distributed database systems that uses semijoins to reduce the size of relation instances before they are transmitted and further joined. Yet the reduction itself requires that a projection of the relation instances involved in the join onto the join attributes be transmitted. The maximum amount of reduction can be achieved by a semijoin program called a full reducer. Full reducers that do not require the computation of a fixpoint exist for acyclic queries. Fully reducing relation instances is rarely beneficial. However semijoin programs partially reducing selected relation instances may be an effective optimization when the dominant cost of query execution is communication. Considering semijoin programs considerably increases the distributed query optimization search space.
Historical Background
Semijoin programs were first introduced to improve the performance, input/output operations and...
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Recommended Reading
Bernstein P.A. and Chiu D.-M. W. Using semi-joins to solve relational queries. J. ACM., 28(1):25–40, 1981.
Bernstein P.A. and Goodman N. Power of natural semijoins. SIAM J. Comput., 10(4):751–771, 1981.
Bernstein P.A., Goodman N., Wong E., Reeve C.L., and Rothnie J.B. Jr. Query processing in a system for distributed databases (SDD-1) ACM Trans. Database Syst., 6(4):602–625, 1981.
Ceri S. and Pelagatti G. Distributed databases: Principles and systems. McGraw-Hill, 1984.
Fagin R. Degrees of acyclicity for hypergraphs and relational database schemes. J. ACM, 30(3):514–550, 1983.
Lal A. and Choueiry B.Y. 2004, Constraint processing techniques for improving join computation: a proof of concept. In Proc. 1st Int. Symp. on Applications of Constraint Databases, pp. 149–167.
Ozkarahan E.A., Schuster S.A., and Sevcik K.C. Performance evaluation of a relational associative processor ACM Trans. Database Syst., 2(2):175–195, 1977.
Stocker K., Kossmann D., Braumandl R., and Kemper A. Integrating semi-join-reducers into state of the art query processors. In Proc. 17th Int. Conf. on Data Engineering, 2001, pp. 575–584.
Ullman J.D. Principles of Database and Knowledge-Base Systems, Vol. II. Computer Science, 1989.
Valduriez P. and Gardarin G. Join and semijoin algorithms for a multiprocessor database machine. ACM Trans. Database Syst., 9(1):133–161, 1984.
Wallace M., Bressan S., and Provost T.L. 1995,Magic checking: constraint checking for database query optimization. In Proc. ESPRIT WG CONTESSA Workshop on Constraint databases and Applications. LNCS, Vol. 1034. Springer, pp. 148–166.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2009 Springer Science+Business Media, LLC
About this entry
Cite this entry
Bressan, S. (2009). Semijoin Program. In: LIU, L., ÖZSU, M.T. (eds) Encyclopedia of Database Systems. Springer, Boston, MA. https://doi.org/10.1007/978-0-387-39940-9_709
Download citation
DOI: https://doi.org/10.1007/978-0-387-39940-9_709
Publisher Name: Springer, Boston, MA
Print ISBN: 978-0-387-35544-3
Online ISBN: 978-0-387-39940-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering