Performance analysis of remote database access

Author

Krishnamurthy, Prabhakar

Author_Institution

Bell Commun. Res., Piscataway, NJ, USA

Volume

i

fYear

1990

fDate

2-5 Jan 1990

Firstpage

337

Abstract

A methodology is proposed for performance benchmarking of remote database access, where applications running on one or more front-end machines access a database on a back-end machine. The resource utilization approach is used as in the multiuser Wisconsin benchmark suite, to characterize application programs. Three kinds of resources are considered: front-end CPU/IO resource (used mostly for data processing), communication bandwidth (for exchanging queries and data between the front ends and the back end), and the back-end CPU/IO resource (used mostly for database access). Application programs are considered as using all three kinds of resources. Throughput and response times are measured for each application program type. The results of running the benchmark on a number of configurations are also presented

Keywords

database management systems; information retrieval systems; performance evaluation; application programs; back-end machine; communication bandwidth; front-end machines; multiuser Wisconsin benchmark suite; performance benchmarking; queries; remote database access; response times; throughput; Application software; Bandwidth; Data processing; Database systems; Delay; Local area networks; Modems; Performance analysis; Resource management; Throughput;

fLanguage

English

Publisher

ieee

Conference_Titel

System Sciences, 1990., Proceedings of the Twenty-Third Annual Hawaii International Conference on

Conference_Location

Kailua-Kona, HI

Type

conf

DOI

10.1109/HICSS.1990.205133

Filename

205133