Adaptive Query Processing in Cloud Database Systems

被引:3
|
作者
Costa, Clayton Maciel [1 ,2 ]
Sousa, Antonio Luis [2 ,3 ]
机构
[1] Inst Fed Rio Grande Norte, HASLab, Ipanguacu, Brazil
[2] Univ Minho, INESC TEC, Braga, Portugal
[3] Univ Minho, HASLab, Braga, Portugal
基金
欧盟第七框架计划;
关键词
cloud computing; database systems; adaptive query processing;
D O I
10.1109/CGC.2013.39
中图分类号
TP3 [计算技术、计算机技术];
学科分类号
0812 ;
摘要
In cloud environments, resources should be acquired and released automatically and quickly at runtime. Thereby, the implementation of traditional query optimization strategies in cloud platforms can have a poor performance, because they cannot predict future availability and/or release of resources. In such scenarios, adaptive query processing can adapt itself to the available resources to run queries and, consequently, present an acceptable performance in response to a query. However, traditional and adaptive query optimizers main objective is to reduce response time. Moreover, in the context of cloud computing, users and providers of services expect to get answers in time to guarantee the SLA. Therefore, we propose a framework that uses adaptive query processing based on heuristic rules and cost of failing the SLA. It will be implemented on structured data, considering that some cloud computing platforms support SQL queries directly or indirectly, which makes this problem relevant.
引用
收藏
页码:201 / +
页数:2
相关论文
共 50 条
  • [1] Efficient SQL Adaptive Query Processing in Cloud Databases Systems
    Costa, Clayton Maciel
    Maia Leite, Cicilia Raquel
    Sousa, Antonio Luis
    [J]. PROCEEDINGS OF THE 2016 IEEE CONFERENCE ON EVOLVING AND ADAPTIVE INTELLIGENT SYSTEMS (EAIS), 2016, : 114 - 121
  • [2] Adaptive Time, Monetary Cost Aware Query Optimization on Cloud Database Systems
    Wang, Chenxiao
    Arani, Zach
    Gruenwald, Le
    d'Orazio, Laurent
    [J]. 2018 IEEE INTERNATIONAL CONFERENCE ON BIG DATA (BIG DATA), 2018, : 3374 - 3382
  • [3] QUERY PROCESSING IN DISTRIBUTED DATABASE SYSTEMS
    HEVNER, AR
    YAO, SB
    [J]. IEEE TRANSACTIONS ON SOFTWARE ENGINEERING, 1979, 5 (03) : 177 - 187
  • [4] An adaptive query processing method according to system environments in database broadcasting systems
    Kashita, M
    Terada, T
    Hara, T
    Tsukamoto, M
    Nishio, S
    [J]. COMPUTERS AND THEIR APPLICATIONS, 2003, : 174 - 179
  • [5] Statistical analysis of query processing time in cache-based cloud database systems
    Nanda, Ruchi
    Sharma, Amita
    Choraria, Pooja
    Pareek, Astha
    Tiwari, Neha
    Jain, Anubha
    [J]. JOURNAL OF STATISTICS AND MANAGEMENT SYSTEMS, 2022, 25 (07) : 1673 - 1683
  • [6] Query Processing and Optimization in Distributed Database Systems
    Alom, B. M. Monjurul
    Henskens, Frans
    Hannaford, Michael
    [J]. INTERNATIONAL JOURNAL OF COMPUTER SCIENCE AND NETWORK SECURITY, 2009, 9 (09): : 143 - 152
  • [7] Secure Query Processing with Data Interoperability in a Cloud Database Environment
    Wong, Wai Kit
    Kao, Ben
    Cheung, David Wai Lok
    Li, Rongbin
    Yiu, Siu Ming
    [J]. SIGMOD'14: PROCEEDINGS OF THE 2014 ACM SIGMOD INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2014, : 1395 - 1406
  • [8] A workload-driven approach to database query processing in the cloud
    Adnene Guabtni
    Rajiv Ranjan
    Fethi A. Rabhi
    [J]. The Journal of Supercomputing, 2013, 63 : 722 - 736
  • [9] A workload-driven approach to database query processing in the cloud
    Guabtni, Adnene
    Ranjan, Rajiv
    Rabhi, Fethi A.
    [J]. JOURNAL OF SUPERCOMPUTING, 2013, 63 (03): : 722 - 736
  • [10] The Research of Relational Database Query Processing Based on Cloud Platform
    Gu, Wei
    [J]. PROCEEDINGS OF THE 2017 INTERNATIONAL CONFERENCE ON ELECTRONIC INDUSTRY AND AUTOMATION (EIA 2017), 2017, 145 : 95 - 98