Topics in Information Systems

Query Processing in Database Systems

Editors: Kim, W., Reiner, D.S., Batory, Don (Eds.)

Free Preview

Buy this book

eBook $99.00
price for USA in USD
  • ISBN 978-3-642-82375-6
  • Digitally watermarked, DRM-free
  • Included format:
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $129.99
price for USA in USD
  • ISBN 978-3-642-82377-0
  • Free shipping for individuals worldwide
  • Institutional customers should get in touch with their account manager
  • Covid-19 shipping restrictions
  • Usually ready to be dispatched within 3 to 5 business days, if in stock
About this book

This book is an anthology of the results of research and development in database query processing during the past decade. The relational model of data provided tremendous impetus for research into query processing. Since a relational query does not specify access paths to the stored data, the database management system (DBMS) must provide an intelligent query-processing subsystem which will evaluate a number of potentially efficient strategies for processing the query and select the one that optimizes a given performance measure. The degree of sophistication of this subsystem, often called the optimizer, critically affects the performance of the DBMS. Research into query processing thus started has taken off in several directions during the past decade. The emergence of research into distributed databases has enormously complicated the tasks of the optimizer. In a distributed environment, the database may be partitioned into horizontal or vertical fragments of relations. Replicas of the fragments may be stored in different sites of a network and even migrate to other sites. The measure of performance of a query in a distributed system must include the communication cost between sites. To minimize communication costs for-queries involving multiple relations across multiple sites, optimizers may also have to consider semi-join techniques.

Table of contents (18 chapters)

Table of contents (18 chapters)

Buy this book

eBook $99.00
price for USA in USD
  • ISBN 978-3-642-82375-6
  • Digitally watermarked, DRM-free
  • Included format:
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $129.99
price for USA in USD
  • ISBN 978-3-642-82377-0
  • Free shipping for individuals worldwide
  • Institutional customers should get in touch with their account manager
  • Covid-19 shipping restrictions
  • Usually ready to be dispatched within 3 to 5 business days, if in stock
Loading...

Bibliographic Information

Bibliographic Information
Book Title
Query Processing in Database Systems
Editors
  • W. Kim
  • D.S. Reiner
  • Don Batory
Series Title
Topics in Information Systems
Copyright
1985
Publisher
Springer-Verlag Berlin Heidelberg
Copyright Holder
Springer-Verlag Berlin Heidelberg
eBook ISBN
978-3-642-82375-6
DOI
10.1007/978-3-642-82375-6
Softcover ISBN
978-3-642-82377-0
Series ISSN
1431-9365
Edition Number
1
Number of Pages
XIV, 366
Topics