skip to main content
10.1145/1878500.1878508acmconferencesArticle/Chapter ViewAbstractPublication PagesgisConference Proceedingsconference-collections
research-article

AIMS: an SQL-based system for airspace monitoring

Published: 02 November 2010 Publication History

Abstract

In this paper, we present the "Airspace Monitoring System" (AIMS) for monitoring and analyzing flight data streams with respect to the occurrence of arbitrary complex events. In contrast to already existing tools which often focus on a single task like flight delay detection, we want to provide a more general system that allows for a comprehensive analysis of aircraft movements. This includes, e.g., the detection of critical deviations from the current flight plan, abnormal approach parameters of landing flights as well as areas with an increased risk of collisions. To this end, tracks are extracted from cluttered radar data and SQL views are employed for a timely processing of these tracks.
Our general aim is to show that conventional relational database technology is capable of dealing with data streams of remarkably high complexity and frequency.

References

[1]
AirNav Systems: http://www.airnavsystems.com/(2010)
[2]
A. Arasu, B. Babcock, S. Babu, M. Datar, K. Ito, I. Nishizawa, J. Rosenstein, and J. Widom: STREAM: The Stanford Stream Data Manager. SIGMOD 2003: 665.
[3]
A. Arasu, S. Babu, and J. Widom: The CQL Continuous Query Language: Semantic Foundations and Query Execution. VLDB J. 15(2): 121--142 (2006).
[4]
D. J. Abadi et al.: Aurora: A Data Stream Management System. SIGMOD 2003: 666.
[5]
D. J. Abadi, W. Lindner, S. Madden, and J. Schuler: An Integration Framework for Sensor Networks and Data Stream Management Systems. VLDB 2004, 1361--1364.
[6]
B. Babcock, S. Babu, M. Datar, R. Motwani, and J. Widom: Models and Issues in Data Stream Systems. PODS 2002: 1--16.
[7]
A. Behrend, C. Dorau, R. Manthey, and G. Schüller: Incremental view-based Analysis of Stock Market Data Streams. IDEAS 2008: 269--275.
[8]
A. Behrend, R. Manthey, G. Schüller, and Monika Wieneke: Detecting Moving Objects in Noisy Radar Data Using a Relational Database. ADBIS 2009: 286--300
[9]
S. S. Blackmann and R. Populi: Design and Analysis of Modern Tracking Systems. Artech House, Boston, USA, 1999.
[10]
Bundesstelle für Flugunfalluntersuchung: Investigation Report AX001-1-2/02, May 2004.
[11]
D. Chatziantoniou, Y. Sotiropoulos: Stream Variables: A Quick but not Dirty SQL Extension for Continuous Queries. ICDE Workshops 2007: 19--2.
[12]
Eurocontrol: Mode S EHS - Requirements for the Carriage and Operation of Mode S Transponders, 2010. http://www.eurocontrol.int/msa/public/_standard_page/nv_germany.html (2010) {Online; Last validation 01/03/2010}.
[13]
FLIGHTSTATS: http://www.flightstats.com/(2010)
[14]
FlightView: http://www.airnavsystems.com/(2010)
[15]
A. Gupta, I. S. Mumick: Materialized Views: Techniques, Implementations, and Applications. The MIT Press (1999)?
[16]
L. Golab, M. T. Özsu: Issues in Data Stream Management. SIGMOD Record 32(2): 5--14 (2003)
[17]
A. Hoppe, J. Gryz: Stream Processing in a Relational Database: A Case Study. IDEAS 2007: 216--224.
[18]
G. Van Keuk: MHT Extraction and Track Maintenance of a Target Formation. IEEE Transactions on Aerospace and Electronic Systems 38(1):288--295 (2002).
[19]
W. Koch: Exact Update Formulae for Distributed Kalman Filtering and Retrodiction at Arbitrary Communication Rates. FUSION 2009: 2209--2216.
[20]
A. Logothetis, V. Krishnamurthy, and J. Holst: A Bayesian EM Algorithm for Optimal Tracking of a Maneuvering Target in Clutter. Journal of Signal Processing 82(2), 473--490 (2002)
[21]
S. Madden, M. J. Franklin: Fjording the Stream: An Architecture for Queries Over Streaming Sensor Data. ICDE 2002: 555--566.
[22]
OpenATC - Open Air Traffic Control: http://www.openatc.com (2010)
[23]
M. I. Skolnik: Introduction to Radar Systems. McGraw-Hill, 1981.
[24]
M. Stonebraker, U. Ç etintemel: "One Size Fits All": An Idea Whose Time Has Come and Gone (Abstract). ICDE 2005: 2--11.
[25]
H. Wang, C. Zaniolo, and C. Luo: ATLAS: A Small but Complete SQL Extension for Data Mining and Data Streams VLDB 2003: 1113--1116.
[26]
M. Wieneke, W. Koch: On Sequential Track Extraction within the PMHT Framework. EURASIP Journal on Advances in Signal Processing, 1--13 (2008).

Cited By

View all

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
IWGS '10: Proceedings of the ACM SIGSPATIAL International Workshop on GeoStreaming
November 2010
67 pages
ISBN:9781450304313
DOI:10.1145/1878500
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]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 02 November 2010

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. CEP
  2. geospatial data streams
  3. monitoring
  4. sensor data

Qualifiers

  • Research-article

Conference

GIS '10
Sponsor:

Acceptance Rates

Overall Acceptance Rate 7 of 9 submissions, 78%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)10
  • Downloads (Last 6 weeks)1
Reflects downloads up to 19 Feb 2025

Other Metrics

Citations

Cited By

View all
  • (2025)Indexing temporal relations for range-duration queriesDistributed and Parallel Databases10.1007/s10619-024-07452-643:1Online publication date: 9-Jan-2025
  • (2019)Period IndexProceedings of the 16th International Symposium on Spatial and Temporal Databases10.1145/3340964.3340965(100-109)Online publication date: 19-Aug-2019
  • (2018)GeoStreamsACM Computing Surveys10.1145/317784851:3(1-37)Online publication date: 23-May-2018
  • (2015)Temporal State Management for Supporting the Real-Time Analysis of Clinical DataNew Trends in Database and Information Systems II10.1007/978-3-319-10518-5_13(159-170)Online publication date: 2015
  • (2014)A case study in optimizing continuous queries using the magic update techniqueProceedings of the 26th International Conference on Scientific and Statistical Database Management10.1145/2618243.2618285(1-4)Online publication date: 30-Jun-2014
  • (2012)AIMSProceedings of the 24th international conference on Scientific and Statistical Database Management10.1007/978-3-642-31235-9_47(622-627)Online publication date: 25-Jun-2012
  • (2011)In-memory caching for fast stream history accessProceedings of the 2nd ACM SIGSPATIAL International Workshop on GeoStreaming10.1145/2064959.2064968(37-40)Online publication date: 1-Nov-2011

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media