SQL Triggers Reacting on Time Events: An Extension Proposal

Behrend, Andreas; Dorau, Christian; Manthey, Rainer

doi:10.1007/978-3-642-03973-7_14

Cited by 6 publications

(3 citation statements)

References 10 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…(3) Delaying reaction execution to some later point in time relative to the triggering event of a rule. In [35] the authors propose a set of functionalities to be implemented with triggers written in SQL:1999 standard that cover three types of temporal categories -absolute, periodic, and relative event specifications -and allow to base delay or periodic repetition on valid time or transaction time events, respectively. According to this proposal of functionalities, we can provide users with a new set of rules composition-strategies able to go beyond the simple use of an IF-THIS-THEN-THAT statement.…”

Section: A New Eud Paradigm and Language For Iotmentioning

confidence: 99%

Designing for End-User Development in the Internet of Things

Barricelli

Valtolina

2015

Lecture Notes in Computer Science

View full text Add to dashboard Cite

Abstract. With the widespread of Internet of Things' devices, sensors, and applications the quantity of collected data grows enormously and the need of extracting, merging, analyzing, visualizing, and sharing it paves the way for new research challenges. This ongoing revolution of how personal devices are used and how they are becoming more and more wearable has important influences on the most well established definitions of end user and end-user development. The paper presents an analysis of the most diffused applications that allow end users to aggregate quantified-self data, originated by several sensors and devices, and to use it in personalized ways. From the outcomes of the analysis, we present a classification model for Internet of Things and new EUD paradigm and language that extends the ones existing in the current state of the art Internet of Things.

show abstract

Section: A New Eud Paradigm and Language For Iotmentioning

confidence: 99%

Designing for End-User Development in the Internet of Things

Barricelli

Valtolina

2015

Lecture Notes in Computer Science

View full text Add to dashboard Cite

show abstract

“…When directives are stored, they are expected to have a result after a certain period of time. It is therefore crucial that a time-based trigger (Behrend et al, 2009) or a DB job is started and the outcome is checked after its firing. In its most primitive form, a simple string along with a trigger expression could be used.…”

Section: Partition By Patientid Range 10 Minutes Having C > 10mentioning

confidence: 99%

Database Functionalities for Evolving Monitoring Applications

Schmiegelt

Xie²,

Schüller³

et al. 2013

Proceedings of the 2nd International Conference on Data Technologies and Applications

View full text Add to dashboard Cite

Databases are able to store, manage, and retrieve large amounts and a broad variety of data. However, the task of understanding and reacting to the data is often left to tools or user applications outside the database. As a consequence, monitoring applications are often relying on problem-specific imperative code for data analysis, scattering the application logic. This usually leads to island solutions which are hard to maintain, give raise to security and performance problems due to the separation of data storage and analysis. In this paper, we identify missing database functionalities which overcome these problems by allowing data processing on a higher level of abstraction. Such functionalities would allow to employ a database system even for the complex analysis tasks required in evolving monitoring scenarios.

show abstract

“…According to the ECA paradigm, triggers may offer a cross-process evaluation by having access to the entire database [11]. There is some work that offers CEP solutions by core database technologies [7], [26] and even for temporal patterns [24]. A good overview of alternatives to CEP such as active databases, pub/sub etc.…”

Section: Solution E: In-database Processingmentioning

confidence: 99%

Integrating CEP and BPM

Daum¹,

Götz²,

Domaschka³

2012

Proceedings of the 6th ACM International Conference on Distributed Event-Based Systems

View full text Add to dashboard Cite

Business Process Management Systems (BPMSs) found broad application in recent years and there have been first suggestions how Complex Event Processing (CEP) can support or complement BPMS functionality. Though some business suites already provide technical integration of BPMSs and CEP engines, many benefits still remain undiscovered.We describe classification of event-driven data processing having a BPMS as data source and we reveal some relevant challenges for CEP. This paper provides contributions on both technical and conceptual level. From a technical point of view, we discuss mission-critical performance issues that depend on the chosen integration approach of BPMSs, CEP engines, and database systems. Scalability of BPM applications can benefit from outsourcing BPM computations to in-DB calculations and in-CEP processing. From a functional/conceptual point of view, we emphasize current CEP techniques and how they realize functional requirements of concrete BPM use cases.

show abstract

SQL Triggers Reacting on Time Events: An Extension Proposal

Cited by 6 publications

References 10 publications

Designing for End-User Development in the Internet of Things

Designing for End-User Development in the Internet of Things

Database Functionalities for Evolving Monitoring Applications

Integrating CEP and BPM

Contact Info

Product

Resources

About