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 条
  • [31] A Novel Approach for SQL Query Optimization
    Mithani, Fazal
    Machchhar, Sahista
    Jasdanwala, Fernaz
    2016 IEEE INTERNATIONAL CONFERENCE ON COMPUTATIONAL INTELLIGENCE AND COMPUTING RESEARCH, 2016, : 898 - 901
  • [32] Query Processing: Beyond SQL and Relations
    Novikov, Boris
    ADVANCES IN DATABASES AND INFORMATION SYSTEMS, ADBIS 2015, 2015, 9282
  • [33] QUERY OPTIMIZATION IN MICROSOFT SQL SERVER
    Haxhijaha, Blerta
    Ajdari, Jaumin
    Raufi, Bujar
    Zenuni, Xhemal
    Ismaili, Florie
    INTERNATIONAL JOURNAL ON INFORMATION TECHNOLOGIES AND SECURITY, 2018, 10 (02): : 13 - 22
  • [34] Facilitating SQL Query Composition and Analysis
    Zolaktaf, Zainab
    Milani, Mostafa
    Pottinger, Rachel
    SIGMOD'20: PROCEEDINGS OF THE 2020 ACM SIGMOD INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2020, : 209 - 224
  • [35] Errors and Complications in SQL Query Formulation
    Taipalus, Toni
    Siponen, Mikko
    Vartiainen, Tero
    ACM TRANSACTIONS ON COMPUTING EDUCATION, 2018, 18 (03):
  • [36] Cleaning Antipatterns in an SQL Query Log
    Arzamasova, Natalia
    Schaeler, Martin
    Bohm, Klemens
    IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2018, 30 (03) : 421 - 434
  • [37] SQL query extensions for imprecise questions
    Le Guilly, Marie
    Petit, Jean-Marc
    Scuturici, Vasile-Marian
    Data and Knowledge Engineering, 2022, 137
  • [38] Qex: Symbolic SQL Query Explorer
    Veanes, Margus
    Tillmann, Nikolai
    de Halleux, Jonathan
    LOGIC FOR PROGRAMMING, ARTIFICIAL INTELLIGENCE, AND REASONING (LPAR-16), 2010, 6355 : 425 - 446
  • [39] Detection of SQL Injection Attacks by Removing the Parameter Values of SQL Query
    Katole, Rajashree A.
    Sherekar, Swati S.
    Thakare, Vilas M.
    PROCEEDINGS OF THE 2ND INTERNATIONAL CONFERENCE ON INVENTIVE SYSTEMS AND CONTROL (ICISC 2018), 2018, : 736 - 741
  • [40] Use of Visual Query System in teaching database query language SQL
    Chen, PK
    Sheen, CY
    Chen, GD
    ADVANCED RESEARCH IN COMPUTERS AND COMMUNICATIONS IN EDUCATION, VOL 1: NEW HUMAN ABILITIES FOR THE NETWORKED SOCIETY, 1999, 55 : 800 - 807