Stream Variables: A Quick but not Dirty SQL Extension for Continuous Queries

Chatziantoniou, Damianos; Sotiropoulos, Yannis

doi:10.1109/icdew.2007.4400969

2007 IEEE 23rd International Conference on Data Engineering Workshop 2007

DOI: 10.1109/icdew.2007.4400969

|View full text |Cite

Stream Variables: A Quick but not Dirty SQL Extension for Continuous Queries

Damianos Chatziantoniou

Yannis Sotiropoulos

Help me understand this report

Search citation statements

Order By: Relevance

Paper Sections

Select...

Citation Types

Supporting

Mentioning

Contrasting

Year Published

2008

2010

Publication Types

Select...

Other3

Relationship

Self Cite1

Independent2

Authors

Journals

Cited by 3 publications

References 16 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

COSTES: Continuous spreadsheet-like computations

Chatziantoniou¹,

Pramatari²,

Sotiropoulos³

2008

2008 IEEE 24th International Conference on Data Engineering Workshop

Self Cite

View full text Add to dashboard Cite

AutoID technology has been extensively used for a diversity of applications ranging from access control systems to airport baggage handling, livestock management systems, automated toll collection, theft-prevention, and automated production systems. Being able to efficiently perform complex real-time analysis on top of streams of RFID events is a key challenge. This will provide management with a novel data analysis mechanism to allow better, tactical, on time, wellinformed decision-making. Challenges involve both syntactic and evaluation issues. In this paper we propose a set of linguistic requirements for RFID data management (RFDM) queries and describe an SQL-like construct to address these. We argue that a large and useful class of (potentially complex) RFDM queries can be easily expressed and efficiently evaluated using this formality: start from a relational expression and successively extend it with columns representing aggregates over dynamically updated ordered sets. This incremental construction of a query is similar to formula definitions in spreadsheets. We present a fully functional prototype called COSTES (COntinuous SpreadsheeTlikE computationS) implementing spreadsheet-like queries and discuss its architecture and performance. We describe our system in the context of a supply chain management application.

show abstract

COSTES: Continuous spreadsheet-like computations

Chatziantoniou¹,

Pramatari²,

Sotiropoulos³

2008

2008 IEEE 24th International Conference on Data Engineering Workshop

Self Cite

View full text Add to dashboard Cite

show abstract

Incremental view-based analysis of stock market data streams

Behrend

Dorau

Manthey

et al. 2008

Proceedings of the 2008 International Symposium on Database Engineering &Amp; Applications - IDEAS '08

View full text Add to dashboard Cite

Aims

Schüller

Behrend

Manthey

2010

Proceedings of the ACM SIGSPATIAL International Workshop on GeoStreaming

View full text Add to dashboard Cite

scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.

Contact Info

customersupport@researchsolutions.com

10624 S. Eastern Ave., Ste. A-614

Henderson, NV 89052, USA

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Blog Terms and Conditions API Terms Privacy Policy Contact Cookie Preferences Do Not Sell or Share My Personal Information

Made with 💙 for researchers

Part of the Research Solutions Family.

Stream Variables: A Quick but not Dirty SQL Extension for Continuous Queries

Cited by 3 publications

References 16 publications

COSTES: Continuous spreadsheet-like computations

COSTES: Continuous spreadsheet-like computations

Incremental view-based analysis of stock market data streams

Aims

Contact Info

Product

Resources

About