Melhorando o Desempenho do Processamento de Consultas Drill-Across em Ambientes de Data Warehousing

In this paper we propose two algorithms aimed at increasing the performance of drill-across queries in data warehousing environments. The JMG algorithm is used when numeric measures of different data warehouses are usually required together. The EG-JM algorithm extends the first one also considering storage requirements. The performance tests carried out using the TPC-H benchmark showed a huge improvement on the query performance with a reduced additional storage requirement.