[go: up one dir, main page]
More Web Proxy on the site http://driver.im/ skip to main content
10.1145/2345316.2345339acmotherconferencesArticle/Chapter ViewAbstractPublication Pagescom-geoConference Proceedingsconference-collections
research-article

Retrieving large-scale high density video target tracks from spatial database

Published: 01 July 2012 Publication History

Abstract

With more and more live sensors being added to geospatial applications, huge amount of sensor data are generated and saved in spatial database. Managing and mining these large-scale ever-changing data becomes new challenges for geospatial studies. In this paper, we present an application-oriented case study to show how to retrieve target tracking data from big dataset saved in spatial database. Our video event retrieval system collects thirty days (8790 GB) high definition video data from six surveillance cameras, analyze them and extract roughly ten million video target tracks. These tracks are projected onto world coordinates and pumped into a spatial database. The system performance of inserting and retrieving these tracks is analyzed in terms of spatial data type design, spatial index configuration, online operation capacity, query optimization and scalability handling. Our insights of saving, managing and retrieving target tracks in a large-scale are presented.

References

[1]
H. Deng, M. Lee, A. Hakeem, O. Javed, W. Yin, L. Yu, A. Scanlon, Z. Rasheed, and N. Haering. Fast forensic video event retrieval using geospatial computing. Proceedings of the 1st International Conference and Exhibition on Computing for Geospatial Research and Application, july 2010.
[2]
Y. Fang, M. Friedman, G. Nair, M. Rys, and A. Schmid. Spatial indexing in microsoft sql server 2008. In Proceedings of the 2008 ACM SIGMOD international conference on Management of data, pages 1207--1216. ACM, ACM, 2008.
[3]
F. Giannotti, M. Nanni, F. Pinelli, and D. Pedreschi. Trajectory pattern mining. In Proceedings of the 13th ACM SIGKDD international conference on Knowledge discovery and data mining, pages 330--339. ACM, 2007.
[4]
A. Guttman. R-tree: A dynamic index structure for spatial searching. Proceedings of the ACM SIGMOD Conference, 1984.
[5]
H. Jeung, M. Yiu, X. Zhou, C. S. Jensen, and H. Shen. Discovery of convoys in trajectory databases. In PVLDB, pages 1068--1080, 2008.
[6]
D. Kalashnikov, S. Prabhakar, S. Hambrusch, and W. Aref. Efficient evaluation of continuous range queries on moving objects. In Proceedings of DEXA, pages 731--740, 2002.
[7]
K. Kim, S. K. Cha, and K. Kwon. Optimizing multidimensional index trees for main memory access. In Proceedings of the ACM SIGMOD Conference, pages 139--150, 2001.
[8]
A. Lipton, J. Clark, P. Brewer, P. Venetianer, and A. Chosak. Objectvideo forensics: Activity-based video indexing and retrieval for physical security applications. In Proceedings of the international conference on intelligent distributed surveilliance systems, pages 56--60. IEE, IEE, 2004.
[9]
N. Pelekis, E. Frentzos, N. Giatrakos, and Y. Theodoridis. Hermes: A trajectory db engine for mobility-centric applications. In International Journal of Knowledge-based Organizations, 2011.
[10]
D. Pfoser, C. S. Jensen, and Y. Theodoridis. Novel approaches to the indexing of moving object trajectories. In Proceedings of the 26th International Conference on Very Large Databases, 2000.
[11]
C. Shahabi. Spatial index structures. In infolab.usc.edu/csci585/Spring2006/Lectures/Session11-BW.pdf.
[12]
A. Velicanu and S. Olaru. Optimizing spatial databases. Informatica Economica, 14(2):61--71.
[13]
Y. Xia and S. Prabhakar. Q+rtree: efficient indexing for moving object databases. In Database Systems for Advanced Applications, pages 175--182, 2003.

Cited By

View all
  • (2020)Spatiotemporal retrieval of dynamic video object trajectories in geographical scenesTransactions in GIS10.1111/tgis.1269625:1(450-467)Online publication date: 20-Oct-2020
  • (2019)Integration of Multi-Camera Video Moving Objects and GISISPRS International Journal of Geo-Information10.3390/ijgi81205618:12(561)Online publication date: 7-Dec-2019
  • (2015)Video Data Model and Retrieval Service Framework Using Geographic InformationTransactions in GIS10.1111/tgis.1217520:5(701-717)Online publication date: 28-Dec-2015

Recommendations

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

cover image ACM Other conferences
COM.Geo '12: Proceedings of the 3rd International Conference on Computing for Geospatial Research and Applications
July 2012
212 pages
ISBN:9781450311137
DOI:10.1145/2345316
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 July 2012

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. large-scale spatial data retrieval
  2. spatial database
  3. spatial index
  4. video event search
  5. video surveillance

Qualifiers

  • Research-article

Conference

COM.Geo '12

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)4
  • Downloads (Last 6 weeks)0
Reflects downloads up to 01 Jan 2025

Other Metrics

Citations

Cited By

View all
  • (2020)Spatiotemporal retrieval of dynamic video object trajectories in geographical scenesTransactions in GIS10.1111/tgis.1269625:1(450-467)Online publication date: 20-Oct-2020
  • (2019)Integration of Multi-Camera Video Moving Objects and GISISPRS International Journal of Geo-Information10.3390/ijgi81205618:12(561)Online publication date: 7-Dec-2019
  • (2015)Video Data Model and Retrieval Service Framework Using Geographic InformationTransactions in GIS10.1111/tgis.1217520:5(701-717)Online publication date: 28-Dec-2015

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Media

Figures

Other

Tables

Share

Share

Share this Publication link

Share on social media