Modeling and simulation of LAN DBMS performance

  • Authors:
  • Paul Lieh-san Lin

  • Affiliations:
  • Department of Computer Science, Western Illinois University, Macomb. IL

  • Venue:
  • ANSS '89 Proceedings of the 22nd annual symposium on Simulation
  • Year:
  • 1989

Quantified Score

Hi-index 0.00

Visualization

Abstract

Which is better: the personal computer-oriented distributed processing DBMS such as dBase III Plus and R:Base System V or the minicomputer-like back-end DBMS such as LANserver and Oracle? This is a question of importance to LAN DBMS administrators and users. In this study, the architecture of a database server and that of a distributed processing DBMS are modeled and simulated under conditions where workstations on a LAN request complicated queries that require large join operations to take place; queries that require the examination of data files; and simple queries that only require the processing of small index files. The performance parameters examined in this study include CPU speed, LAN throughput, disk seek time, disk latency, disk data transfer rate and query arrival rate.