Please use this identifier to cite or link to this item: http://hdl.handle.net/1822/52877

TitleReducing data transfer in parallel processing of SQL window functions
Author(s)Coelho, Fabio
Pereira, José
Vilaça, Ricardo Manuel Pereira
Oliveira, Rui Carlos Mendes de
KeywordsWindow Functions
Reactive Programming
Parallel Systems
OLAP
SQL
Issue date2016
PublisherSCITEPRESS
Abstract(s)Window functions are a sub-class of analytical operators that allow data to be handled in a derived view of a given relation, while taking into account their neighboring tuples. We propose a technique that can be used in the parallel execution of this operator when data is naturally partitioned. The proposed method benefits the cases where the required partitioning is not the natural partitioning employed. Preliminary evaluation shows that we are able to limit data transfer among parallel workers to 14% of the registered transfer when using a naive approach.
TypeConference paper
URIhttp://hdl.handle.net/1822/52877
ISBN9789897581823
DOI10.5220/0005923603430347
Peer-Reviewedyes
AccessRestricted access (UMinho)
Appears in Collections:HASLab - Artigos em atas de conferências internacionais (texto completo)

Files in This Item:
File Description SizeFormat 
59236.pdf
  Restricted access
170,11 kBAdobe PDFView/Open

Partilhe no FacebookPartilhe no TwitterPartilhe no DeliciousPartilhe no LinkedInPartilhe no DiggAdicionar ao Google BookmarksPartilhe no MySpacePartilhe no Orkut
Exporte no formato BibTex mendeley Exporte no formato Endnote Adicione ao seu ORCID