Reducing Data Transfer in Parallel Processing of SQL Window Functions

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

Research.Publish.Connect.

*Please fill out at least one Field. *Value must be an number!

Title:
ISBN:
Year:
Acronym:
Subject:

Advanced Search Proceedings Search

If you're looking for an exact phrase use quotation marks on text fields.

*Please fill out at least one Field.

Title:
Author:
Affiliation:
Subject:

Advanced Search Papers Search

If you're looking for an exact phrase use quotation marks on text fields.

*Please fill out at least one Field.

Name:
Affiliation:
Country:
Conference:
Subject:

Advanced Search Authors Search

If you're looking for an exact phrase use quotation marks on text fields.

*Please fill out at least one Field.

Name:
Country:
Subject:

Advanced Search Affiliations Search

If you're looking for an exact phrase use quotation marks on text fields.

Proceedings

Proceedings Search *Please fill out at least one Field. *Value must be an number!

Title:
ISBN:
Year:
Acronym:
Subject:

Advanced Search Proceedings Search

If you're looking for an exact phrase use quotation marks on text fields.

Papers

Papers Search *Please fill out at least one Field.

Title:
Author:
Affiliation:
Subject:

Advanced Search Papers Search

If you're looking for an exact phrase use quotation marks on text fields.

Authors

Authors Search *Please fill out at least one Field.

Name:
Affiliation:
Country:
Conference:
Subject:

Advanced Search Authors Search

If you're looking for an exact phrase use quotation marks on text fields.

Advanced Search

Paper

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, 343-347, 2016 , Rome, Italy

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

Affiliation: INESC TEC & Universidade do Minho, Portugal

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.

CC BY-NC-ND 4.0

Guest: Register as new SciTePress user now for free.

SciTePress user: please login.

My Papers

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

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 (CLOSER 2016) - Volume 1: DataDiversityConvergence; ISBN 978-989-758-182-3; ISSN 2184-5042, SciTePress, 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 (CLOSER 2016) - Volume 1: DataDiversityConvergence},
year={2016},
pages={343-347},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005923603430347},
isbn={978-989-758-182-3},
issn={2184-5042},
}

TY - CONF

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