Performance considerations of embedded computations in distributed databases

Abstract

In many applications using database systems, the conventional method of transaction processing can not be used. This is on account of lack of integration and existence of centralized solutions. Such situations exist within heterogeneous systems, mobile database transactions and time-critical applications requiring admission on priority for a select group of transactions. For example, in conventional methods, the deadlock detection is based on use of delay to cause and watch deadlocks. It generates many difficulties, such as, (a) high overheads of periodic checking (b) Non-deterministic nature of the delays, and (c) difficulties to scale-up the centralized solutions. The existing proposal lacks in local processing for distributed transactions. The proposed technique uses normal message communication among peers. The proposal leads to enhanced role for resource sites. The proposal introduces asynchronous operations in transaction processing. As a result the detection processes do not wait for occurrences of time-outs delays. In most cases the technique eliminates the possibility of occurrence of waiting delays.