SharedDB: Killing One Thousand Queries With One Stone

被引:66
作者
Giannikis, Georgios [1 ]
Alonso, Gustavo [1 ]
Kossmann, Donald [1 ]
机构
[1] Swiss Fed Inst Technol, Dept Comp Sci, Syst Grp, Zurich, Switzerland
来源
PROCEEDINGS OF THE VLDB ENDOWMENT | 2012年 / 5卷 / 06期
基金
瑞士国家科学基金会;
关键词
D O I
10.14778/2168651.2168654
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
Traditional database systems are built around the query-at-a-time model. This approach tries to optimize performance in a best-effort way. Unfortunately, best effort is not good enough for many modern applications. These applications require response time guarantees in high load situations. This paper describes the design of a new database architecture that is based on batching queries and shared computation across possibly hundreds of concurrent queries and updates. Performance experiments with the TPC-W benchmark show that the performance of our implementation, SharedDB, is indeed robust across a wide range of dynamic workloads.
引用
收藏
页码:526 / 537
页数:12
相关论文
共 29 条
[11]  
Finkelstein S., 1982, P ACM SIGMOD INT C M, P235
[12]  
Fischer PM, 2005, PROC INT CONF DATA, P902
[13]  
HAAS LM, 1989, SIGMOD REC, V18, P377, DOI 10.1145/66926.66962
[14]  
Harizopoulos S., 2005, P ACM SIGMOD INT C M, P383, DOI DOI 10.1145/1066157.1066201
[15]  
Harizopoulos S., 2005, IEEE DATA ENG B, V28, P11
[16]  
Helmer S, 1997, PROCEEDINGS OF THE TWENTY-THIRD INTERNATIONAL CONFERENCE ON VERY LARGE DATABASES, P386
[17]  
Heman S., 2007, P 3 INT WORKSH DAT M, P1
[18]  
Ivanova MG, 2009, ACM SIGMOD/PODS 2009 CONFERENCE, P309
[19]  
Kim C., 2009, P VLDB, P1378
[20]   Cache investment: Integrating query optimization and distributed data placement [J].
Kossmann, D ;
Franklin, MJ ;
Drasch, G .
ACM TRANSACTIONS ON DATABASE SYSTEMS, 2000, 25 (04) :517-558