DocumentCode
256408
Title
Efficient optimized query mesh for data streams
Author
Mohamed, F. ; Ismail, R. ; Badr, N. ; Tolba, M.F.
Author_Institution
Inf. Syst. Dept., Ain Shams Univ., Cairo, Egypt
fYear
2014
fDate
22-23 Dec. 2014
Firstpage
157
Lastpage
163
Abstract
Most of query optimizers choose a single query plan for processing all the data based on the average data statistics. But this plan is usually not efficient with the uncertain stream datasets of modern applications as network monitoring, sensor networks and financial applications; where these data have continuous variations over time. In this paper we propose an optimized query mesh for data stream (OQMDS) frameworks. In which, process data streams over multiple query plans, each of them is optimal for the sub-set of data with the same statistics. The OQMDS solution depends on preparing multiple query plans and continuously chooses the best execution plan for each sub-set of incoming data streams based on their statistics. We also propose two optimization algorithms called Optimized Iterative Improvement Query Mesh (OII-QM) and Non-Search based Query Mesh (NS-QM) algorithms, to efficiently generate the multiple plans (the optimized QM solution) which are used to process the online data streams. Our experimental results show that, the proposed solution OQMDS improves the overall performance of data stream processing.
Keywords
data handling; iterative methods; query processing; statistical analysis; NS-QM algorithm; OII-QM algorithm; OQMDS framework; continuous data variations; data statistics; efficient optimized query mesh; financial applications; multiple query plans; network monitoring; nonsearch based query mesh; online data stream processing; optimization algorithm; optimized iterative improvement query mesh; query optimizers; sensor network; uncertain stream datasets; Algorithm design and analysis; Databases; Lattices; Monitoring; Optimization; continuous query optimization; data streams; optimzed query plan;
fLanguage
English
Publisher
ieee
Conference_Titel
Computer Engineering & Systems (ICCES), 2014 9th International Conference on
Conference_Location
Cairo
Print_ISBN
978-1-4799-6593-9
Type
conf
DOI
10.1109/ICCES.2014.7030949
Filename
7030949
Link To Document