Efficient ESL-Event-to-SQL translation

Authors:
Narat Phucharoen;Juggapong Natwichai
Affiliations:
Computer Engineering Department, Faculty of Engineering, Chiang Mai University, Chiang Mai, Thailand;Computer Engineering Department, Faculty of Engineering, Chiang Mai University, Chiang Mai, Thailand
Venue:
IScIDE'12 Proceedings of the third Sino-foreign-interchange conference on Intelligent Science and Intelligent Data Engineering
Year:
2012

Citing 7
Cited 0

Issues in data stream management

ACM SIGMOD Record
Aurora: a data stream management system

Proceedings of the 2003 ACM SIGMOD international conference on Management of data
Using parse tree validation to prevent SQL injection attacks

SEM '05 Proceedings of the 5th international workshop on Software engineering and middleware
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
Enhanced subquery optimizations in Oracle

Proceedings of the VLDB Endowment
Scalable splitting of massive data streams

DASFAA'10 Proceedings of the 15th international conference on Database Systems for Advanced Applications - Volume Part II

Quantified Score

Hi-index	0.00

Visualization

Abstract

Expressive Stream Language-Event (ESL-Event), which is based on the traditional SQL, is a language developed for streaming data management. It can handle the data streams and temporal event queries effectively. However, it has yet to be implemented commercially. In this paper, we propose an efficient ESL-Event-to-SQL translation. Since the SQL language can be used widely on the traditional DBMSs. Thus, our proposed work allows the users to leverage the features of the ESL-Event on the current systems with no effort. Our approach firstly parses an ESL-Event statement into the intermediate representation, the parse tree. Subsequently, the tree is converted to the SQL-syntax-complied parse tree, in which the semantic of all the ESL-Event features is well preserved and implemented efficiently. Once the tree is traversed, the SQL statement is generated. From the experiment results, our work is highly efficient.