A high performance hybrid architecture for concurrent query execution

Kien A. Hua, Chiang Lee, Jih Kwon Peir

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

The most debated architectures for parallel database processing are shared nothing (SN) and shared everything (SE) structures. Although SN is considered to be most scalable, it is very sensitive to the data skew problem. On the other hand, SE allows the collaborating processors to share the work load more efficiently. It, however, suffers from the limitation of the memory and disk I/O bandwidth. The authors present a hybrid architecture in which SE clusters are interconnected through a communication network to form a SN structure at the inter-cluster level. Processing elements are clustered into SE systems to minimize the skew effect. Each cluster, however, is kept within the limitation of the memory and I/O technology to avoid the data access bottleneck. A generalized performance model was developed to perform sensitivity analysis for the hybrid structure, and to compare it against SE and SN organizations.

Original languageEnglish
Title of host publicationProceedings of the 2nd IEEE Symposium on Parallel and Distributed Processing 1990, SPDP 1990
PublisherInstitute of Electrical and Electronics Engineers Inc.
Pages348-351
Number of pages4
ISBN (Electronic)0818620870, 9780818620874
DOIs
Publication statusPublished - 1990 Jan 1
Event2nd IEEE Symposium on Parallel and Distributed Processing, SPDP 1990 - Dallas, United States
Duration: 1990 Dec 91990 Dec 13

Publication series

NameProceedings of the 2nd IEEE Symposium on Parallel and Distributed Processing 1990, SPDP 1990

Conference

Conference2nd IEEE Symposium on Parallel and Distributed Processing, SPDP 1990
Country/TerritoryUnited States
CityDallas
Period90-12-0990-12-13

All Science Journal Classification (ASJC) codes

  • Computer Networks and Communications
  • Hardware and Architecture

Fingerprint

Dive into the research topics of 'A high performance hybrid architecture for concurrent query execution'. Together they form a unique fingerprint.

Cite this