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:20220313T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20221106T090000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Los_Angeles:20220606T120000
DTEND;TZID=America/Los_Angeles:20220606T133000
DTSTAMP:20260424T094531
CREATED:20220531T175900Z
LAST-MODIFIED:20220531T182239Z
UID:1446-1654516800-1654522200@isg.ics.uci.edu
SUMMARY:Jayant Haritsa (IISc Bangalore): Shedding Light on Opaque Database Queries
DESCRIPTION:Shedding Light on Opaque Database Queries\nlocation: \nDonald Bren Hall 3011 \nSpeaker:  Jayant Haritsa \n                 Database Systems Lab \n                 Indian Institute of Science\, Bangalore \nAbstract: We have recently defined a new query reverse-engineering problem of unmasking SQL queries hidden within opaque database applications. The diverse industrial use-cases for this problem range from resurrecting legacy code to query rewriting.  It poses hard and novel intellectual challenges due to the presence of a variety of complexities such as dependencies between the query clauses\, schematic renaming in the output attributes\, result consolidation due to aggregates\, and presence of computed column functions. \nIn this talk\, we motivate the hidden query extraction problem\, and then present UNMASQUE\, an extraction algorithm based on an active learning approach\, that successfully exposes a complex class of hidden warehouse queries. A special feature of its design is that the extraction is completely non-invasive with respect to the application\, examining only the results obtained from repeated executions on databases derived with a combination of data mutation and data generation techniques. Further\, potent optimizations are incorporated to minimize the extraction overheads. A detailed evaluation over applications hosting hidden SQL queries\, or their imperative versions\, demonstrates that UNMASQUE correctly and efficiently extracts these queries. \nWhile the above represents a first step in query extraction\, a suite of open research problems that remain to be solved will be covered at the end of the talk. \nBio: Jayant Haritsa is on the computer science faculty at the Indian Institute of Science\, Bangalore\, since 1993. He received a BTech degree from the Indian Institute of Technology (Madras)\, and MS and PhD degrees from the University of Wisconsin (Madison).  He is a Fellow of ACM and IEEE\, and currently the President of ACM India.
URL:https://isg.ics.uci.edu/event/jayant-haritsa-iisc-bangalore-shedding-light-on-opaque-database-queries/
LOCATION:DBH 3011
END:VEVENT
END:VCALENDAR