Friday, 6/30/2017
HASLab researchers were granted Best Paper Award at the conference DAIS 2017 - 17th IFIP International Conference on Distributed Applications and Interoperable Systems.
The paper entitled "Similarity aware shuffling for the distributed execution of SQL window functions", authored by researchers from the High Assurance Software Laboratory (HASLab) Fábio Coelho – student from the Doctoral Programme in Informatics MAP-i, José Pereira and Rui Oliveira – professors from the Department of Informatics (DI) of the EEUM, together with Miguel Matos, currently researcher at INES TEC, was selected as Best Paper Award of DAIS 2017.
In this work, the researchers developed a mechanism that is able to improve how analytic functions are executed across a distributed database, in other words, in a database where the data is not all stored in the same location. This work focuses on Window Functions, a very flexible class of analytical functions whose usage is currently experience and increased by Big Data analytics.
Distributed databases can scale the processing power by distributing data and load across a group of identical workers. Nevertheless, the data distribution introduces several challenges related with the distribution of data and load in a distributed database. Therefore, this paper introduces a correlation mechanism that is able to identify and improve how remote database nodes exchange information during analytical execution. The mechanism can achieve bandwidth savings in the order of three times and it is expected to increase as the number of database nodes involved grow.
The DAIS 2017 was held between 19th and 21th June 2017 in Neuchatel, Switzerland, and is one of three conferences that are part of the 12th International Federated Conference on Distributed Computing Techniques (DisCoTec).
+ info: http://haslab.uminho.pt/
