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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Abadi, D., Carney, D., Çetintemel, U., Cherniack, M., Convey, C., Erwin, C., Galvez, E., Hatoun, M., Maskey, A., Rasin, A., Singer, A., Stonebraker, M., Tatbul, N., Xing, Y., Yan, R., Zdonik, S.: Aurora: a data stream management system. In: Proceedings of the 2003 ACM SIGMOD International Conference on Management of Data, SIGMOD 2003, pp. 666–666. ACM, New York (2003)
Arasu, A., Babu, S., Widom, J.: The cql continuous query language: semantic foundations and query execution. The VLDB Journal 15(2), 121–142 (2006)
Bai, Y., Thakkar, H., Wang, H., Luo, C., Zaniolo, C.: A data stream language and system designed for power and extensibility. In: Proceedings of the 15th ACM International Conference on Information and Knowledge Management, CIKM 2006, pp. 337–346. ACM, New York (2006)
Bai, Y., Wang, F., Liu, P., Zaniolo, C., Liu, S.: Rfid data processing with a data stream query language. In: 2007 IEEE 23rd International Conference on Data Engineering, pp. 1184–1193. IEEE (2007)
Bellamkonda, S., Ahmed, R., Witkowski, A., Amor, A., Zait, M., Lin, C.-C.: Enhanced subquery optimizations in oracle. Proc. VLDB Endow. 2(2), 1366–1377 (2009)
Buehrer, G.T., Weide, B.W., Sivilotti, P.A.G.: Using parse tree validation to prevent sql injection attacks. In: Proceedings of the International Workshop on Software Engineering and Middleware (SEM), pp. 106–113 (2005)
Choi, S.Y., Jung, H.M., Bang, K.S., Lee, W.Y., Ko, Y.W.: Real-time data stream management system for large volume of rfid events. Design Issues, 515–521 (2008)
Golab, L., Özsu, M.T.: Issues in data stream management. SIGMOD Rec. 32(2), 5–14 (2003)
Plagemann, T., Goebel, V., Bergamini, A., Tolu, G., Urvoy-keller, G., Biersack, E.W.: Using data stream management systems for traffic analysis - a case study. In: Passive and Active Measurements
Surdu, S.: Data stream management systems: a response to large scale scientific data requirements. Annals of the University of Craiova, Mathematics and Computer Science Series 38, 66–75 (2011)
Zeitler, E., Risch, T.: Scalable Splitting of Massive Data Streams. In: Kitagawa, H., Ishikawa, Y., Li, Q., Watanabe, C. (eds.) DASFAA 2010. LNCS, vol. 5982, pp. 184–198. Springer, Heidelberg (2010)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Phucharoen, N., Natwichai, J. (2013). Efficient ESL-Event-to-SQL Translation. In: Yang, J., Fang, F., Sun, C. (eds) Intelligent Science and Intelligent Data Engineering. IScIDE 2012. Lecture Notes in Computer Science, vol 7751. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-36669-7_82
Download citation
DOI: https://doi.org/10.1007/978-3-642-36669-7_82
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-36668-0
Online ISBN: 978-3-642-36669-7
eBook Packages: Computer ScienceComputer Science (R0)