skip to main content
article

Reactive maintenance of continuous queries

Published:01 July 2004Publication History
Skip Abstract Section

Abstract

This work addresses the problem of maintaining the consistency of the answers to continuous queries which are posed by the users of the Moving Objects Databases (MOD). Assuming that the motion of the object is represented by a trajectory, we focus on the effect that the modifications to the trajectory data can have on the queries answer-set. In case a mobile user enters a road section in which an accident has occurred, which was not anticipated in the "expected" traffic behavior, not only his trajectory needs to updated, but the answer to the query that he posed may need to be recalculated and transmitted again. In this work we propose a framework which enables detecting and processing the pending queries whose answers need to be re-evaluated upon modifications to the MOD. We identify the relevant syntactic elements which can be extracted from the user's queries and we analyze their semantic implications. We also propose an architecture of a system that can be used for this task. We demonstrate how triggers can be used to maintain the answers to the users' queries "up to date" with respect to the modifications to the MOD and we show that our framework can be implemented on top of the existing ORDBMS.

References

  1. A. K. Agarwal, L. Agre, and J. Erickson. Indexing Moving Points. In Proceedings of the ACM PODS International Conference, 2000.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. C. Baral, J. Lobo, and G. Trajcevski. Formal Characterization of Active Databases: Part II. In Proceedings of the International Conference on Deductive and Object-Oriented Databases (DOOD), 1997.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  3. M. Carey, D. Chamberlin, S. Narayanan, B. Vance, D. Doole, S. Rileau, R. Swegarman, and N. Mattos. O-O What Have They Done to DB2. In Proceedings of the International Conference on Very Large Databases (VLDB), 1999.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  4. S. Ceri, P. Fraternali, S. Paraboschi, and L. Tanca. Automatic Generation of Production Rules for Integrity Maintenance. ACM Transactions on Database Systems, 19(3):367--422, 1994.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  5. S. Ceri, P. Fraternali, S. Paraboschi, and L. Tanca. Active Rule Management in Chimera. In J. Widom and S. Ceri, editors, Active Database Systems: Triggers and Rules for Advanced Database Processing. Morgan Kaufmann, 1996.]]Google ScholarGoogle Scholar
  6. U. Dayal, E. Hansen, and J. Widom. Active Database Systems. In W. Kim, editor, Modern Database Systems: The Object Model, Interoperability and Beyond. Addison-Wesley, 1994.]]Google ScholarGoogle Scholar
  7. S. E. Dreyfus. An Appraisal of Some Shortest-Path Algorithms. Operations Research, 17(3), 1969.]]Google ScholarGoogle Scholar
  8. M. Erwig, M. Schneider, and R. H. Güting. Temporal and Spatio-Temporal Datasets and Their Expressive Power. Technical Report 225-12/1997, Informatik berichte, 1997.]]Google ScholarGoogle Scholar
  9. L. Forlizzi, R. H. Güting, E. Nardelli, and M. Schneider. A Data Model and Data Structures for Moving Objects Databases. In Proceedings of the ACM SIGMOD International Conference, 2000.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  10. P. Fraternali and L. Tanca. A Structured Approach for the Definition of the Semantics of Active Databases. ACM Transactions on Database Systems, 20(4), 1995.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  11. R. H. Güting, M. H. Böhlen, M. Erwig, C. Jensen, N. Lorentzos, M. Schneider, and M. Vazirgiannis. A Foundation for Representing and Queirying Moving Objects. ACM Transactions on Database Systems, 25(1), 2000.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  12. D. Kollios, D. Gunopulos, and V. J. Tsotras. On Indexing Mobile Objects. In Proceedings of the ACM PODS International Conference, 1999.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  13. G. Kollios, D. Gunopulos, and V. J. Tsotras. Nearest Neighbour Queries in a Mobile Environment. In Spatio-Temporal Database Management, 1999.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  14. B. Ludaescher. Integration of Active and Deductive Database Rules. PhD thesis, Universitat Freiburg, 1998.]]Google ScholarGoogle Scholar
  15. I. Motakis and C. Zaniolo. Formal Semantics for Composite Temporal Events in Active Database Rules. JOSI, pages 1--37, 1997.]]Google ScholarGoogle Scholar
  16. Oracle Corporation. Oracle8i: Spatial Cartridge User's Guide and Reference, Release 8.0.4, 2000. http://technet.oracle.com/docs/products/oracle8/docindex.htm.]]Google ScholarGoogle Scholar
  17. A. Pashtan, R. Blatter, A. Heusser, and P. Scheuermann. Personal Services Areas for Location-Based Wireless Web Applications. In IEEE Internet Computing, (to appear in Fall) 2004.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  18. N. Paton, editor. Active Rules in Database Systems. Springer-Verlag, 1999.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  19. D. Pfoser and C. Jensen. Capturing the Uncertainty of Moving Objects Representation. In International Symposium on Advances in Spatial Databases (SSD), 1999.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  20. P. Picouet and V. Vianu. Semantics and Expressiveness Issues in Active Databases. In Proceedings of the ACM PODS International Conference, 1995.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  21. E. Pitoura and G. Samaras. Locating Objects in Mobile Computing. IEEE Transactions on Knowledge and Data Engineering, 13(4), 2001.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  22. S. Prabhakar, Y. Xia, D. Kalashnikov, W. Aref, and S. Hambrusch. Query Indexing and Velocity Constrained Indexing: Scalable Techniques for Continuous Queries on Moving Objects. Transactions on Knowledge and Data Engineering, 51(10), 2002.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  23. G. Karciauskas R. Benetis, C. Jensen and S. Saltenis. Nearest Neighbor and Reverse Nearest Neighbor in Moving Objects. In Proceedings of the IDEAS International Conference, 2002.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  24. S. Saltenis and C. Jensen. R-tree Based Indexing of General Spatio-Temporal Data. Technical Report TR-45, TimeCenter, 1999.]]Google ScholarGoogle Scholar
  25. S. Saltenis and C. Jensen. Indexing of Moving Objects for Location-Based Services. In Proceedings of the IEEE International Conference on Data Engineering, 2002.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  26. S. Saltenis, C. S. Jensen, S. T. Leutenegger, and M. A. Lopez. Indexing the Positions of Continuously Moving Objects. In Proceedings of the ACM SIGMOD International Conference, 2000.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  27. A. P. Sistla, O. Wolfson, S. Chamberlain, and S. Dao. Modeling and Querying Moving Objects. In Proceedings of the IEEE International Conference on Data Engineering, 1997.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  28. P. Sistla and O. Wolfson. Temporal Conditions and Integrity Constraint Checking in Active Database Systems. In Proceedings of the ACM SIGMOD International Conference, 1995.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  29. Y. Tao and D. Papadias. Spatial Queries in Dynamic Environments. ACM Transactions on Database Systems, 28(2), 2003.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  30. J. Tayeb, O. Ulusoy, and O. Wolfson. A Quadtree-based Dynamic Attribute Indexing Method. The Computer Journal, 41(3), 1998.]]Google ScholarGoogle Scholar
  31. Y. Theodoridis, T. Sellis, A. N. Papadopoulos, and Y. Manolopoulos. Specifications for Efficient Indexing in Spatiotemporal Databases. In Proceedings of the International Conference on Statistical and Scientific Database Management, 1999.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  32. Y. Theodoridis, J. R. O. Silva, and M. A. Nascimento. On the Generation of Spatiotemporal Datasets. In Proceedings of the International Symposium on Large Spatial Databases, 1999.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  33. G. Trajcevski, O. Wolfson, B. Xu, and P. Nelson. Real-Time Traffic Updates in Moving Objects Databases. In Proceedings of the MDDS workshop (in conjunction with the DEXA Conference), 2002.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  34. G. Trajcevski, O. Wolfson, F. Zhang, and S. Chamberlain. The Geometry of Uncertainty in Moving Objects Databases. In Proceedings of the International Conference on Extending Database Technology, 2002.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  35. S. Urban, M. Tschudi, S. Dietrich, and A. Karadimce. Active Rule Termination Analysis: An Implementation and Dvaluation of Refined Triggering Graph Method. JIIS, 12(1), 1999.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  36. M. Vazirgiannis and O. Wolfson. A Spatiotemporal Model and Language for Moving Objects on Road Networks. In Proceedings of the International Symposium on Spatial and Temporal Databases (SSTD), 2001.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  37. J. Widom. The STARBURST Active Database Rule System. IEEE Transactions on Data and Knowledge Engineering, 8(4), 1996.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  38. J. Widom and S. Ceri. Active Database Systems: Triggers and Rules for Advanced Database Processing. Morgan Kaufmann, 1996.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  39. O. Wolfson, S. Chamberlain, S. Dao, L. Jiang, and G. Mendez. Cost and Imprecision in Modeling the Position of Moving Objects. In Proceedings of the IEEE International Conference on Data Engineering, 1998.]] Google ScholarGoogle ScholarDigital LibraryDigital Library
  40. O. Wolfson, A. P. Sistla, S. Chamberlain, and Y. Yesha. Updating and Querying Data-bses that Track Mobile Units. Distributed and Parallel Databases, 7, 1999.]] Google ScholarGoogle ScholarDigital LibraryDigital Library

Index Terms

  1. Reactive maintenance of continuous queries
      Index terms have been assigned to the content through auto-classification.

      Recommendations

      Comments

      Login options

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

      Sign in

      Full Access

      • Published in

        cover image ACM SIGMOBILE Mobile Computing and Communications Review
        ACM SIGMOBILE Mobile Computing and Communications Review  Volume 8, Issue 3
        July 2004
        87 pages
        ISSN:1559-1662
        EISSN:1931-1222
        DOI:10.1145/1031483
        Issue’s Table of Contents

        Copyright © 2004 Authors

        Publisher

        Association for Computing Machinery

        New York, NY, United States

        Publication History

        • Published: 1 July 2004

        Check for updates

        Qualifiers

        • article

      PDF Format

      View or Download as a PDF file.

      PDF

      eReader

      View online with eReader.

      eReader