Browse > Article
http://dx.doi.org/10.6109/jkiice.2012.16.4.752

A Design and Implementation of Virtual Grid for Reducing Frequency of Continuous Query on LBSNS  

Lee, Eun-Sik (연세대학교 컴퓨터과학과)
Cho, Dae-Soo (동서대학교 컴퓨터정보공학부)
Abstract
SNS(Social Networking Services) is oneline service that enable users to construct human network through their relation on web, such as following relation, friend relation, and etc. Recently, owing to the advent of digital devices (smart phone, tablet PC) which embedded GPS some applications which provide services with spatial relevance and social relevance have been released. Such an online service is called LBSNS. It is required to use spatial filtering so as to build the LBSNS system that enable users to subscribe information of interesting area. For spatial filtering, user and tweet attaches location information which divide into static property presenting fixed area and dynamic property presenting user's area changed along the moving user. In the case of using a location information including dynamic property, Continuous query occurred from the moving user causes the problem in server. In this paper, we propose spatial filtering algorithm using Virtual Grid for reducing frequency of query, and conclude that frequency of query on using Virtual Grid is 93% decreased than frequency of query on not using Virtual Grid.
Keywords
LBSNS; Spatial Join; Spatial Filtering; PBSM; Materialized View; Virtual Grid;
Citations & Related Records
연도 인용수 순위
  • Reference
1 http://code.google.com/intl/ko-KR/android/add-ons/google-appiis/reference/index.html
2 Edwin H. Jacox, Hanan Samet "Spatial Join technique" ACM Transactions on Database Systems, 2007
3 Jignesh M. Patel, David J. Dewitt "Partition Based Spatial-Merge Join" ACM SIGMOD 1996
4 Ming-Ling Lo, Chinya V. Ravishankar "Spatial hash-joins" ACM SIGMOD 1996
5 http://ihelpers.x2soft.co.kr/programming/reference/01spring_materialized_view.pdf
6 Jose A Blakeley, Per-Ake Larson, Frank Wm Tompa "Efficiently Updating Materialized Views" ACM SIGMOD 1986
7 Ming-Ling Lo, Chinya V. Ravishankar "Spatial joins using Seeded Trees" ACM SIGMOD 1994
8 http://develpoper.android.com/index