DB Facade: A Web Cache with Improved Data Freshness

Author

Qin, Xiongpai ; Zhou, Xiaoyun

Author_Institution

Key Lab. of Data Eng. & Knowledge Eng., Renmin Univ. of China, Beijing, China

Volume

2

fYear

2009

fDate

22-24 May 2009

Firstpage

483

Lastpage

487

Abstract

Traditional Web database cache techniques have a major disadvantage, namely poor data freshness, because they employ an asynchronous data refresh strategy. A novel Web database cache, DB Facade, is proposed in this paper. DB Facade uses a main memory database to cache result sets of previous queries for subsequent reusing. Updates on backend database system are managed by delta tables, and then propagated to Web database cache in a near real-time manner, hence guarantee the freshness of data. DB Facade off loads query burden from backend database systems, and exploits the power of main memory database system to boost query performance. TPC-W testing result shows that the system´s performance increases by about 17 percent.

Keywords

Internet; cache storage; DB facade; Web database cache; asynchronous data refresh strategy; backend database system; data freshness; delta table; main memory database; subsequent reuse; Assembly systems; Data engineering; Data security; Database systems; Electronic commerce; Information security; Laboratories; System testing; Web pages; Web server; TPC-W; main memory database; web cache;

fLanguage

English

Publisher

ieee

Conference_Titel

Electronic Commerce and Security, 2009. ISECS '09. Second International Symposium on

Conference_Location

Nanchang

Print_ISBN

978-0-7695-3643-9

Type

conf

DOI

10.1109/ISECS.2009.236

Filename

5209786