Design issues of an efficient distributed database scheduler for telecom

We optimize the speed of real-time databases by optimizing the scheduler. The performance of a database is directly linked to the environment it operates in, and we use environment characteristics as guidelines for the optimization. A typical telecom environment is investigated, and characteristics that are relevant to performance are derived. A theoretical study of database scheduler performance is combined with the characteristics of the telecom environment. Design issues are extracted from this combination. It turns out that the scheduler overhead, rather than the concurrency is the most important factor in database performance. With the derived issues in mind, a light-weight optimistic concurrency control (OCC-light) scheduler has been designed. The OCC-light is implemented in the Mnesia database. Experiments were conducted to compare OCC-light against the existing two phase locking (2PL) scheduler. The OCC-light compared favorably to 2PL, as was already suggested by our theoretical study