Buffer Management in Real-Time Databases

  • Authors:
  • Jiandong Huang;John A. Stankovic

  • Affiliations:
  • -;-

  • Venue:
  • Buffer Management in Real-Time Databases
  • Year:
  • 1990

Quantified Score

Hi-index 0.00

Visualization

Abstract

Buffer management plays a very important role in database systems. But little work has been done to study buffer management in real-time database systems. In this work, we propose and eval- uate algorithms for real-time oriented buffer allocation and buffer replacement based on the existing organization of a real-time database testbed. Our goal is to increase the percentage of transactions meeting their deadlines. The experimental results obtained from the testbed indicate that under two-phase locking, the real-time oriented buffer management schemes do not significantly improve system performance; rather, other integrated processing components such as conflict resolution and CPU scheduling play a more important role in the system. We have shown that data contention is a constraint on the performance improvement of buffer management. Under data contention, conflict resolution becomes a key factor in real-time transaction processing. In addition, CPU scheduling is more important than buffer allocation, even if the system is not CPU bound. We discuss reasons for these results and give suggestions as to where and how real-time buffer management may improve real-time transaction performance.