Performance prototyping of data management applications

ABSTRACT

This paper describes the construction of a performance model or prototype of a proposed data base management system (DBMS) application by the application of certain techniques from the performance measurement and data base management disciplines. Performance measurement is conducted by using a “drive” workload that initiates the “real” workload with reasonable fidelity. The “drive” workload is constructed in terms of data base variable primitives, which are “inverted” to performance variable primitives in order to construct a resource-based drive workload. The application of this drive workload to a simulation model is illustrated, showing the use of the methodology to “tune” important DBMS, Operating System and application program parameters.

REFERENCES

• 1: Kenneth F. Siler, A stochastic evaluation model for database organizations in data retrieval systems, Communications of the ACM, v.19 n.2, p.84-95, Feb. 1976 [doi>10.1145/359997.360010]
• 2: W. C. McGee, File-level operations on network data structures, Proceedings of the 1975 ACM SIGMOD international conference on Management of data, May 14-16, 1975, San Jose, California [doi>10.1145/500080.500085]
• 3: CODASYL Data Description Language Committee, Journal of Development, June, 1973.
• 4: P. Gregor, et.al., Performance Evaluation of the System 2000 Data Management System, The MITRE Corporation Technical Report, MTR-4583, June, 1975.
• 5: K. Sreenivasan , A. J. Kleinman, On the construction of a representative synthetic workload, Communications of the ACM, v.17 n.3, p.127-133, March 1974 [doi>10.1145/360860.360863]
• 6: S. Rothman, EXEC-8 Modifications for Improved Throughput on the UNIVAC 1110 at NASA/JSC, The MITRE Corporation Technical Report, MTR-4571, August, 1974.

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.8 Database applications

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

General Terms:
Management, Measurement, Performance