Skip to main content
SpringerLink
Log in

Active Database Systems for Monitoring and Surveillance

  • Conference paper
  • First Online:
Intelligence and Security Informatics (ISI 2003)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 2665))

Included in the following conference series:

Abstract

In many intelligence and security tasks it is necessary to monitor data in database in order to detect certain events or changes. Currently, database systems offer triggers to provide active capabilities. Most triggers, however, are based on the Event-Condition-Action paradigm, which can express only very primitive events. In this paper we propose an extension of traditional triggers in which the Event is a complex situation expressed by a Select-Project-Join-GroupBy SQL query, and the trigger can be programmed to look for changes in the situation defined. Moreover, the trigger can be directed to check for changes on a periodic basis. After proposing a language to define changes, we sketch an implementation, based on the idea of incremental view maintenance, to support efficiently our extended triggers.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Abiteboul, S., Hull, R. and Vianu, V. Foundations of Databases, Addison-Wesley, 1995.

    Google Scholar 

  2. Lars Bkgaard, Leo Mark, Incremental Computation of Time-Varying Query Expressions, TKDE 7(4), 1995.

    Google Scholar 

  3. E. Baralis and J. Widom, An algebraic approach to static analysis of active database rules, TODS 25(3), September 2000.

    Google Scholar 

  4. Stefano Ceri, Roberta J. Cochrane, Jennifer Widom, Practical Applications of Triggers and Constraints: Success and Lingering Issues, In Proc of 26th VLDB Conference 2000, pp 254–262, Cairo, Egypt, September 10–14, 2000.

    Google Scholar 

  5. Cheung, D. W., Han, J., Ng, V. and Wong, C. Y. Maintenance of discovered Association Rules in large databases: An Incremental Updating Technique, in Proceedings of ICDE, 1996.

    Google Scholar 

  6. Chomicki, J., Toman, D. and Bohlen, M. H. Querying ARSQL Databases with Temporal Logic, TODS 26(2), June 2001.

    Google Scholar 

  7. Colby, L., Griffin, T., Libkin, L., Mumick, I. S. and Trickey, H. Algorithms for Deferred View Maintenance, in Proceedings of ACM SIGMOD, 1996.

    Google Scholar 

  8. Avigdor Gal, Opher Etzion Maintaining Data-driven Rules in Databases using Invariant Based Language, IEEE Computer 28(1), 1995.

    Google Scholar 

  9. Materialized Views: Techniques, Implementations and Applications, A. Gupta and I. S. Mumick, eds., MIT Press, 1999.

    Google Scholar 

  10. N.H. Gehani, H.V Jagadish, O. Shmueli Event specification in an Active Objectoriented Database, in Proceedings of ACM SIGMOD, 1992.

    Google Scholar 

  11. Gupta, A, Mumick, I. S. and Subrahmanian, V. S. Maintaining Views Incrementally, in Proceedings of ACM SIGMOD, 1993. Reprinted in [9].

    Google Scholar 

  12. Eric N Hanson, Chris Carnes, Lan Huang, Mohan Konyala, Lloyd Noronha, Sashi Parthasarathy, J.B. Park and Albert Vernon, Scalable Trigger Processing, in Proceedings of ICDE, 1999.

    Google Scholar 

  13. M. Jarke, M, Lenzerini, Y. Vassiliou and P. Vassiliadis, Fundamentals of Data Warehouses, Springer, 2000.

    Google Scholar 

  14. Gerti Kappel, Stefan Rausch-schott, Werner Retschitzegger A tour on the Trigs Active Database System-Architecture and Implementation, In Communications of the ACM, June 1998.

    Google Scholar 

  15. P. Lang, W. Obermair, and M. Schrefl Modeling Business Rules with Situation/Activation Diagrams, in Proceedings of ICDE, 1997.

    Google Scholar 

  16. Lijuan Li and Sharma Chakravarthy An Agent-Based Approach to Extending the Native Active Capability of Relational Database Systems, in Proceedings of ICDE, 1999.

    Google Scholar 

  17. Daniel F. Lieuwen, Narain Gehani, and Robert Arlein, The Ode Active Database: Trigger semantics and Implementation, In Proceeedings of ICDE, 1996.

    Google Scholar 

  18. Iakovos Motakis, Carlo Zaniolo Temporal Aggregation in Active Database Rules, in Proceedings of SIGMOD, 1997.

    Google Scholar 

  19. Xiaolei Qian, Gio Wiederhold Incremental Recomputation of Active Relational Expressions, TKDE, 3(3), Sep 1991.

    Google Scholar 

  20. Arnon Rosenthal, Sharma Chakravarthy, Barbara T. Blaustein, Jose A. Blakeley Situation Monitoring for Active Databases, isectionn Proceednings of VLDB 1989.

    Google Scholar 

  21. Rakesh Chandra, Arie segev, Micheal Stonebraker Implementing Calendars and Temporal Rules in Next Generation Databases, In Proceedings of ICDE, 1994.

    Google Scholar 

  22. A Prasad Sistla, Ouri Wolfson. Temporal Triggers in Active Databases, Technical Report, Univ. of Illinois at Chicago, EECS Dept., 1994

    Google Scholar 

  23. A Prasad Sistla, Ouri Wolfson Temporal Conditions and Integrity Constraints in Active Database System, in Proceedings of ACM SIGMOD, 1995.

    Google Scholar 

  24. Martin Skold and Tore Risch, Using Partial Differencing for Efficient Monitoring of Deferred Complex Rule Conditions, in Proceegings of ICDE, 1996.

    Google Scholar 

  25. Jennifer Widom The Starbust Active Database Rule System, TKDE, 8(4), August 1996.

    Google Scholar 

  26. Carlo Zaniolo, Stefano Ceri, Christos Faloutsos, Richard T. Snodgrass, V. S. Subramanyam, Roberto Zicari Advanced Active DataBase Systems, Morgan Kaufmann, 1997.

    Google Scholar 

  27. Detlef Zimmer and Rainer Unland On the Semantics of Complex Events in Active Database Management Systems, in Proceedings of ICDE, 1999.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Computer Engineering and Computer Science Department, University of Louisville, Louisville, KY, 40292

    Antonio Badia

Authors
  1. Antonio Badia
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Department of Management Information Systems, University of Arizona, Tucson, AZ, 85721, USA

    Hsinchun Chen , Daniel D. Zeng  & Therani Madhusudan ,  & 

  2. Tucson Police Department, 270 S. Stone Ave., Tucson, AZ, 85701, USA

    Richard Miranda  & Jenny Schroeder  & 

  3. School of Public Administration and Policy, University of Arizona, Tucson, AZ, 85721, USA

    Chris Demchak

Rights and permissions

Reprints and permissions

Copyright information

© 2003 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Badia, A. (2003). Active Database Systems for Monitoring and Surveillance. In: Chen, H., Miranda, R., Zeng, D.D., Demchak, C., Schroeder, J., Madhusudan, T. (eds) Intelligence and Security Informatics. ISI 2003. Lecture Notes in Computer Science, vol 2665. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-44853-5_22

Download citation

  • DOI: https://doi.org/10.1007/3-540-44853-5_22

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-40189-6

  • Online ISBN: 978-3-540-44853-2

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation