loading
Documents

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Fábio Coelho ; José Pereira ; Ricardo Vilaça and Rui Oliveira

Affiliation: INESC TEC & Universidade do Minho, Portugal

ISBN: 978-989-758-182-3

Keyword(s): Window Functions, Reactive Programming, Parallel Systems, OLAP, SQL.

Abstract: 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.

PDF ImageFull Text

Download
Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 54.242.193.41

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
Coelho, F.; Pereira, J.; Vilaça, R. and Oliveira, R. (2016). Reducing Data Transfer in Parallel Processing of SQL Window Functions.In Proceedings of the 6th International Conference on Cloud Computing and Services Science - Volume 1: DataDiversityConvergence, (CLOSER 2016) ISBN 978-989-758-182-3, pages 343-347. DOI: 10.5220/0005923603430347

@conference{datadiversityconvergence16,
author={Fábio Coelho. and José Pereira. and Ricardo Vila\c{C}a. and Rui Oliveira.},
title={Reducing Data Transfer in Parallel Processing of SQL Window Functions},
booktitle={Proceedings of the 6th International Conference on Cloud Computing and Services Science - Volume 1: DataDiversityConvergence, (CLOSER 2016)},
year={2016},
pages={343-347},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005923603430347},
isbn={978-989-758-182-3},
}

TY - CONF

JO - Proceedings of the 6th International Conference on Cloud Computing and Services Science - Volume 1: DataDiversityConvergence, (CLOSER 2016)
TI - Reducing Data Transfer in Parallel Processing of SQL Window Functions
SN - 978-989-758-182-3
AU - Coelho, F.
AU - Pereira, J.
AU - Vilaça, R.
AU - Oliveira, R.
PY - 2016
SP - 343
EP - 347
DO - 10.5220/0005923603430347

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.