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:20260308T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20261101T090000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Los_Angeles:20260508T130000
DTEND;TZID=America/Los_Angeles:20260508T140000
DTSTAMP:20260506T224520
CREATED:20260505T192616Z
LAST-MODIFIED:20260505T192616Z
UID:2430-1778245200-1778248800@isg.ics.uci.edu
SUMMARY:Pratyoy (UCI): SmartRabbit An Interactive Query Processor
DESCRIPTION:For this week’s ISG seminar\, Pratyoy will do his SIGMOD practice talk.\n\n\nTime & Location:\n\n\nFriday May 8\, 2026\, 1:00 PM – 2:00 PM\nDonald Bren Hall 3011\, ICS\, UC Irvine\n\n\nTitle: SmartRabbit: An Interactive Query Processor.\n\nAbstract:Traditional 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: Pratyoy 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\nZoom:\nhttps://uci.zoom.us/j/95509222811?pwd=2V8Hnx71iP6dyfNsEPoo97NUfCFWTo.1\n\nLunch will be provided.
URL:https://isg.ics.uci.edu/event/pratyoy-uci-smartrabbit-an-interactive-query-processor/
LOCATION:DBH 3011
END:VEVENT
END:VCALENDAR