Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
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
  • Get Citation Alerts
  • 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

    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

    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

    Get Access

    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