FIVE: A Real Time Commit Protocol

In recent years, numerous commit protocols have been proposed for the lending of prepared data to the borrower in its commit phase to overcome the problem of data inaccessibility, but few of these considered the fruitful borrowing of this data. In this paper we have proposed a new commit protocol for distributed real time database systems (DRTDBS) by investigating lenderborrower relation in detail and also considered such systems which have combination of many non-healthy borrowers and super-healthy borrowers. Fruitful lending of Incredible Value added data without Extending abort chain (FIVE), which considered all types of borrowers and lend the data in a fruitful way and solve the problem of higher kill percentage of transactions and we categorized the borrower cohorts as commit and abort dependent. Further, the commit dependent borrowers can lend data to executing cohorts with still limiting the transaction abort chain to one only and reducing the data inaccessibility. This minimizes the fruitless borrowing by the cohort. The performance of FIVE is compared with ACTIVE, PROMPT, 2SC and SWIFT protocols for both main memory resident and disk resident databases without communication delay for the soft real time distributed transactions.