#Number TR-PDS-1998-009 #Title Cooperative Caching for Financial Databases with Hot Spots #Author Aman Sinha Craig Chase Munir Cochinwala #Abstract We measure the performance of several cooperative caching policies for a database with hot spots. The workload consists of queries and append-only update transactions, and is modeled after a financial database of stock (historical) trading information. We show that cooperative caching is effective for this application. We show that selecting the correct set of peer servers when servicing a cache miss is crucial to achieving high performance, and we demonstrate a greedy algorithm that performs close to optimal for this workload. We also evaluate several cache replacement policies and show that a 2$^{nd}$-chance algorithm performs best. In a 2$^{nd}$-chance algorithm, replaced pages are transferred to a peer server rather than being discarded. When a page is selected for replacement a 2nd time, the page is discarded. Our results can be applied in the design of ``proxy'' servers for databases or web servers where a layer of proxy servers are used to scale the system performance. #Bib @InProceedings{, author = "Aman Sinha and Craig Chase and Munir Cochinwala", title = "Cooperative Caching for Financial Databases with Hot Spots" booktitle = "Technical Report", address = "Electrical and Computer Engineering, University of Texas at Austin", month = "June" year = "1998", note = "available via ftp or WWW at maple.ece.utexas.edu as technical report TR-PDS-1998-009" }