Pages

Wednesday 1 September 2021

Evaluation of Database Management

Accordingly, some of the analytical modeling methods for evaluating systems that are applicable for database systems are:

1. Queuing Models 

2. Cost Models 

3. Simulation Modelling 

4. Benchmarking 

1. Queuing Models: Queuing models are effective to study the dynamics of a database system when it is modeled as a multi-component system with resource allocation constraints and jobs moving around from one component to another.

Examples of such dynamic studies are concurrent transaction control algorithms, data allocation and management in distributed database systems etc. 

2. Cost Models: Cost Models are useful in studying the cost in terms of Physical storage and query processing time. The cost model gives some real insight into the actual physical structure and performance of a database system. 

3. Simulation Modelling: A simulation Modelling is more effective for obtaining better estimates since it not only analyses the database system in isolation but can effectively analyze the database system with the application program running on top of it and the database system itself operating within the constrained environment of an operating system on a real physical hardware.


4. Benchmarking: Benchmarking is the best method when multiple database systems need to be evaluated against each other but suffer from the inherent setback that it assumes all systems to be fully installed and operational. 

Benchmarking relies on the effectiveness of the synthetic workloads. Real workloads are non repeatable and hence not good for effective benchmarking.

No comments:

Post a Comment

Conflict Serializability

Find out conflict serializability for the given transactions T1 T2 T3 R(X)     ...