Consistency and Performance of Concurrent Interactive Database Applications

Consistency and Performance of Concurrent Interactive Database Applications

Title : Consistency and Performance of Concurrent Interactive Database Applications
Authors :
Baras, John S.
Roussopoulos, Nick
Kelley, Steve
Stathatos, Kostas
Conference : 12th IEEE International Conference of Data Engineering pp. 602-609
Date: February 26 - March 01, 1996

 In many modern database applications, there is an emerging need for interactive environments where users directly manipulate the contents of the database. Graphical user interfaces (GUis) display images of the database which must reflect a consistent up-to-date state of the data with minimum perceivable delay to the user. Moreover, the possibility of several appli­cations concurrently displaying different views of the same database increases the overall system complex­ity. In this paper, we show how design, performance and concurrency issues can be addressed by adapting existing database techniques. We propose the use of suitable display schemas whose instances compose ac­tive views of the database, an extended client caching scheme which is expected to yield significant perfor­mance benefits and a locking mechanism that main­tains consistency between the GU Is and the database.

Download Full Paper