Abstract
In this paper we study the evaluation of continuous constraint queries (CCQs) for spatiotemporal streams. A CCQ triggers an alert whenever a configuration of constraints between streaming events in space and time are satisfied. Consider, for instance, a server that receives updates from GPS-enabled agents that report their positions and other measurements (e.g., environmental readings). An example of CCQ is: “Alert whenever at least 5 readings closer than 5km to each other and within a time difference of 5 minutes report high pressures and low temperatures”. We model CCQs as Constraint Satisfaction Problems (CSPs) and develop solutions for their continuous evaluation. Our techniques (1) consider the fast arrival rate of incoming events, and (2) minimize the memory requirements, without using predefined window constraints, but by utilizing the structure of the queries. In order to show the merits of the proposed techniques, we implement a system prototype and evaluate it with real data.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
CCQ system prototype, http://www.cs.ucr.edu/~marioh/ccq
AOML. Global Drifter Center, http://www.aoml.noaa.gov/phod/dac/gdc.html
Bessière, C., Régin, J.C.: Refining the basic constraint propagation algorithm. In: Proc. of the International Joint Conference on Artificial Intelligence (IJCAI), pp. 309–315 (2001)
Bitner, J.R., Reingold, E.: Backtracking programming techniques. Communications of the ACM (CACM) 18(11), 651–656 (1975)
Cai, Y., Hua, K.A., Cao, G.: Processing range-monitoring queries on heterogeneous mobile objects. In: Proc. of the International Conference on Mobile Data Management (MDM), pp. 27–38 (2004)
Chandrasekaran, S., Franklin, M.J.: Streaming queries over streaming data. In: Proc. of Very Large Data Bases (VLDB) (2002)
Dechter, R., Meiri, I., Pearl, J.: Temporal constraint networks. Journal of Artificial Intelligence 49(1-3), 61–95 (1991)
Gaschnig, J.: Experimental case studies of backtrack vs. waltz-type vs. new algorithms for satisficing assignment problems. In: Proc. of the Canadian Artificial Intelligence Conference, pp. 268–277 (1978)
Gedik, B., Liu, L.: MobiEyes: Distributed processing of continuously moving queries on moving objects in a mobile system. In: Proc. of Extending Database Technology (EDBT), pp. 67–87 (2004)
Guttman, A.: R-trees: A dynamic index structure for spatial searching. In: Proc. of ACM Management of Data (SIGMOD), pp. 47–57. ACM Press, New York (1984)
Hadjieleftheriou, M., Hoel, E., Tsotras, V.J.: Sail: A library for efficient application integration of spatial indices. In: Proc. of Scientific and Statistical Database Management (SSDBM) (2004)
Hammad, M.A., Aref, W.G., Elmagarmid, A.K.: Stream window join: Tracking moving objects in sensor-network databases. In: Proc. of Scientific and Statistical Database Management (SSDBM), pp. 75–84 (2003)
Hanson, E., Carnes, C., Huang, L., Konyala, M., Noronha, L., Parthasarathy, S., Park, J., Vernon, A.: Scalable trigger processing. In: Proc. of International Conference on Data Engineering (ICDE), pp. 266–275 (1999)
Haralick, M., Elliot, J.: Increasing tree-search efficiency for constraint satisfaction problems. Journal of Artificial Intelligence 14(3), 263–313 (1980)
Keidl, M., Kreutz, A., Kemper, A., Kossmann, D.: A publish & subscribe architecture for distributed metadata management. In: Proc. of International Conference on Data Engineering (ICDE), pp. 309–320 (2002)
Kumar, V.: Algorithms for constraints satisfaction problems: A survey. The AI Magazine 13(1), 32–44 (1992)
Lazaridis, I., Porkaew, K., Mehrotra, S.: Dynamic queries over mobile objects. In: Proc. of Extending Database Technology (EDBT) (2002)
Lee, M.-L., Hsu, W., Jensen, C.S., Teo, K.L.: Supporting frequent updates in R-Trees: A bottom-up approach. In: Proc. of Very Large Data Bases (VLDB) (2003)
Papadimitriou, C., Grigni, M., Papadias, D.: Topological inference. In: Proc. of the International Joint Conference of Artificial Intelligence (IJCAI) (1995)
Madden, S., Shah, M., Hellerstein, J., Raman, V.: Continuously adaptive continuous queries over streams. In: SIGMOD. Proc. of ACM Management of Data, ACM Press, New York (2002)
Mamoulis, N., Papadias, D.: Multiway spatial joins. ACM Transactions on Database Systems (TODS) 26(4), 424–475 (2001)
Mamoulis, N., Yiu, M.L.: Non-contiguous sequence pattern queries. In: Proc. of Extending Database Technology (EDBT), pp. 783–800 (2004)
Mokbel, M.F., Xiong, X., Aref, W.G.: SINA: Scalable incremental processing of continuous queries in spatiotemporal databases. In: SIGMOD. Proc. of ACM Management of Data, ACM Press, New York (2004)
Papadias, D., Mamoulis, N., Delis, V.: Algorithms for querying by spatial structure. In: Proc. of Very Large Data Bases (VLDB), pp. 546–557 (1998)
Pei, J., Han, J., Wang, W.: Mining sequential patterns with constraints in large databases. In: Proc. of Conference on Information and Knowledge Management (CIKM) (2002)
PMEL. Tropical Atmosphere Ocean Project, http://www.pmel.noaa.gov/tao
Prabhakar, S., Xia, Y., Kalashnikov, D., Aref, W.G., Hambrusch, S.E.: Query indexing and velocity constraint indexing: Scalable techniques for continuous queries on moving objects. IEEE Transactions on Computers 51(10), 1–17 (2002)
Six, H., Widmayer, P.: Spatial searching in geometric databases. In: Proc. of International Conference on Data Engineering (ICDE), pp. 496–503 (1988)
Song, Z., Roussopoulos, N.: K-nearest neighbor search for moving query point. In: Proc. of Symposium on Advances in Spatial and Temporal Databases (SSTD), pp. 79–96 (2001)
Stonebraker, M., Sellis, T.K., Hanson, E.N.: An analysis of rule indexing implementations in data base systems. In: Expert Database Conference, pp. 465–476 (1986)
Tao, Y., Papadias, D., Shen, Q.: Continuous nearest neighbor search. In: Proc. of Very Large Data Bases (VLDB), pp. 287–298 (2002)
Teng, W.-G., Chen, M.-S., Yu, P.S.: A regression-based temporal pattern mining scheme for data s treams. In: Proc. of Very Large Data Bases (VLDB) (2003)
Tsang, E.P.K.: Foundations of Constraint Satisfaction. Academic Press, London and San Diego (1993)
Yan, T.W., Garcia-Molina, H.: The sift information dissemination system. In: TODS. ACM Transactions on Database Systems, pp. 529–565. ACM Press, New York (1999)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2007 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Hadjieleftheriou, M., Mamoulis, N., Tao, Y. (2007). Continuous Constraint Query Evaluation for Spatiotemporal Streams. In: Papadias, D., Zhang, D., Kollios, G. (eds) Advances in Spatial and Temporal Databases. SSTD 2007. Lecture Notes in Computer Science, vol 4605. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-73540-3_20
Download citation
DOI: https://doi.org/10.1007/978-3-540-73540-3_20
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-73539-7
Online ISBN: 978-3-540-73540-3
eBook Packages: Computer ScienceComputer Science (R0)