BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Information Systems Group - ECPv6.4.0.1//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
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:20250309T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20251102T090000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Los_Angeles:20251031T130000
DTEND;TZID=America/Los_Angeles:20251031T140000
DTSTAMP:20260426T060100
CREATED:20251027T210415Z
LAST-MODIFIED:20251027T210415Z
UID:2282-1761915600-1761919200@isg.ics.uci.edu
SUMMARY:Pratyoy Das: SmartRabbit An Interactive Query Processor
DESCRIPTION:For this week’s IGS seminar\, Pratyoy will be presenting his research work.\n\nTime & Location:\n\n\nFriday Oct 31\, 2025\, 1:00 PM – 2:00 PM\nDonald Bren Hall 3011\, ICS\, UC Irvine \nLunch will be provided. \nTitle:\nSmartRabbit: An Interactive Query Processor \nAbstract: \nTraditional relational database systems optimize analytical queries to minimize their end-to-end latency. The resulting optimal plans are usually blocking\, forcing users to wait until full query completion before seeing any results. This execution model precludes interactivity\, i.e.\, users cannot observe partial results or gain early insights for long-running queries. Query optimizers rarely choose plans that promote interactivity\, since such plans either incur prohibitively large latencies or involve operators for which interactive alternatives are unavailable. We introduce a novel interactive query processor SmartRabbit that promotes interactivity of answers while matching the end-to-end latency of blocking execution plans. We achieve this by first designing a plan optimized for interactivity for a given query\, and then simultaneously executing this plan alongside a traditional blocking plan. The two executions are carefully synchronized to maintain the correct order of answers and prevent duplicates. We implement SmartRabbit in AsterixDB and show that SmartRabbit consistently delivers early and continuous results across various analytical queries\, data scales\, and parallel (multi-node\, multi-partition) system instances\, while matching the latencies of the standalone blocking executions.\n\nBio: \n\n\n\nPratyoy is a 4th year PhD student under Professor Sharad Mehrotra. His research focuses on query optimization and query execution with specific interests in adaptive\, interactive and progressive query optimization. Pratyoy had previously interned in the query optimization team of Amazon Redshift and was a Software Engineer at Microsoft before joining UC Irvine.\n\n\n\n\n\nVolunteer:\nXiaozhen Liu
URL:https://isg.ics.uci.edu/event/pratyoy-das-smartrabbit-an-interactive-query-processor/
LOCATION:DBH 3011
END:VEVENT
END:VCALENDAR