research-article

Geospatial stream query processing using Microsoft SQL Server StreamInsight

Editors: Elisa Bertino, Paolo Atzeni, Kian Lee Tan, Yi Chen, Y. C. Tay Authors:

Seyed Jalal Kazemitabar,

Ugur Demiryurek,

Mohamed Ali,

Afsin Akdogan,

Cyrus ShahabiAuthors Info & Claims

Proceedings of the VLDB Endowment, Volume 3, Issue 1-2

Pages 1537 - 1540

https://doi.org/10.14778/1920841.1921032

Published: 01 September 2010 Publication History

Get Access

Abstract

Microsoft SQL Server spatial libraries contain several components that handle geometrical and geographical data types. With advances in geo-sensing technologies, there has been an increasing demand for geospatial streaming applications. Microsoft SQL Server StreamInsight (StreamInsight, for brevity) is a platform for developing and deploying streaming applications that run continuous queries over high-rate streaming events. With its extensibility infrastructure, StreamInsight enables developers to integrate their domain expertise within the query pipeline in the form of user defined modules.

This demo utilizes the extensibility infrastructure in Microsoft StreamInsight to leverage its continuous query processing capabilities in two directions. The first direction integrates SQL spatial libraries into the continuous query pipeline of StreamInsight. StreamInsight provides a well-defined temporal model over incoming events while SQL spatial libraries cover the spatial properties of events to deliver a solution for spatiotemporal stream query processing. The second direction extends the system with an analytical refinement and prediction layer. This layer analyzes historical data that has been accumulated and summarized over the years to refine, smooth and adjust the current query output as well as predict the output in the near future. The demo scenario is based on transportation data in Los Angeles County.

References

[1]

R. S. Barga, J. Goldstein, M. Ali, and M. Hong. Consistent Streaming Through Time: A Vision for Event Stream Processing. In CIDR, 2007.

Google Scholar

[2]

M. Ali et al.: Microsoft CEP Server and Online Behavioral Targeting. In VLDB 2009.

Digital Library

Google Scholar

[3]

B. Chandramouli, J. Goldstein, and D. Maier. On-the-fly Progress Detection in Iterative Stream Queries. In VLDB, 2009.

Digital Library

Google Scholar

[4]

I. T. Jolliffe: Principal Component Analysis. Springer, second edition, October 2002.

Google Scholar

[5]

RIITS: http://www.riits.net. Last accessed in March, 2010

Google Scholar

[6]

SQL Server Spatial Libraries. http://www.microsoft.com/sqlserver/2008/en/us/spatial-data.aspx. Last accessed in March, 2010

Google Scholar

[7]

Open Geospatial Consortium. http://www.opengeospatial.org. Last accessed in March, 2010

Google Scholar

Cited By

View all

Ilarri STrillo-Lado R(2024)An approach for proactive mobile recommendations based on user-defined rulesExpert Systems with Applications: An International Journal10.1016/j.eswa.2023.122714242:COnline publication date: 16-May-2024
https://dl.acm.org/doi/10.1016/j.eswa.2023.122714
Manousis ACheng ZBasat RLiu ZSekar V(2022)Enabling efficient and general subpopulation analytics in multidimensional data streamsProceedings of the VLDB Endowment10.14778/3551793.355186715:11(3249-3262)Online publication date: 1-Jul-2022
https://dl.acm.org/doi/10.14778/3551793.3551867
Zeitler ERisch T(2020)Massive scale-out of expensive continuous queriesProceedings of the VLDB Endowment10.14778/3402707.34027524:11(1181-1188)Online publication date: 3-Jun-2020
https://dl.acm.org/doi/10.14778/3402707.3402752
Show More Cited By

Index Terms

Geospatial stream query processing using Microsoft SQL Server StreamInsight
1. Information systems
2. Theory of computation
  1. Theory and algorithms for application domains
    1. Database theory
      1. Database query processing and optimization (theory)

Index terms have been assigned to the content through auto-classification.

Recommendations

An introduction to Microsoft SQL server StreamInsight
COM.Geo '10: Proceedings of the 1st International Conference and Exhibition on Computing for Geospatial Research & Application

Microsoft StreamInsight is a powerful platform that you can use to develop and deploy complex event processing (CEP) applications. Its high-throughput stream processing architecture and the Microsoft .NET Framework-based development platform enable you ...
Microsoft framework for geospatial stream processing
IWGS '10: Proceedings of the ACM SIGSPATIAL International Workshop on GeoStreaming

Microsoft StreamInsight is a platform for developing and deploying streaming applications. StreamInsight embraces a temporal stream model to unify and further enrich query language features, handle imperfections in event delivery and define consistency ...
An extensible test framework for the Microsoft StreamInsight query processor
DBTest '10: Proceedings of the Third International Workshop on Testing Database Systems

Microsoft StreamInsight (StreamInsight, for brevity) is a platform for developing and deploying streaming applications. StreamInsight adopts a deterministic stream model that leverages a temporal algebra as the underlying basis for processing long-...

Comments

Information & Contributors

Information

Published In

cover image Proceedings of the VLDB Endowment

Proceedings of the VLDB Endowment Volume 3, Issue 1-2

September 2010

1658 pages

ISSN:2150-8097

Editors:
Elisa Bertino,
Paolo Atzeni,
Kian Lee Tan,
Yi Chen,
Y. C. Tay

Issue’s Table of Contents

Publisher

VLDB Endowment

Publication History

Published: 01 September 2010

Published in PVLDB Volume 3, Issue 1-2

Qualifiers

Research-article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

26
Total Citations
View Citations
291
Total Downloads

Downloads (Last 12 months)6
Downloads (Last 6 weeks)1

Reflects downloads up to 11 Sep 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Ilarri STrillo-Lado R(2024)An approach for proactive mobile recommendations based on user-defined rulesExpert Systems with Applications: An International Journal10.1016/j.eswa.2023.122714242:COnline publication date: 16-May-2024
https://dl.acm.org/doi/10.1016/j.eswa.2023.122714
Manousis ACheng ZBasat RLiu ZSekar V(2022)Enabling efficient and general subpopulation analytics in multidimensional data streamsProceedings of the VLDB Endowment10.14778/3551793.355186715:11(3249-3262)Online publication date: 1-Jul-2022
https://dl.acm.org/doi/10.14778/3551793.3551867
Zeitler ERisch T(2020)Massive scale-out of expensive continuous queriesProceedings of the VLDB Endowment10.14778/3402707.34027524:11(1181-1188)Online publication date: 3-Jun-2020
https://dl.acm.org/doi/10.14778/3402707.3402752
Theodorakis GKoliousis APietzuch PPirk HMaier DPottinger RDoan ATan WAlawini ANgo H(2020)LightSaber: Efficient Window Aggregation on Multi-core ProcessorsProceedings of the 2020 ACM SIGMOD International Conference on Management of Data10.1145/3318464.3389753(2505-2521)Online publication date: 11-Jun-2020
https://dl.acm.org/doi/10.1145/3318464.3389753
Patroumpas KPapadias S(2019)Trajectory-aware Load Adaption for Continuous Traffic AnalyticsProceedings of the 16th International Symposium on Spatial and Temporal Databases10.1145/3340964.3340967(70-79)Online publication date: 19-Aug-2019
https://dl.acm.org/doi/10.1145/3340964.3340967
Wang SZhong EZhou QCui XLu HYun WHu ZCai WLong L(2018)An Integrated Visual Analytics Framework for Spatiotemporal DataProceedings of the 1st ACM SIGSPATIAL Workshop on Advances on Resilient and Intelligent Cities10.1145/3284566.3284574(41-45)Online publication date: 6-Nov-2018
https://dl.acm.org/doi/10.1145/3284566.3284574
Brandt TGrawunder M(2018)GeoStreamsACM Computing Surveys10.1145/317784851:3(1-37)Online publication date: 23-May-2018
https://dl.acm.org/doi/10.1145/3177848
Fathy YBarnaghi PTafazolli R(2018)Large-Scale Indexing, Discovery, and Ranking for the Internet of Things (IoT)ACM Computing Surveys10.1145/315452551:2(1-53)Online publication date: 12-Mar-2018
https://dl.acm.org/doi/10.1145/3154525
Hendawi AShi YFattah HKarwa JAli MGal AWeidlich MKalogeraki VVenkasubramanian N(2016)RxSpatialProceedings of the 10th ACM International Conference on Distributed and Event-based Systems10.1145/2933267.2933293(366-367)Online publication date: 13-Jun-2016
https://dl.acm.org/doi/10.1145/2933267.2933293
Koliousis AWeidlich MFernandez RWolf ACosta PPietzuch PGal AWeidlich MKalogeraki VVenkasubramanian N(2016)The SABER system for window-based hybrid stream processing with GPGPUsProceedings of the 10th ACM International Conference on Distributed and Event-based Systems10.1145/2933267.2933291(354-357)Online publication date: 13-Jun-2016
https://dl.acm.org/doi/10.1145/2933267.2933291
Show More Cited By

View Options

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Cited By

Index Terms

Recommendations

An introduction to Microsoft SQL server StreamInsight

Microsoft framework for geospatial stream processing

An extensible test framework for the Microsoft StreamInsight query processor

Comments

Published In

Publisher

Publication History

Qualifiers

Other Metrics

Article Metrics

Other Metrics

Cited By

Login options

Full Access

PDF

eReader

Abstract

References

Cited By

Index Terms

Recommendations

An introduction to Microsoft SQL server StreamInsight

Microsoft framework for geospatial stream processing

An extensible test framework for the Microsoft StreamInsight query processor

Comments

Information

Published In

Publisher

Publication History

Qualifiers

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

Get Access

Login options

Full Access

View options

PDF

eReader

Figures

Other

Share

Share this Publication link

Share on social media

Affiliations