Pushdowndb: Accelerating A Dbms Using S3 Computation
2020 IEEE 36TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE 2020)(2020)
摘要
This paper studies the effectiveness of pushing parts of DBMS analytics queries into the Simple Storage Service (S3) of Amazon Web Services (AWS), using a recently released capability called S3 Select. We show that some DBMS primitives (filter, projection, and aggregation) can always be cost-effectively moved into S3. Other more complex operations (join, top-K, and group by) require reimplementation to take advantage of S3 Select and are often candidates for pushdown. We demonstrate these capabilities through experimentation using a new DBMS that we developed, PushdownDB. Experimentation with a collection of queries including TPC-H queries shows that PushdownDB is on average 30% cheaper and 6.7x faster than a baseline that does not use S3 Select.
更多查看译文
关键词
Simple Storage Service,Amazon Web Services,S3 Select,PushdownDB,S3 Computation,DBMS analytics queries
AI 理解论文
溯源树
样例
生成溯源树,研究论文发展脉络