Using Hadoop-based systems in the execution of the SSB benchmark

• Grant number: 14/12233-2
• Support Opportunities: Scholarships in Brazil - Master
• Start date: September 01, 2014
• End date: February 29, 2016
• Field of knowledge: Physical Sciences and Mathematics - Computer Science
• Agreement: Coordination of Improvement of Higher Education Personnel (CAPES)
• Principal Investigator: Cristina Dutra de Aguiar
• Grantee: Lucas de Carvalho Scabora
• 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

In recent years, research related to data warehousing and OLAP (Online Analytical Processing) has been the focus of interest from both academia and industry, producing several important technologies for the design, management and use of information systems for decision support. These technologies are mostly aimed to environments that we call conventional, which do not provide a cloud-computing framework. However, a cloud data warehouse introduces several advantages to conventional data warehousing applications, as described as follows. It supports the storage of increasing data warehouse volumes and the execution of OLAP queries over these voluminous data. It also decreases the costs related to hardware and maintenance. Furthermore, it guarantees flexibility to the decision-making services offered. Despite these advantages, the research on cloud data warehouses is in its initial stage and, therefore, there are several research opportunities that have not been addressed yet. These opportunities motivate the development of this master project, which aims to investigate the impact of using systems based on Hadoop to execute the SSB (Star Schema Benchmark), which is a well-known benchmark for data warehousing environments. Therefore, this master project focuses on this gap in the literature of cloud data warehouses, as it investigates this innovative and challenge research topic. (AU)

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)

SCABORA, LUCAS C.; BRITO, JAQUELINE J.; CIFERRI, RICARDO RODRIGUES; DE AGUIAR CIFERRI, CRISTINA DUTRA; HAMMOUDI, S; MACIASZEK, L; MISSIKOFF, MM; CAMP, O; CORDEIRO, J. Physical Data Warehouse Design on NoSQL Databases OLAP Query Processing over HBase. PROCEEDINGS OF THE 18TH INTERNATIONAL CONFERENCE ON ENTERPRISE INFORMATION SYSTEMS, VOL 1 (ICEIS), v. N/A, p. 8-pg., 2016-01-01. (14/12233-2)