November 9 Database Seminar - SQL Log Summarization - UB Student Presentation
Details
This meetup will be at 7PM on Wednesday, November 9, in 338A Davis Hall on the UB North Campus. See below for directions.
This will be a presentation by some of the UB CS Students.
--- Title --- SQL Log Summarization
--- Presenters --- Gokhan Kul, Ting Xie, Duc Thanh Luong
--- Summary --- SQL logs provide a good model of a user's behavior. Hence, auditing SQL query logs can help with a variety of tasks, from optimizing a database to match user needs, to detecting malicious users. Unfortunately, query logs are large, and summarizing them correctly requires a computer system that has an 'intuitive' sense of what the query intends to do. However, capturing the intent of a query is often ambiguous, and situation-dependent. We'll start by talking about a few existing techniques for detecting queries with similar intent, and point out some ways in which these techniques fall short.
Then we'll describe a query-intent benchmark we came up with to compare the performance of these methods. This benchmark uses student-written queries fulfilling specific tasks in a SQL exam as our test data and measures the performance of each method in recognizing thes tasks behind these queries.
One improvement to the existing techniques that we found, we call query regularization. Since the grammar of SQL is declarative, users can write queries in the way they feel most comfortable, and the same end goal can be expressed through many different equivalent queries. We'll dive into how queries can be standardized, and show how this process improves a most of the existing query similarity techniques.
Directions to Davis 338A.
Davis Hall is on White Rd, not far from the Bookstore. 338A is on the 3rd floor. The Jarvis B lot is just across the road. No parking permit is required after 3PM.
(Special note: We have created a google group, https://groups.google.com/forum/#!forum/buffalodata (https://groups.google.com/forum/#%21forum/buffalodata), for communicating about this meetup group and other things related to data. While we will continue to advertise on meetup.com and nextplex.com and probably the bocc and buffalolab groups, I will eventually retire my infamous email lists. Please join the group.)
Sponsors for this season are EngineYard (https://www.engineyard.com/) and Stark and Wayne (https://starkandwayne.com/). We will continue our tradition of light refreshments at 7:00 with the presentation at 7:15. Please rsvp (https://www.meetup.com/buffalolab/events/233669894/) so we know how many are coming. (Also, if there are any last minute announcements they will be sent to those who have rsvp'd and members of the BuffaloData google group.)
