Previous [ 1] [ 2] [ 3] [ 4] [ 5] [ 6] [ 7] [ 8] [ 9] [ 10] [ 11] [ 12] [ 13] [ 14] [ 15] [ 16] [ 17] [ 18] [ 19] [ 20]

¡@

Journal of Information Science and Engineering, Vol. 23 No. 1, pp. 329-341 (January 2007)

Client's Cache Updating Using Idle Time of Clients in Relational Database Management Systems

Yasar-Guneri Sahin* and Halil-Ibrahim bulbul
*Department of Computer Engineering
Yasar University
Izmir, Turkey
E-mail: yasar.sahin@yasar.edu.tr
Department of Computer Education
Gazi University
Ankara, Turkey

Although multi-tiered software development is taking the place in database application environments, client-server infrastructure has still been in use for years. Furthermore, both infrastructures still need to be improved in some aspects. One of the important aspects of improvement is caching. This paper addresses the issue of caching in relational database system within client-server structure and a method that can be used to keep clients¡¦ cache up to date. The main objective of the proposed caching methods is to use clients¡¦ idle time in order that clients¡¦ cache is up-to-dated and to use the clients¡¦ memories for caching. For this purpose, a new combined system which includes CCDT (Clients Cache Description Table) for organizing client cache updating, predicate-based caching method MNTC (Maximum Number of Tuples in Cache) that includes a managerial patch in server-side and small patches in clients-side, and TPCF (Time Period calculated from client Commit Frequency) for calculation of idle time of the clients, is presented.

Keywords: caching algorithm, cache description, database caching, cached updating, client-server structure

Full Text (¥þ¤åÀÉ) Retrieve PDF document (200701_20.pdf)

Received February 14, 2006; revised July 28, 2006; accepted August 31, 2006.
Communicated by Ming-Syan Chen.