On the complexity of approximate query optimization

Author(s):  
S. Chatterji ◽  
S. S. K. Evani ◽  
S. Ganguly ◽  
M. D. Yemmanuru
Author(s):  
Francesco Buccafurri ◽  
Gianluca Lax

Online analytical processing applications typically analyze a large amount of data by means of repetitive queries involving aggregate measures on such data. In fast OLAP applications, it is often advantageous to provide approximate answers to queries in order to achieve very high performances. A way to obtain this goal is by submitting queries on compressed data in place of the original ones. Histograms, initially introduced in the field of query optimization, represent one of the most important techniques used in the context of OLAP for producing approximate query answers.


2010 ◽  
Vol 30 (8) ◽  
pp. 2013-2016 ◽  
Author(s):  
Li-ming WANG ◽  
Xiao CHENG ◽  
Yu-mei CHAI

2011 ◽  
Vol 30 (1) ◽  
pp. 33-37
Author(s):  
Xiang Mei ◽  
Xiang-wu Meng ◽  
Jun-Liang Chen ◽  
Meng Xu

Author(s):  
Pankaj Dadheech ◽  
Dinesh Goyal ◽  
Sumit Srivastava ◽  
Ankit Kumar

Spatial queries frequently used in Hadoop for significant data process. However, vast and massive size of spatial information makes it difficult to process the spatial inquiries proficiently, so they utilized the Hadoop system for process Big Data. We have used Boolean Queries & Geometry Boolean Spatial Data for Query Optimization using Hadoop System. In this paper, we show a lightweight and adaptable spatial data index for big data which will process in Hadoop frameworks. Results demonstrate the proficiency and adequacy of our spatial ordering system for various spatial inquiries.


Algorithms ◽  
2021 ◽  
Vol 14 (5) ◽  
pp. 149
Author(s):  
Petros Zervoudakis ◽  
Haridimos Kondylakis ◽  
Nicolas Spyratos ◽  
Dimitris Plexousakis

HIFUN is a high-level query language for expressing analytic queries of big datasets, offering a clear separation between the conceptual layer, where analytic queries are defined independently of the nature and location of data, and the physical layer, where queries are evaluated. In this paper, we present a methodology based on the HIFUN language, and the corresponding algorithms for the incremental evaluation of continuous queries. In essence, our approach is able to process the most recent data batch by exploiting already computed information, without requiring the evaluation of the query over the complete dataset. We present the generic algorithm which we translated to both SQL and MapReduce using SPARK; it implements various query rewriting methods. We demonstrate the effectiveness of our approach in temrs of query answering efficiency. Finally, we show that by exploiting the formal query rewriting methods of HIFUN, we can further reduce the computational cost, adding another layer of query optimization to our implementation.


Author(s):  
Christian Knödler ◽  
Tobias Vinçon ◽  
Arthur Bernhardt ◽  
Ilia Petrov ◽  
Leonardo Solis-Vasquez ◽  
...  

Sign in / Sign up

Export Citation Format

Share Document