An Economical Query Cost Model in the Cloud

Brighen, Assia; Bellatreche, Ladjel; Slimani, Hachem; Faget, Zoé

doi:10.1007/978-3-642-40270-8_2

Cited by 2 publications

(2 citation statements)

References 17 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Cloud Computing is a new paradigm that refers to the use of computing resources on demand through a global network [4]. Cloud computing may be defined as a payper-use model for enabling on-demand access to reliable and configurable resources that can be quickly provisioned and released with minimal management.…”

Section: A Cloud Computingmentioning

confidence: 99%

See 1 more Smart Citation

Optimisation of the queries execution plan in cloud data warehouses

Ettaoufik

Ouzzif

2015

2015 5th World Congress on Information and Communication Technologies (WICT)

View full text Add to dashboard Cite

Our everyday massive data processing activities and making correct decisions require a specific work environment. The cloud computing provides a flexible environment for customers to host and process their information through an outsourced infrastructure. This information was habitually located on local servers. Many applications dealing with massive data is routed to the cloud. Data Warehouse (DW) also benefit from this new paradigm to provide analytical data online and in real time. DW in the Cloud benefited of its advantages such flexibility, availability, adaptability, scalability, virtualization, etc. Improving the DW performance in the cloud requires the optimization of data processing time. The classical optimization techniques (indexing, materialized views and fragmentation) are still essential for DW in the cloud. The DW is partitioned before being distributed across multiple servers (nodes) in the Cloud. When queries containing multiple joins or ask voluminous data stored on multiple nodes, inter-node communication increases and consequently the DW performance degrades. In this paper, we propose an approach for improving the performance of DW in the cloud. Our approach is based on a classification technique of requests received by the nodes. For this purpose we use an algorithm based on the MapReduce programming model, this algorithm allows to identify the list of requests sent to the DW hosted in the cloud, and classify queries by the publication frequency. From the list of search queries we propose a partitioning scheme of DW on different nodes in order to reduce the inter-node communication and therefore minimize the queries processing time.

show abstract

Section: A Cloud Computingmentioning

confidence: 99%

“…Figure 6 shows different execution plans for a query Q1executed in data warehouse hosted on cloud. Previous works proposed cost models related to materialized views in a data warehouse arranged in the cloud [5] [4]. The main objective of these works is to optimize the time response of queries in the cloud.…”

Section: ) Queries Execution Planmentioning

confidence: 99%