Browse > Article
http://dx.doi.org/10.3745/KIPSTD.2005.12D.5.699

Design and Implementation of a SQL based Moving Object Query Process System for Controling Transportation Vehicle  

Jung, Young-Jin (충북대학교 대학원 전자계산학과)
Ryu, Keun-Ho (충북대학교 전기전자 및 컴퓨터공학부)
Publication Information
The KIPS Transactions:PartD / v.12D, no.5, 2005 , pp. 699-708 More about this Journal
Abstract
It becomes easy and generalized to track the cellular phone users and vehicles according to the Progress of wireless telecommunication, the spread of network, and the miniaturization of terminal devices. It has been constantly studied to provide location based services to furnish suitable services depending on the positions of customers. Various vehicle tracking and management systems are developed to utilize and manage the vehicle locations to relieve the congestion of traffic and to smooth transportation. However the designed previous work can not evaluated in real world, because most of previous work is only designed not implemented and it is developed for simple model to handle a point, a line, a polygon object. Therefore, we design a moving object query language and implement a vehicle management system to search the positions and trajectories of vehicles and to analyze the cost of transportation effectively. The designed query language based on a SQL can be utilized to get the trajectories between two specific places, the departure time, the arrival time of vehicles, and the predicted uncertainty positions, etc. In addition, the proposed moving object query language for managing transportation vehicles is useful to analyze the cost of trajectories in a variety of moving object management system containing transportation.
Keywords
Spatio-temporal Database; Moving Object Query Language; GIS; Vehicle Tracking System; Moving Objects;
Citations & Related Records
Times Cited By KSCI : 1  (Citation Analysis)
연도 인용수 순위
1 Martin Erwig, Markus Schneider, 'STQL : A Spatio-Temporal Query Language,' Chapter 6 of Mining Spatio-Temporal Information Systems, Kluwer Academic Publishers, pp. 105-126, 2002
2 Luca Forlizzi, Ralf Hartmut Guting, Enrico Nardelli, and Markus Schneider, 'A Data Model and Data Structures for Moving Objects Databases,' Proc. ACM SIGMOD Conf., Dallas, Texas, pp.319-330, 2000   DOI   ScienceOn
3 김경숙, 권오제, 변희영, 조대수, 김태완, 이기준, '이동객체를 위한 질의처리 컴포넌트의 설계 및 구현,' 개방형 지리정보 시스템학회 논문지 6권, 1호, pp.31-50, 2004년 6월   과학기술학회마을
4 H. Zhu, J. Su, and O. Ibarra. 'Trajectory Queries and Octagons in Moving Object Databases,' Proceedings of the ACM Cunference on Information and Knowledge Management (CIKM), McLean, VA, pp.413-421, November, 2002
5 이현아, 이혜진, 김동호, 김진석, '이동체 관리 시스템을 위한 이동체 질의어 설계,' 정보과학회 2003년 추계학술대회, Vol.30 No.2-2, pp.148-150, 2003년 10월
6 O. Wolfson, S. Chamberlain, A.P. Sstla, B. Xu, J. Zhou, 'DOMINO : Databases fOr MovINg Objects tracking,' Proc. ACM SIGMOD, p.547-549, 1999   DOI
7 K. H. Ryu, and Y. A. Ahn, 'Application of Moving Objects and Spatiotemporal Reasoning', Time Center TR-58, 2001
8 H. Mokhtar, J. Su, and O. Ibarra. 'On Moving Object Queries,' Proceedings of the 21st ACM SIGACTSIGMOD-SIGART Symposium on Principles of Database Systems (PODS). Madison, WI, pp.188-198, June, 2002
9 H. M. O. Mokhtar and J. Su. 'A Query Language for Moving Object Trajectories,' Proceedings of the International Scientific and Statistical Database Management Conference, June, 2005
10 H. Mokhtar and J. Su. 'Universal Trajectory Queries for Moving Object Databases,' Proceedings of IEEE International Conference on Mobile Data Management, Berkeley, CA, January, 2004   DOI
11 Martin Erwig, 'Design of Spatio-Temporal Query Languages,' NSF/BDEI Workshop on Spatio-Temporal Data Models of Biogeophysical Fields for Ecological Forecasting, 2002
12 Martin Erwig, Ralf Hartmut Guting, Markus Schneider and Michalis Vazirgiannis, 'Spatio-Temporal Data Types: An Approach to Modeling and Querying Moving Object in Databases,' CHOROCHRONOS Technical Report CH-97-08, December, 1997
13 J Su, H. Xu, and O. Ibarra, 'objects: Logical relationships and queries,' Proc. SSTD. pp.3-19, 2001
14 Cindy Xinmin Chen, Carlo Zaniolo, 'SQLST: A SpatioTemporal Data Model and Query Language,' Proc. ER 2000, pp.96-111, 2000
15 Dieter Pfoser, Christian S. Jensen, and Yannis Theodoridis, 'Novel Approaches in Query Processing for Moving Objects,' CHOROCHRONOS Technical Report CH-00-3, February, 2000
16 Y. J. Jung, D. G. Lee, K. H. Ryu, 'A Transportation Management System to Support Plentiful Vehicle Position Data Insertion,' ASGIS, pp.144-151, 2005
17 Y. J. Jung, K. H. Ryu, 'A Group Based Insert Manner for Storing Enormous Data Rapidly in Intelligent Transportation System,' ICIC2005, pp.296-305, August, 2005
18 Ralf Hartmut Guting, Michael H. Bohlen. Martin Erwig, Christian S. Jensen, Nikos A. Lorentzos, Markus Schneider, and Michalis Vazirgiannis, 'A Foundation for Representing and Querying Moving Objects,' ACM Transactions on Database Systems, Vol. 25, No.1, pp.1-42, March, 2000   DOI   ScienceOn
19 Y. J. Jung, E. J. Lee, K. H. Ryu, 'MP-tree: An Index Approach for Moving Objects in Mobile Environment,' ASGIS, pp.104-111, 2003
20 C. Hage C. S. Jensen T. B. Pedersen L. Speicys I. Timko, 'Integrated Data Management for Mobile Services in the Real World.' VLDB 2003, pp.1019-1030, 2003