Design and Implementation of Advanced Traffic Monitoring System based on Integration of Data Stream Management System and Spatial DBMS

  • Xia, Ying (Chongqing University of Posts and Telecommunications(South-west JiaoTong University)) ;
  • Gan, Hongmei (Chongqing University of Posts and Telecommunications) ;
  • Kim, Gyoung-Bae (Computer Education Department of Seowon University)
  • Published : 2009.06.30

Abstract

The real-time traffic data is generated continuous and unbounded stream data type while intelligent transport system (ITS) needs to provide various and high quality services by combining with spatial information. Traditional database techniques in ITS has shortage for processing dynamic real-time stream data and static spatial data simultaneously. In this paper, we design and implement an advanced traffic monitoring system (ATMS) with the integration of existed data stream management system (DSMS) and spatial DBMS using IntraMap. Besides, the developed ATMS can deal with the stream data of DSMS, the trajectory data of relational DBMS, and the spatial data of SDBMS concurrently. The implemented ATMS supports historical and one time query, continuous query and combined query. Application programmer can develop various intelligent services such as moving trajectory tracking, k-nearest neighbor (KNN) query and dynamic intelligent navigation by using components of the ATMS.

Keywords

References

  1. Monahan, Torin. “War Rooms” of the Street: Surveillance Practices in Transportation Control Centers. The Communication Review 10 (4): pp.367-389, 2007. https://doi.org/10.1080/10714420701715456
  2. Kitagawa, H, Watanabe, Y. “Stream Data Management Based on Integration of a Stream Processing Engine and Databases,” NPCW2007, 2007.
  3. B. Babcock, S. Babu, M. Datar, R. Motwani, and J. Widom. “Models and issues in data streams,” PODS2002, 2002.
  4. Ralf Hartmut G?ting, An Introduction to Spatial Database Systems, VLDB Journal, vol.3, 1994.
  5. Bret Hull, Vladimir Bychkovsky, Yang Zhang, Kevin Chen, Michel Goraczko, Allen Miu, Eugene Shih, Hari Balakrishnan, and Samuel Madden. “CarTel: a distributed mobile sensor computing system,” SenSys2006, 2006.
  6. M. F. Mokbel, X. Xiong, M. A. Hammad, and W. G. Aref. “Continuous Query Processing of Spatio-temporal Data Streams in PLACE,” STDBM2004, 2004.
  7. T. Nadeem, S. Dashtinezhad, C. Liao, and L. Iftode. “Traffic View: A Scalable Traffic Monitoring System,” MDM2004, 2004.
  8. Yamada, S, Watanabe, Y,Kitagawa, H.; Amagasa, T. “Location-Based Information Delivery Using Stream Processing Engine Mobile Data Management,” MDM 2006, 2006.
  9. 한국공간정보통신, IntraMap, http://www.ksic.net/ksic/product/product_02.asp
  10. ESRI, http://www.esri.com
  11. MapInfo, http://www.mapinfo.com
  12. GEOMania, http://www.geomania.com
  13. SuperMap, http://www.supermap.com
  14. D. J. Abadi, et al. “The Design of the Borealis Stream Processing Engine,” CIDR2005, 2005.
  15. D. Abadi, D. Carney, U. Cetintemel, M. Cherniack, C. Convey, S. Lee, M. Stonebraker, N. Tatbul, and S. Zdonik. “Aurora: A New Model and Architecture for Data Stream Management,” VLDB Journal, vol. 12(2), August 2003.
  16. A. Arasu, B. Babcock, S. Babu, J. Cieslewicz, M. Datar, K. Ito, R. Motwani, U. Srivastava, and J. Widom. “STREAM: The Stanford Data Stream Management System,” 2004.
  17. M. A. Hammad, M. F. Mokbel, M. H. Ali, W. G. Aref, A. C. Catlin, A. K. Elmagarmid, M. Eltabakh, M. G. Elfeky, T. M. Ghanem, R. Gwadera, I. F. Ilyas, M. Marzouk, and X. Xiong. “Nile: A Query Processing Engine for Data Streams,” ICDE2004, 2004.
  18. P. Seshadri. “Predator: A resource for database research,” SIGMOD Record, 27(1):16-20, 1998.
  19. Jae-Syn Shin, Byeong-Seop You, Sang-Hun Eo, Dong-Wook Lee, Hae-Young Bae. “Data Stream Storing Techniques for Supporting Hybrid Query,” Journal of Korea Multimedia Society, Vol.10, No.11, 2007, pp.1384-1397.
  20. Don Landing, Mark Munson, Stephan Nadeau, Seth Landsman, Brigit Schroeder, Eddy Cheung, Virgil Zetterlind, Dan Potter. “Sensor Data Analysis Framework Research Roadmap,” MITRE technical report, 2006.
  21. Peng Chunhua, Yan Lei, Liu Jianye, Zheng Jianghua, He Lina. “The Theoretical Research on the New Car-Following Model for PARAMICS,” The Second Seminar of Intelligent Transportation System Forum, 2005.
  22. Yang Koo Lee, Keun Ho Ryu, “Historical Sensor Data Management using Temporal Information,” Journal of Korea Spatial Information System Society, Vol.10, No.4, 2008.
  23. Joung Joon Kim, Pan Gyu Kim, Dong Oh Kim, Ki Young Lee, Ki Joon Han, “Design and Implementaion of RTLS based on a Spatial DSMS,” Journal of Korea Spatial Information System Society, Vol.10, No.4, 2008.