Transaction Management in Distributed Scheduling Environment for High Performance Database Applications

Abstract

Synchronising the access of data has always been an issue in any data-centric application. The problem of synchronisation increases many folds, as the nature of application becomes distributed or volume of data approaches to terabyte sizes. Though high performance database systems like distributed and parallel database systems distribute data to different sites, most of the systems tend to nominate a single node to manage all relevant information about a resource and its lock. Thus transaction management becomes a daunting task for large databases in centralized scheduler environment. In this paper we propose a distributed scheduling strategy that uses a distributed lock table and compares the performance with centralized scheduler strategy. Performance evaluation clearly shows that multi-scheduler approach outperforms global lock table concept under heavy workload conditions.