以快取機制來減低行動伺服器的查詢負載之研究

Reducing mobile server query loads by using a cache approach

王冠樺(Guan-Hua Wang)

指導教授 ： 王文彥

崑山科技大學/資訊科技學院/數位生活科技研究所/碩士(2012年)

摘要

無線網路、行動裝置及定位設備的發展下,使得越來越多人使用基 於位置的查詢以及服務,也對行動伺服器造成大量的服務查詢請求。 而使用者在某些習慣下往往會對伺服器發送相同的查詢,加重伺服器 負載。本研究目的為解決因為重複查詢而加重的伺服器負載問題,在 研究中主要使用快取機制並搭配排班方式,來解決因為重複查詢所形 成的伺服器負擔。研究中以沒有重複查詢與有重複查詢,兩組 SQL Query 查詢 來對行動伺服器做測試,結果顯示若在查詢重複的情況下, 使用快取機制能夠有效的加快系統的回應時間。

關鍵字

SQL ； Query ； 重複查詢 ； 行動快取

並列摘要

The development of wireless network、mobile device and positioning equipment makes more and more people query service by means of positioning. As a result, too many requests of service query place a huge load on the server. But the users often send the same query request to the server under some habits, which invisibly makes the server doing a lot of redundant work. This study aims at solving the load problem of server aggravated by the redundant queries. To settle the problem formed by redundant queries, the study uses the means of cache mechanism and scheduling way. The study tests the server by two groups of SQL Query query commands in which one has repetitive query and the other not. The result shows that using cache mechanism is able to accelerate the respond time of system if under the circumstance of repetitive query.

並列關鍵字

SQL ； Query ； repeat query ； mobile cache

參考文獻

[1] Lubbe, C., et al., “DiSCO: A Distributed Semantic Cache Overlay for Location-Based Services,” IEEE International Conference on Mobile Data Management, Vol.1, 2011, pp. 17-26

[3] Chung-Ming Huang, et al., “A Novel Cache Management Using Geographically Partial Matching for Location-Based Services,” IEEE International Conference on Advanced Information Networking and Applications, 2010, pp. 614-619

[6] Konstantinos Kakousis, Nearchos Paspallis and George Angelos Papadopoulos, “A survey of software adaptation in mobile and ubiquitous computing,” Vol.4, Issue 4, 2012, pp. 355-389

[7] Aamer Jaleel, et al., “High performance cache replacement using re-reference interval prediction (RRIP),” ACM SIGARCH Computer Architecture News, Vol.38, Issue 3, 2010, pp. 60-71

[8] Hao-peng Chen and Shao-chong Li, “A queueing-based model for performance management on cloud,” Advanced Information Management and Service (IMS), 2010 6th International Conference on, 2010, pp. 83-88