loading
Documents

Research.Publish.Connect.

Paper

Automatic View Selection for Distributed Dimensional Data

Topics: Business, Finance and Management; Data Management for Large Data; Large-scale Information Systems and Applications; Modeling, Experiments, Sharing Technologies & Platforms; Software Frameworks (MapReduce, Spark etc) and Simulations; SQL/NoSQL databases, Data Processing Techniques, Visualization and Modern Technologies

Authors: Leandro Ordonez-Ante ; Gregory Van Seghbroeck ; Tim Wauters ; Bruno Volckaert and Filip De Turck

Affiliation: Ghent University - imec, IDLab, Department of Information Technology, Technologiepark-Zwijnaarde 15, Gent and Belgium

ISBN: 978-989-758-369-8

Keyword(s): Interactive Querying, View Selection, Clustering, Distributed Data, Dimensional Data, Data Warehouse.

Abstract: Small-to-medium businesses are increasingly relying on big data platforms to run their analytical workloads in a cost-effective manner, instead of using conventional and costly data warehouse systems. However, the distributed nature of big data technologies makes it time-consuming to process typical analytical queries, especially those involving aggregate and join operations, preventing business users from performing efficient data exploration. In this sense, a workload-driven approach for automatic view selection was devised, aimed at speeding up analytical queries issued against distributed dimensional data. This paper presents a detailed description of the proposed approach, along with an extensive evaluation to test its feasibility. Experimental results shows that the conceived mechanism is able to automatically derive a limited but comprehensive set of views able to reduce query processing time by up to 89%–98%.

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 18.206.241.26

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:
Ordonez-Ante, L.; Van Seghbroeck, G.; Wauters, T.; Volckaert, B. and De Turck, F. (2019). Automatic View Selection for Distributed Dimensional Data.In Proceedings of the 4th International Conference on Internet of Things, Big Data and Security - Volume 1: IoTBDS, ISBN 978-989-758-369-8, pages 17-28. DOI: 10.5220/0007555700170028

@conference{iotbds19,
author={Leandro Ordonez{-}Ante. and Gregory Van Seghbroeck. and Tim Wauters. and Bruno Volckaert. and Filip De Turck.},
title={Automatic View Selection for Distributed Dimensional Data},
booktitle={Proceedings of the 4th International Conference on Internet of Things, Big Data and Security - Volume 1: IoTBDS,},
year={2019},
pages={17-28},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0007555700170028},
isbn={978-989-758-369-8},
}

TY - CONF

JO - Proceedings of the 4th International Conference on Internet of Things, Big Data and Security - Volume 1: IoTBDS,
TI - Automatic View Selection for Distributed Dimensional Data
SN - 978-989-758-369-8
AU - Ordonez-Ante, L.
AU - Van Seghbroeck, G.
AU - Wauters, T.
AU - Volckaert, B.
AU - De Turck, F.
PY - 2019
SP - 17
EP - 28
DO - 10.5220/0007555700170028

Login or register to post comments.

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