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 条
  • [1] Efficiently Translating Complex SQL Query to MapReduce Jobflow on Cloud
    Wu, Zhiang
    Song, Aibo
    Cao, Jie
    Luo, Junzhou
    Zhang, Lu
    IEEE TRANSACTIONS ON CLOUD COMPUTING, 2020, 8 (02) : 508 - 517
  • [2] Efficient SQL Adaptive Query Processing in Cloud Databases Systems
    Costa, Clayton Maciel
    Maia Leite, Cicilia Raquel
    Sousa, Antonio Luis
    PROCEEDINGS OF THE 2016 IEEE CONFERENCE ON EVOLVING AND ADAPTIVE INTELLIGENT SYSTEMS (EAIS), 2016, : 114 - 121
  • [3] Evaluation of Sub Query Performance in SQL Server
    Oktavia, Tanty
    Sujarwo, Surya
    ICASCE 2013 - INTERNATIONAL CONFERENCE ON ADVANCES SCIENCE AND CONTEMPORARY ENGINEERING, 2014, 68
  • [4] Generalizing and Improving SQL/XML Query Evaluation
    Boettcher, Stefan
    Bokermann, Dennis
    Hartel, Rita
    8TH INTERNATIONAL CONFERENCE ON SIGNAL IMAGE TECHNOLOGY & INTERNET BASED SYSTEMS (SITIS 2012), 2012, : 441 - 449
  • [5] A comparative evaluation of query modeling cost of SQL/MDR
    Jeong, D
    In, HP
    Lee, LS
    Third ACIS International Conference on Software Engineering Research, Managment and Applications, Proceedings, 2005, : 235 - 239
  • [6] SQL Query optimalization
    Cerna, Eva
    Herold, Petr
    Tyrychtr, Jan
    AGRARIAN PERSPECTIVES XVIII, VOL 3, 2009, : 71 - 74
  • [7] SQL Query optimalization
    Cerna, Eva
    Herold, Petr
    Tyrychtr, Jan
    AGRARIAN PERSPECTIVES XVIII, VOLS 1 AND 2, 2009,
  • [8] Integrity Authentication for SQL Query Evaluation on Outsourced Databases: A Survey
    Zhang, Bo
    Dong, Boxiang
    Wang, Wendy Hui
    IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2021, 33 (04) : 1601 - 1618
  • [9] Performance Evaluation of Low Latency Communication Alternatives in a Containerized Cloud Environment
    Gehberger, Daniel
    Balla, David
    Maliosz, Markosz
    Simon, Csaba
    PROCEEDINGS 2018 IEEE 11TH INTERNATIONAL CONFERENCE ON CLOUD COMPUTING (CLOUD), 2018, : 9 - 16
  • [10] SQL query modification algorithms
    Chou, D.
    Segev, A.
    Proceedings of the Jerusalem Conference on Information Technology, 1990,