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.
[1]
Badrish Chandramouli,et al.
On-the-fly Progress Detection in Iterative Stream Queries
,
2009,
Proc. VLDB Endow..
[2]
I. Jolliffe.
Principal Component Analysis
,
2002
.
[3]
Jonathan Goldstein,et al.
Consistent Streaming Through Time: A Vision for Event Stream Processing
,
2006,
CIDR.
[4]
Ying Li,et al.
Microsoft CEP Server and Online Behavioral Targeting
,
2009,
Proc. VLDB Endow..