Query Processing in Database Systems

Query Processing in Database Systems
Author :
Publisher : Springer Science & Business Media
Total Pages : 367
Release :
ISBN-10 : 9783642823756
ISBN-13 : 3642823750
Rating : 4/5 (750 Downloads)

Book Synopsis Query Processing in Database Systems by : W. Kim

Download or read book Query Processing in Database Systems written by W. Kim and published by Springer Science & Business Media. This book was released on 2012-12-06 with total page 367 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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.


Query Processing in Database Systems Related Books

Principles of Database Query Processing for Advanced Applications
Language: en
Pages: 512
Authors: Clement T. Yu
Categories: Computers
Type: BOOK - Published: 1998 - Publisher: Morgan Kaufmann

GET EBOOK

A thorough presentation of query processing techniques in a broad range of database systems for advanced applications. Provides the most effective query process
Query Processing in Database Systems
Language: en
Pages: 367
Authors: W. Kim
Categories: Computers
Type: BOOK - Published: 2012-12-06 - Publisher: Springer Science & Business Media

GET EBOOK

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
Principles of Distributed Database Systems
Language: en
Pages: 856
Authors: M. Tamer Özsu
Categories: Computers
Type: BOOK - Published: 2011-02-24 - Publisher: Springer Science & Business Media

GET EBOOK

This third edition of a classic textbook can be used to teach at the senior undergraduate and graduate levels. The material concentrates on fundamental theories
Query Processing for Advanced Database Systems
Language: en
Pages: 512
Authors: Johann Christoph Freytag
Categories: Computers
Type: BOOK - Published: 1995 - Publisher: Morgan Kaufmann Publishers

GET EBOOK

The chapters of this book provide an excellent snapshot of current research and development activities in the area of query processing and optimization. They su
Advanced SQL:1999
Language: en
Pages: 600
Authors: Jim Melton
Categories: Computers
Type: BOOK - Published: 2003 - Publisher: Morgan Kaufmann

GET EBOOK

This guide documents SQL: 1999Us advanced features in the same practical, "programmercentric" way that the first volume documented the language's basic features