Community Research and Development Information Service - CORDIS

Simulation for distributed database design

TPsim is designed to simulate distributed database systems and on-line transaction processing (OLTP) systems, as used in large commercial or financial networks. Various parameters which describe the target system are defined by the user, as part of a simple high-level description of the system and its workload. This is then processed, to create and configure the simulation of the run-time environment.

TPsim is written in C, on top of a simulation support library and a description language parser. The description language provides a mechanism to describe performance-related characteristics of system nodes, storage devices and communication media; data file allocation across the network; and the service requirements of different classes of transaction programs and users. It uses a hierarchical interconnection model for the system, where nodes can be grouped into local area network (LAN)-based clusters, which in turn can be interconnected through a hierarchy of back-bone networks. The parser uses primitives from the support library to initialize the run-time environment for the simulation, as well as the configuration of the model system supplied by the user. The simulation driver then runs user-supplied routines which emulate the system under test. The whole package offers a complete simulation environment that includes configuration of the test system, execution of testing steps and automatic collection of test data. TPsim libraries cover transaction routing, central processing unit (CPU) scheduling, input/output (I/O) scheduling, concurrency control, buffer management and logging algorithms.

Reported by

Institute of Computer Science
Science and Technology Park Heraklion
71110 Crete
Follow us on: RSS Facebook Twitter YouTube Managed by the EU Publications Office Top