Containerized SQL Query Evaluation in a Cloud

被引:2
|
作者
Zhang, Weining [1 ]
Holland, David [1 ]
机构
[1] Univ Texas San Antonio, Dept Comp Sci, San Antonio, TX 78249 USA
关键词
Database-as-a-Service; software container; cloud computing; query evaluation; OpenStack; ZeroVM;
D O I
10.1109/SmartCity.2015.202
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
Recent advance in cloud computing and lightweight software container technology opens up opportunities to execute data intensive applications where data is located. Noticeably, current database services offered on cloud platforms have not fully utilized container technologies. In this paper we present an architecture of a cloud-based, relational database as a service (DBaaS) that can package and deploy a query evaluation plan using light-weight container technology and the underlying cloud storage system. We then focus on an example of how a select-join-project-order query can be containerized and deployed in ZeroCloud. Our preliminary experimental results confirm that a containerized query can achieve a high degree of elasticity and scalability, but effective mechanisms are needed to deal with data skew.
引用
收藏
页码:1010 / 1017
页数:8
相关论文
共 50 条
  • [21] Query Translation from SQL to XPath
    Vidhya, P. M.
    Samuel, Philip
    2009 WORLD CONGRESS ON NATURE & BIOLOGICALLY INSPIRED COMPUTING (NABIC 2009), 2009, : 1748 - +
  • [22] Cleaning Antipatterns in an SQL Query Log
    Arzamasova, Natalia
    Schaeler, Martin
    Boehm, Klemens
    2018 IEEE 34TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE), 2018, : 1751 - 1752
  • [23] UNMASQUE: A Hidden SQL Query Extractor
    Khurana, Kapil
    Haritsa, Jayant R.
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2020, 13 (12): : 2809 - 2812
  • [24] Forecasting SQL Query Cost at Twitter
    Tang, Chunxu
    Wang, Beinan
    Luo, Zhenxiao
    Wu, Huijun
    Dasan, Shajan
    Fu, Maosong
    Li, Yao
    Ghosh, Mainak
    Kabra, Ruchin
    Navadiya, Nikhil Kantibhai
    Cheng, Da
    Dai, Fred
    Channapattan, Vrushali
    Mishra, Prachi
    2021 IEEE INTERNATIONAL CONFERENCE ON CLOUD ENGINEERING, IC2E 2021, 2021, : 154 - 160
  • [25] Query Execution Optimization in Spark SQL
    Ji, Xuechun
    Zhao, Maoxian
    Zhai, Mingyu
    Wu, Qingxi
    SCIENTIFIC PROGRAMMING, 2020, 2020 (2020)
  • [26] An approach to integrating query refinement in SQL
    Ortega-Binderberger, M
    Chakrabarti, K
    Mehrotra, S
    ADVANCES IN DATABASE TECHNOLOGY - EDBT 2002, 2002, 2287 : 15 - 33
  • [27] Similarity Metrics for SQL Query Clustering
    Kul, Gokhan
    Duc Thanh Anh Luong
    Xie, Ting
    Chandola, Varun
    Kennedy, Oliver
    Upadhyaya, Shambhu
    IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2018, 30 (12) : 2408 - 2420
  • [28] SQL query extensions for imprecise questions
    Le Guilly, Marie
    Petit, Jean-Marc
    Scuturici, Vasile-Marian
    DATA & KNOWLEDGE ENGINEERING, 2022, 137
  • [29] USABILITY OF SQL AND MENUS FOR DATABASE QUERY
    DAVIS, JS
    INTERNATIONAL JOURNAL OF MAN-MACHINE STUDIES, 1989, 30 (04): : 447 - 455
  • [30] SPATIAL SQL - A QUERY AND PRESENTATION LANGUAGE
    EGENHOFER, MJ
    IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 1994, 6 (01) : 86 - 95