On computing correlated aggregates over continual data streams
SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
Orthogonal optimization of subqueries and aggregation
SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
Continuously adaptive continuous queries over streams
Proceedings of the 2002 ACM SIGMOD international conference on Management of data
The MD-join: An Operator for Complex OLAP
Proceedings of the 17th International Conference on Data Engineering
Querying Multiple Features of Groups in Relational Databases
VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
Generalized MD-Joins: Evaluation and Reduction to SQL
DBTel '01 Proceedings of the VLDB 2001 International Workshop on Databases in Telecommunications II
Evaluation of Ad Hoc OLAP: In-Place Computation
SSDBM '99 Proceedings of the 11th International Conference on Scientific and Statistical Database Management
Issues in data stream management
ACM SIGMOD Record
Spreadsheets in RDBMS for OLAP
Proceedings of the 2003 ACM SIGMOD international conference on Management of data
On relational support for XML publishing: beyond sorting and tagging
Proceedings of the 2003 ACM SIGMOD international conference on Management of data
VLDB '05 Proceedings of the 31st international conference on Very large data bases
The CQL continuous query language: semantic foundations and query execution
The VLDB Journal — The International Journal on Very Large Data Bases
A data stream language and system designed for power and extensibility
CIKM '06 Proceedings of the 15th ACM international conference on Information and knowledge management
A strategic analysis of inter organizational information sharing
Decision Support Systems
Using grouping variables to express complex decision support queries
Data & Knowledge Engineering
Accessing information sharing and information quality in supply chain management
Decision Support Systems
Protocols for RFID tag/reader authentication
Decision Support Systems
Monitoring streams: a new class of data management applications
VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
A Continuous Query Index for Processing Queries on RFID Data Stream
RTCSA '07 Proceedings of the 13th IEEE International Conference on Embedded and Real-Time Computing Systems and Applications
Stream Variables: A Quick but not Dirty SQL Extension for Continuous Queries
ICDEW '07 Proceedings of the 2007 IEEE 23rd International Conference on Data Engineering Workshop
ASSET queries: a declarative alternative to MapReduce
ACM SIGMOD Record
Expert Systems with Applications: An International Journal
Supply chain product visibility: Methods, systems and impacts
Expert Systems with Applications: An International Journal
Hi-index | 0.00 |
While RFID technology has been widely praised for its ability to streamline supply chain processes, little attention has been given to its unique data capturing characteristics to support real-time decision making. Being able to efficiently perform complex real-time analysis on top of RFID event streams is a key challenge for modern applications. This provides management with a novel data analysis mechanism to allow better, tactical, on time, well-informed decisions. The two main issues in RFID data management (RFDM) concern expressibility (how to simply and concisely express stream queries) and performance (how to efficiently evaluate stream queries). In this paper we claim that a spreadsheet-like query model, where formulation is done in a column-wise fashion, can express intuitively a large class of useful and practical RFDM queries. We propose a simple SQL extension to do that and show how these queries can be evaluated efficiently. We finally discuss a prototype called COSTES (COntinuous SpreadsheeT-likE computations), which implements our SQL extensions and evaluation algorithms. Presentation takes place within the context of two representative RFID applications, namely shelf availability and in-store sales promotions.