1. Distributed Database Management Model and Validation.
- Author
-
Tsuchiya, Masahiro, Mariani, Michael P., and Brom, James D.
- Subjects
- *
DATABASES , *DISTRIBUTED computing , *DATABASE design , *DATABASE management , *COMPUTER systems , *COMPUTER software , *SOFTWARE engineering - Abstract
This paper describes a simple yet effective distributed database model that simulates database usage and buffer management in the distributed data processing environment. The model is table driven such that database access requirements, file location, and other information defining the database environment are set up internally in several tables, and linked lists represent the directory and data blocks. Each database transaction is defined and represented by a transaction flow diagram (TED) and a sequence of TED's representing an operational scenario is input to the model. The model "executes" input TED's by looking up tables, and performs buffer management for directory and file data while logging history and gathering various statistics on database usage and buffer management. The performance data are used for database access overhead measurement, database workload characterization, and buffer allocation. Disk access frequency and response time are used to validate the simulation results. The model has been implemented in Fortran on the VAX 11/780 and has been used for both measuring the given database performance and analyzing sensitivity to design changes. The results have proven that, despite its simplicity, the database model presented is an effective systems engineering tool for the design of distributed databases. [ABSTRACT FROM AUTHOR]
- Published
- 1986