Scheduled System Maintenance:
Some services will be unavailable Sunday, March 29th through Monday, March 30th. We apologize for the inconvenience.
By Topic

Parallelism in relational data base systems: architectural issues and design approaches

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$31 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

5 Author(s)
Pirahesh, H. ; IBM Almaden Res. Center, San Jose, CA, USA ; Mohan, C. ; Cheng, J. ; Liu, T.S.
more authors

The issues and solutions relation to intra-query parallelism in a relational DBMS (database management systems) supporting SQL 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 impact that parallelization of complex queries has on short transactions which have stringent response time constraints is discussed. The advantages and disadvantages of the shared nothing, shared disks and shared everything architectures for parallelism are enumerated. The impact of parallelism on a number of components of an industrial-strength DBMS are pointed out. The different stages of query processing during which parallelism may be gainfully used are identified. The interactions between parallelism and the traditional systems' pipelining technique are analyzed. Finally, the performance implications of parallelizing a specific complex query are studied. This gives a range of sample points for different parameters of a parallel system architecture, namely I/O and communication bandwidth as a function of aggregate MIPS (million instruction per second)

Published in:

Databases in Parallel and Distributed Systems, 1990, Proceedings. Second International Symposium on

Date of Conference:

2-4 Jul 1990