Parallelism in relational database management systems

In order to provide real-time responses to complex queries involving large volumes of data, it has become necessary to exploit parallelism in query processing. The issues and solutions relating to intraquery parallelism in a relational database management system are addressed. A broad framework for...

Full description

Saved in:
Bibliographic Details
Published in:IBM systems journal 1994-01, Vol.33 (2), p.349-371
Main Authors: MOHAN, C, PIRAHESH, H, TANG, W. G, WANG, Y
Format: Article
Language:English
Subjects:
Applications
Applied sciences
Computer science
control theory
systems
Data base management systems
Exact sciences and technology
Information systems. Data bases
Memory organisation. Data processing
Parallel processing
Queries
Relational data bases
Software
Systems development
Technological change
Citations: Items that cite this one
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:In order to provide real-time responses to complex queries involving large volumes of data, it has become necessary to exploit parallelism in query processing. The issues and solutions relating to intraquery parallelism in a relational database management system are addressed. A broad framework for the study of the numerous issues that need to be addressed in supporting parallelism efficiently and flexibly is provided. The alternatives for a parallel architecture system are discussed, followed by a focus on how a query can be parallelized and how that affects load balancing of the different tasks created. Finally, information is provided about how the IBM DATABASE 2 Version 3 product provides support for I/O parallelism to reduce response time for data-intensive queries.
ISSN:0018-8670
DOI:10.1147/sj.332.0349