Article

Evolving triggers for dynamic environments

Authors:

Goce Trajcevski,

Peter Scheuermann,

Agnes VoisardAuthors Info & Claims

EDBT'06: Proceedings of the 10th international conference on Advances in Database Technology

Pages 1039 - 1048

https://doi.org/10.1007/11687238_60

Published: 26 March 2006 Publication History

Abstract

In this work we address the problem of managing the reactive behavior in distributed environments in which data continuously changes over time, where the users may need to explicitly express how the triggers should be (self) modified. To enable this we propose the (ECA)² – Evolving and Context-Aware Event-Condition-Action paradigm for specifying triggers that capture the desired reactive behavior in databases which manage distributed and continuously changing data. Since both the monitored event and the condition part of the trigger may be continuous in nature, we introduce the concept of metatriggers to coordinate the detection of events and the evaluation of conditions.

References

[1]

ANSI/ISO International Standard: Database language SQL. http://webstore.ansi.org.

[2]

Oracle 9i. www.oracle.com/technology/products/oracle9i.

[3]

A. Carzaniga, D.S. Rosenblum, and A.L. Wolf. Design and evaluation of a widearea event notification service. ACM-TOCS, 19(3), 2001.

Digital Library

[4]

S. Chandrasekaran and M.J. Franklin. Streaming queries over streaming data. In VLDB Conference, 2002.

Digital Library

[5]

S. Chandrasekaran and M.J. Franklin. Remembrance of streams past: Overloadsensitive management of archived streams. In VLDB Conference, 2004.

Digital Library

[6]

J.J. Chen, D.J. DeWitt, F. Tian, and Y. Wang. NiagaraCQ: A scalable continuous query system for internet databases. In ACM SIGMOD Conference, 2000.

Digital Library

[7]

Y. Diao, S. Rizvi, and M.J. Franklin. Towards an internet-scale XML dissemination service. In VLDB Conference, 2004.

Digital Library

[8]

P. Fraternali and L. Tanca. A structured approach for the definition of the semantics of active databases. ACM TODS, 20(4), 1995.

Digital Library

[9]

G.Papamarkos, A.Poulovassilis, and P.T.Wood. Event-condition-action rule languages for the semantic web. In SWDB Workshop (at VLDB), 2003.

[10]

R.H. Güting and M. Schneider. Moving Objects Databases. Morgan Kaufmann, 2005.

[11]

A. Hinze and A. Voisard. Location-and time-based information delivery in tourism. In SSTD, 2003.

[12]

L. Liu, C. Pu, and W. Tang. Continual queries for internet scale event-driven information delivery. IEEE-TKDE, 11(4), 1999.

Digital Library

[13]

S. Madden, M.A. Shah, J.M. Hellerstein, and V. Raman. Continuously adaptive continuous queries over streams. In ACM SIGMOD Conference, 2002.

Digital Library

[14]

C. Olston, J. Jiang, and J. Widom. Adaptive filters for continuous queries over distributed data streams. In ACM SIGMOD, 2003.

Digital Library

[15]

N. Paton. Active Rules in Database Systems. Springer-Verlag, 1999.

Digital Library

[16]

J. Schiller and A. Voisard. Location-based Services. Morgan Kaufmann Publishers, 2004.

Digital Library

[17]

G. Trajcevski, H. Ding, and P. Scheuermann. Context-aware optimization of continuous range queries for trajectories. In MobiDE Workshop (at SIGMOD), 2005.

Digital Library

[18]

G. Trajcevski, P. Scheuermann, H. Brönnimann, and A. Voisard. Dynamic topological predicates and notifications in moving objects databases. In MDM, 2005.

Digital Library

[19]

J. D. Ullman. Principles of Database and Knowledge - Base Systems. Computer Science Press, 1989.

Digital Library

[20]

J. Widom. The Starburst active database rule system. IEEE TKDE, 8(4), 1996.

Digital Library

[21]

J. Widom and S. Ceri. Active Database Systems: Triggers and Rules for Advanced Database Processing. Morgan Kaufmann, 1996.

Digital Library

[22]

F. Zhao and L. Guibas. Wireless Sensor Networks: an Information Processing Approach. Morgan Kauffman, 2004.

Digital Library

Cited By

Ilarri SMena EIllarramendi A(2010)Location-dependent query processingACM Computing Surveys10.1145/1670679.167068242:3(1-73)Online publication date: 29-Mar-2010
https://dl.acm.org/doi/10.1145/1670679.1670682
Trajcevski GScheuermann P(2009)Managing context evolution in pervasive environmentsProceedings of the 2nd International Conference on PErvasive Technologies Related to Assistive Environments10.1145/1579114.1579133(1-2)Online publication date: 9-Jun-2009
https://dl.acm.org/doi/10.1145/1579114.1579133

Recommendations

SQL Triggers Reacting on Time Events: An Extension Proposal
ADBIS '09: Proceedings of the 13th East European Conference on Advances in Databases and Information Systems

Being able to activate triggers at timepoints reached or after time intervals elapsed has been acknowledged by many authors as a valuable functionality of a DBMS. Recently, the interest in time-based triggers has been renewed in the context of data ...
Timer-driven database triggers and alerters: semantics and a challenge

This paper proposes a simple model for a timer-driven triggering and alerting system. Such a system can be used with relational and object-relational databases systems. Timer-driven trigger systems have a number of advantages over traditional trigger ...
A flexible system for in situ triggers
ISAV '18: Proceedings of the Workshop on In Situ Infrastructures for Enabling Extreme-Scale Analysis and Visualization

Triggers are an important mechanism for adapting visualization, analysis, and storage actions. With this work, we describe the Ascent in situ infrastructure's system for triggers. This system splits triggers into two components: when to perform an ...

Comments

Information & Contributors

Information

Published In

cover image Guide Proceedings

EDBT'06: Proceedings of the 10th international conference on Advances in Database Technology

March 2006

1204 pages

ISBN:3540329609

Editors:
Yannis Ioannidis
University of Athens, Greece
,
Marc H. Scholl
University of Konstanz, Konstanz, Germany
,
Joachim W. Schmidt
Sustainable Content Logistics Centre, Hamburg, Germany
,
Florian Matthes
Chair of Software Engineering for Business Information Systems, Technische Universität München, Boltzmannstraße 3, Garching b. München
,
Mike Hatzopoulos
Department of Informatics, University of Athens Panepistimiopolis, Boltzmannstraße 3, Athens, Greece

Publisher

Springer-Verlag

Berlin, Heidelberg

Publication History

Published: 26 March 2006

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

2
Total Citations
View Citations
0
Total Downloads

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

Reflects downloads up to 03 Oct 2024

Other Metrics

View Author Metrics

Citations

Cited By

Ilarri SMena EIllarramendi A(2010)Location-dependent query processingACM Computing Surveys10.1145/1670679.167068242:3(1-73)Online publication date: 29-Mar-2010
https://dl.acm.org/doi/10.1145/1670679.1670682
Trajcevski GScheuermann P(2009)Managing context evolution in pervasive environmentsProceedings of the 2nd International Conference on PErvasive Technologies Related to Assistive Environments10.1145/1579114.1579133(1-2)Online publication date: 9-Jun-2009
https://dl.acm.org/doi/10.1145/1579114.1579133

View Options

View options

Media

Figures

Other

Tables

View Table of Contents