BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Information Systems Group - ECPv6.4.0.1//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Information Systems Group
X-ORIGINAL-URL:https://isg.ics.uci.edu
X-WR-CALDESC:Events for Information Systems Group
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Los_Angeles
BEGIN:DAYLIGHT
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
TZNAME:PDT
DTSTART:20230312T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20231105T090000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Los_Angeles:20230526T130000
DTEND;TZID=America/Los_Angeles:20230526T140000
DTSTAMP:20260419T195718
CREATED:20230522T213103Z
LAST-MODIFIED:20230522T213103Z
UID:1577-1685106000-1685109600@isg.ics.uci.edu
SUMMARY:Qiushi Bai: Improving SQL Performance Using Middleware-Based Query Rewriting
DESCRIPTION:Abstract: \nQuery performance is critical in database-supported applications where users need answers quickly to make timely decisions. Traditional databases rely on rewriting queries to improve SQL performance. With the emergence of business intelligence and interactive visualization applications\, databases often miss opportunities to rewrite their queries\, due to reasons such as failure to adopt high-accuracy time estimators to choose efficient plans\, and missing domain-specific rewriting rules valid only for specific datasets. We focus on middleware-based query-rewriting solutions to address the problem since\, in many cases\, both the application and database layer are black boxes. First\, we develop Maliva\, a machine-learning-based technique that leverages high-accuracy query-time estimators to rewrite queries under time constraints. Second\, we present QueryBooster\, a human-centered query rewriting framework that provides an easy-to-use language for users to formulate rewriting rules based on their domain knowledge. Finally\, to make it easy for users to optimize their application queries\, we propose a middleware-based system called Squidster that provides query rewriting as a service. Our experiments in real and synthetic datasets show the effectiveness of the proposed solutions in improving end-to-end SQL query performance. \n  \nIn this talk\, we will focus on the QueryBooster and Squidster work. We will show a demo to motivate the problem and demonstrate the effectiveness and convenience of using the QueryBooster system to improve SQL query performance. \n  \nBio: \nQiushi Bai is a final year Ph.D. candidate in the Computer Science Department at UC Irvine. He received his Master’s and Bachelor’s degrees in CS from Northeastern University in China. His research interests have focused on improving query performance for big data analytics.
URL:https://isg.ics.uci.edu/event/qiushi-bai-improving-sql-performance-using-middleware-based-query-rewriting/
LOCATION:DBH 4011
END:VEVENT
END:VCALENDAR