Advanced search
Start date
Betweenand

Analytical query processing on parallel and distributed environments

Grant number: 18/10607-3
Support Opportunities:Scholarships in Brazil - Master
Start date: April 01, 2019
End date: June 30, 2020
Field of knowledge:Physical Sciences and Mathematics - Computer Science - Computing Methodologies and Techniques
Principal Investigator:Cristina Dutra de Aguiar
Grantee:Guilherme Muzzi da Rocha
Host Institution: Instituto de Ciências Matemáticas e de Computação (ICMC). Universidade de São Paulo (USP). São Carlos , SP, Brazil

Abstract

Processing OLAP (on-line analytical processing) queries is very expensive because of the huge volume of data stored in the data warehouse and the fact that they perform star-join. This processing can be benefited by the use of computational environments with large storage and processing capacities, such as clusters of computers and cloud computing. In these environments, it is common the use of parallel and distributed programming paradigms, such as the Spark framework. In the literature, there are several approaches that investigate the processing of joins in parallel and distributed environments, including the star-join. However, to the best of our knowledge, none of these approaches investigates the performance of star-joins considering drill-down, roll-up, and drill-across OLAP queries. These queries are of great importance because they are often required in decision-making. In addition, they have specific characteristics, which imply in specific optimizations. This master's project aims to fill this gap in the literature by proposing solutions for the efficient processing of drill-down, roll-up and drill-across OLAP queries, considering the framework Spark. (AU)

News published in Agência FAPESP Newsletter about the scholarship:
More itemsLess items
Articles published in other media outlets ( ):
More itemsLess items
VEICULO: TITULO (DATA)
VEICULO: TITULO (DATA)

Scientific publications
(References retrieved automatically from Web of Science and SciELO through information on FAPESP grants and their corresponding numbers as mentioned in the publications by the authors)
ROCHA, GUILHERME MUZZI; CAPELO, PIERO LIMA; CARNIEL, ANDERSON CHAVES; AGUIAR, CRISTINA DUTRA; CHIUSANO, S; CERQUITELLI, T; WREMBEL, R; NORVAG, K; CATANIA, B; VARGAS-SOLAR, G; et al. Storing Feature Vectors in Relational Image Data Warehouses. NEW TRENDS IN DATABASE AND INFORMATION SYSTEMS, ADBIS 2022, v. 1652, p. 9-pg., . (18/10607-3, 18/22277-8)