Modeling and simulation of LAN DBMS performance

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.

REFERENCES

• 1: Philip A. Bernstein , Vassco Hadzilacos , Nathan Goodman, Concurrency control and recovery in database systems, Addison-Wesley Longman Publishing Co., Inc., Boston, MA, 1987
• 2: Hills, D.A. 1987. "Database servers - just like your friendly librarian." LAN TIMES, October, 45-50.
• 3: Hills, D.A. 1987. "More about database performance factors." LAN TIMES, November, 56- 68.
• 4: Charles H. Sauer , Edward A. MacNair, Simulation of Computer Communication Systems, Prentice Hall Professional Technical Reference, 1983
• 5: Smith, B.A. 1987. "Unlike most data managers, SoftCraft's Btrleve lets Drogrammers work In their favorite language. Xtrieve adds query and report capabilities to the package." PC TECH JOURNAL, October, 105-121.
• 6: UIIman, J.D. 1982. Principles of Database Systems. Second Edition. Computer Science Press, Rockvllle, Maryland.
• 7: G. Weiderhold, File organization for database design, McGraw-Hill, Inc., New York, NY, 1987

INDEX TERMS

Primary Classification:
  I. Computing Methodologies
  I.6 SIMULATION AND MODELING

Additional Classification:
  D. Software
  D.4 OPERATING SYSTEMS

  H. Information Systems
  H.3 INFORMATION STORAGE AND RETRIEVAL
      H.3.4 Systems and Software
          Subjects: Performance evaluation (efficiency and effectiveness)

  I. Computing Methodologies
  I.6 SIMULATION AND MODELING
      I.6.8 Types of Simulation
          Subjects: Distributed

General Terms:
Design, Management, Measurement, Performance, Theory