Matthew Woicik
Current Organizations / Institutes
The organizations/institutes from the scholar's latest article
Research Subjects
Research Interests
Matthew Woicik has a total of 6 co-authors. Here are the top co-authors by number of shared publications:
- Abdurrahman Ghanem
Qatar Computing Research Institute University of Massachusetts Amherst
1 shared publication - Ashraf Aboulnaga
Qatar Computing Research Institute HBKU Doha Qatar
1 shared publication - Marco Serafini
University of Wisconsin-Madison University of Wisconsin-Madison University of Massachusetts-Amherst Qatar Computing Research Institute Massachusetts Institute of Technology
1 shared publication - Matt Youill
Burnian
1 shared publication - Michael Stonebraker
MIT CSAIL, Cambridge, US
1 shared publication - Xiangyao Yu
University of Wisconsin-Madison, Madison, US
1 shared publication
Latest Publications
- Open Access
PushdownDB: Accelerating a DBMS using S3 Computation
This paper studies the effectiveness of pushing parts of DBMS analytics queries into the Simple Storage Service (S3) engine of Amazon Web Services (AWS), using a recently released capability called S3 Select. We show that some DBMS primitives (filter, projection, aggregation) can always be cost-effectively moved into S3. Other more complex operations (join, top-K, 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.
Open AccessPushdownDB: Accelerating a DBMS using S3 Computation
This paper studies the effectiveness of pushing parts of DBMS analytics queries into the Simple Storage Service (S3) engine of Amazon Web Services (AWS), using a recently released capability called S3 Select. We show that some DBMS primitives (filter, projection, aggregation) can always be cost-effectively moved into S3. Other more complex operations (join, top-K, 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.