2019
DOI: 10.1002/dac.3940
|View full text |Cite
|
Sign up to set email alerts
|

Query optimization mechanisms in the cloud environments: A systematic study

Abstract: SummaryThe goal of a query optimizer is to provide an optimal Query Execution Plan (QEP) by comparing alternative query plans. In a distributed database system over cloud environment, the relations required by a query plan may be stored at multiple sites. This leads to an exponential increase in the number of possible equivalent plan alternatives to find an optimal QEP. Although it is not computationally reasonable to explore exhaustively all possible plans in such large search space. Although query optimizati… Show more

Help me understand this report

Search citation statements

Order By: Relevance

Paper Sections

Select...
3
1
1

Citation Types

2
13
0

Year Published

2019
2019
2023
2023

Publication Types

Select...
6
1

Relationship

2
5

Authors

Journals

citations
Cited by 24 publications
(15 citation statements)
references
References 88 publications
2
13
0
Order By: Relevance
“…2) CheckLog. U checks the validity of the auditing results as follows: a) acquire t (1) , t (1) + ϕ + 1, derive the actual time when the audit was performed from t (1) and t (1) + ϕ + 1, and reject if the time does not match the agreed one; b) extract t1 from the blockchain, and reject if the extraction fails; c) check whether t1 matches the entry in the first row of f , and rejects if t1 does not match the agreed one; d) compute τ = H(name n r 1 P K U ), i…”
Section: And Providementioning
confidence: 99%
See 2 more Smart Citations
“…2) CheckLog. U checks the validity of the auditing results as follows: a) acquire t (1) , t (1) + ϕ + 1, derive the actual time when the audit was performed from t (1) and t (1) + ϕ + 1, and reject if the time does not match the agreed one; b) extract t1 from the blockchain, and reject if the extraction fails; c) check whether t1 matches the entry in the first row of f , and rejects if t1 does not match the agreed one; d) compute τ = H(name n r 1 P K U ), i…”
Section: And Providementioning
confidence: 99%
“…Massive data at local storage cause a series of difficulty in management. To reduce heavy burden of data storage and maintenance in local storage, many users choose to outsource their data into cloud [1]. As an excellent tool, cloud brings tremendous benefits and convenience to our life.…”
Section: Introductionmentioning
confidence: 99%
See 1 more Smart Citation
“…This query is also taking more space during this data process [18]. To avoid this problem query optimization is also needed [19]. Energy consuming, necessary memories, operating time, essential storage are some of the perspectives that have to be considered during the optimization process [20].…”
Section: Problem Statementmentioning
confidence: 99%
“…Cloud computing is a new paradigm of a service delivery model. 1,2 The primary aim of cloud computing is providing on-demand, reliable, scalable, and available services in distributed environments. [3][4][5] Recently, it has gained high popularity for its efficient resource usage and convenient service access.…”
Section: Introductionmentioning
confidence: 99%