Synonyms
Distributed query; Distributed query optimization
Definition
Distributed query processing is the procedure of answering queries (which means mainly read operations on large data sets) in a distributed environment where data is managed at multiple sites in a computer network. Query processing involves the transformation of a high-level query (e.g., formulated in SQL) into a query execution plan (consisting of lower-level query operators in some variation of relational algebra) as well as the execution of this plan. The goal of the transformation is to produce a plan which is equivalent to the original query (returning the same result) and efficient, i.e., to minimize resource consumption like total costs or response time.
Historical Background
Motivated by the needs of large companies and organizations that manage their data at different sites, distributed database systems are subject of research since the late 1970s. In these years, three important prototype systems were...
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsRecommended Reading
Bernstein PA, Goodman N, Wong E, Reeve CL, Rothnie Jr JB. Query processing in a system for distributed databases (SDD-1). ACM Trans Database Syst. 1981;6(4):602–25.
Ceri S, Pelagatti G. Correctness of query execution strategies in distributed databases. ACM Trans Database Syst. 1983;8(4):577–607.
Franklin M, Jonsson B, Kossmann D. Performance tradoffs for client-server query processing. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1996. p. 149–60.
Levy A, editor. Special issue on Adaptive Query Processing. Bull Tech Comm Data Eng. 2000; 23(2).
Kossmann D. The state of the art in distributed query processing. ACM Comput Surv. 2000;32(4):422–69.
Kossmann D, Franklin M, Drasch G, Ag W. Cache investment: integrating query optimization and distributed data placement. ACM Trans Database Syst. 2000;25(4):517–58.
Özsu MT, Valduriez P. Principles of distributed database systems. 2nd ed. Upper Saddle River: Prentice-Hall; 1999.
Stonebraker M. The design and implementation of distributed INGRES. In: Stonebraker M, editor. The INGRES papers. Reading: Addison-Wesley; 1986.
Stonebraker M, Aoki P, Litwin W, Pfeffer A, Sah A, Sidell J, Staelin C, Yu A. Mariposa: a wide-area distributed database system. VLDB J. 1996;5(1):48–63.
Stonebraker M, Hellerstein JM. Distributed database systems. In: Stonebraker M, Hellerstein JM, editors. Readings in database systems. 3rd ed. San Francisco: Morgan Kaufmann; 1998.
Williams R, Daniels D, Hass L, Lapis G, Lindsay B, Ng P, Obermarck R, Selinger P, Walker A, Wilms P, Yost R. R*: an overview of the architecture. IBM Research Lab, San Jose, Technical Report RJ3325; 1981.
Yu CT, Chang CC. Distributed query processing. ACM Comput Surv. 1984;16(4):399–433.
Yu CT, Meng W. Principles of database query processing for advanced applications. San Francisco: Morgan Kaufmann; 1998.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
Cite this entry
Sattler, KU. (2018). Distributed Query Processing. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_704
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_704
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering