Browse > Article

Storing and Querying Trajectory Information on PostgreSQL/PostGIS  

Yang, Pyoung-Woo (군산대학교 컴퓨터정보공학과)
Lee, Yong-Mi (충북대학교 컴퓨터과학과)
Lee, Yon-Sik (군산대학교 컴퓨터정보공학과)
Nam, Kwang-Woo (군산대학교 컴퓨터정보공학과)
Publication Information
Spatial Information Research / v.19, no.2, 2011 , pp. 57-64 More about this Journal
Abstract
This paper describes how to storing and querying trajectory information on PostgreSQL/PostGIS. Recently as technology of mobile devices is advancing, many researches for location-based services and moving object's trajectory have been studied. Trajectory is the set of information of the location by the time, and is one of the most im portant information for location-based services. Traditional spatial database systems do not support trajectory data types and functions. In this paper, we propose a trajectory data type and query functions for moving objects on PostgreSQL/PostGIS.
Keywords
PostgreSQL; Moving Object; Trajectory Management; Location Based Service;
Citations & Related Records
Times Cited By KSCI : 2  (Citation Analysis)
연도 인용수 순위
1 김경숙, 권오제, 변희영, 조대수, 김태완, 이기준, 2004, "이동객체를 위한 질의처리 컴포넌트의 설계 및 구현", 개방형 GIS학회 논문지, 제6권 1호, pp 31-50.
2 박장유, 남광우, 진희채, 2009, "u-GIS 콘텐츠를 위한 GeoPhoto 콘텐츠 언어의 설계," 한국공간정보시스템학회 논문지 v.11, no. 1, pp. 35-42.
3 임복자, 김경숙, 남광우, 이기준, 2003, "이동객체 컴포넌트 설계 및 구현," 한국GIS학회 2003년도 공동 춘계 학술대회 논문집, pp. 201-207.
4 O. Wolfson, A.P. Sistla, B. Xu, S.J. Zhou, S. Chamberlain, 1999, "DOMINO: databases for moving objects tracking," Proceedings of the SIGMOD International Conference on Management of Data, pp. 547-549.
5 김경숙, 임복자, 남광우, 이기준, 2000, "이동객체 컴포넌트 설계 및 구현", 데이터베이스 연구, 제18권 제 4호, pp. 33-41.
6 R. H. Guting, M. H. Bohlen, M. Erwig, C. S. Jensen, N. A. Lorentzos, M. Schneider, M. Vazirgiannis, 2000, "A Foundation for Representing and Querying Moving Objects," ACM Transactions on Database Systems, vol. 25, 1-42.   DOI   ScienceOn
7 R. H. Guting, M. Schneider, 2005, "Moving Object Databases," Morgan Kaufmann Publishers, CA.
8 E. Frentzos, K. Gratsias, Y. Theodoridis, 2007, "Index-based Most Similar Trajectory Search." Proceedings of ICDE, pp. 816-825.
9 N. Pelekis, Y. Theodoridis, S. Vosinakis, T. Panayiotopoulos, 2006, "Hermes - A Framework for Location-Based Data Management," Proceedings of EDBT, vol 3896/2006, pp. 1130- 1134.
10 N. Pelekis, E. Frentzos, N. Giatrakos, Y. Theodoridis, 2008, "HERMES: Aggregative LBS via a Trajectory DB Engine," Proc. SIGMOD,
11 M. Erwing, R. H. Guting, M. Schneider, M. Vazirgiannis, 1999, "Spatio-Temporal Data Type: An Approach to Modeling and Querying Moving Object in Databases," GeoInformatica 3(3), pp. 269-296.   DOI   ScienceOn
12 M. Erwig, M. S chneider, 1999, "Developments in Spatio-Temporal Query Languages," Proc. IEEE Int'l Workshop Spatio-Temporal Data Models and Languages, pp. 441-449.
13 T. Abraham, J. F. Roddick. 1999, "Survey of Spatio-Temporal Databases," GeoInformatica 3(1), pp. 61-99.   DOI   ScienceOn
14 T. Brinkhoff, 2000, "Generating Network-Based Moving Object.," Proceedings of the 12th international conference on Scientific and Statistical Database Management, pp. 253-255.
15 E. Frentzos, K. Gratsias, N. Pelekis, Y. Theodoridis, 2007, "Algorithms for Nearest Neighbor Search on Moving Object Trajec- tories," Geoinformatica, vol. 11, pp. 159-193.   DOI   ScienceOn
16 E. Frentzos, K. Gratsias, Y. Theodoridis, 2007, "Towards theNext Generation of Locationbased Services." Proceedings of W2GIS, 2007.
17 L. Forlizz, R. H Guting, E. Nardelli and M. Schneider, 2000, "A Data Model and Data Structures for Moving Object Databases," Proc. ACM SIGMOD, pp.319-330.