Title :
Parallelism with IBM´s relational Database2 (DB2)
Author :
Haderle, Donald J.
Author_Institution :
IBM, San Jose, CA, USA
fDate :
Feb. 26 1990-March 2 1990
Abstract :
The current use of parallelism in the IBM Database2 (DB2) is discussed, along with future trends. Parallelism is necessary for relational database managers to achieve modern performance goals of high throughput for both homogeneous and heterogeneous workloads and fast response times for increasingly complex queries. A transaction appears to DB2 as a set of serially requested database operations using the Structured Query Languages (SQL). High throughput levels are achieved by multiprocessing. Multiprocessing levels in excess of a hundred are quite common. DB2 provides peer-to-peer communication, allowing applications on one DB2 computer system to access data on another DB2 computer system. That implementation is more favorable for ad hoc queries than for transactions. Parallelism plays a key role in DB2´s performance, where it is most visible in intertransaction multiprocessing to achieve high throughput and, to a lesser extent, in intraquery parallelism to reduce response time.<>
Keywords :
parallel processing; relational databases; DB2; IBM Database2; Structured Query Languages; fast response; high throughput; intertransaction multiprocessing; intraquery parallelism; parallelism; peer-to-peer communication; performance goals; relational database managers; transaction; Application software; Buffer storage; Cost function; Delay; Parallel processing; Peer to peer computing; Power system management; Relational databases; Throughput; Transaction databases;
Conference_Titel :
Compcon Spring '90. Intellectual Leverage. Digest of Papers. Thirty-Fifth IEEE Computer Society International Conference.
Conference_Location :
San Francisco, CA, USA
Print_ISBN :
0-8186-2028-5
DOI :
10.1109/CMPCON.1990.63728
