Logo: University of Southern California

Events Calendar



Select a calendar:



Filter April Events by Event Type:



Events for April 30, 2020

  • PhD Defense -

    Thu, Apr 30, 2020 @ 10:00 AM - 01:00 PM

    Computer Science

    University Calendar


    Title: Detecting SQL Antipatterns in Mobile Applications

    PhD Candidate: Yingjun Lyu

    Committee:

    William GJ Halfond (Chair)
    Neno Medvidovic
    Chao Wang
    Jyo Deshmukh
    Sandeep Gupta

    Local databases underpin important features in many mobile applications. However, bad programming practices of using database operations, also called SQL antipatterns, can introduce high resource consumption, affect the responsiveness, and undermine the security of a mobile application.
    In my dissertation, I designed and evaluated a framework, called SAND, to detect SQL antipatterns effectively and efficiently in mobile apps. The framework abstracts away the interactions between the application and the database. It provides a language that allows the framework users to query abstractions of application-database relationships and specify SQL antipattern detection tasks. To determine what kinds of application-database relationships should be abstracted, I first conducted a systematic literature review to collect a comprehensive list of SQL antipatterns and their detection approaches. I then analyzed the collected detection approaches and derived the abstractions from them. In order to extract the abstractions from the database access code, I developed a range of static analysis techniques that can analyze the database access code effectively and efficiently. Using experiments on the framework implementation for Android, I showed that SAND can be used to compactly (in 12-74 lines of code) specify SQL antipattern detection tasks previously reported in the literature. These detectors built on top of SAND precisely identified thousands of instances of SQL antipatterns with a precision of at least 99.4%. These detectors were also fast as applying eleven detectors only took an average of forty-one seconds per app. Overall, these results are positive and indicate that my framework can detect all kinds of SQL antipatterns effectively and efficiently in mobile apps.

    WebCast Link: https://usc.zoom.us/j/94586333967

    Audiences: Everyone Is Invited

    Posted By: Lizsl De Leon

    OutlookiCal
  • Astani Civil and Environmental Engineering Seminar

    Thu, Apr 30, 2020 @ 02:00 PM - 03:00 PM

    Sonny Astani Department of Civil and Environmental Engineering

    Conferences, Lectures, & Seminars


    Speaker: Dr. Rui Huang, University of Texas, Austin

    Talk Title: TBA

    Host: Dr. Qiming Wang

    Audiences: Everyone Is Invited

    Posted By: Evangeline Reyes

    OutlookiCal
  • Undergraduate Admission Virtual Information Session

    Thu, Apr 30, 2020 @ 02:00 PM - 03:00 PM

    Viterbi School of Engineering Undergraduate Admission

    Workshops & Infosessions


    Our virtual information session is a live presentation from a USC Viterbi admission counselor designed for prospective first-year students and their family members to learn more about the USC Viterbi undergraduate experience.Our session will cover an overview of our undergraduate engineering programs, the application process, and more on student life.Guests will be able to ask questions and engage in further discussion toward the end of the session.

    Please register here!

    Audiences: Everyone Is Invited

    Posted By: Viterbi Admission

    OutlookiCal
  • CAIS++ Spring 2020 Projects Showcase

    Thu, Apr 30, 2020 @ 07:00 PM - 08:00 PM

    Computer Science

    Student Activity


    We are CAIS++, the undergraduate branch of USC's Center for Artificial Intelligence in Society (CAIS). Our mission is to advance AI for social good, and our group of 50+ students works with professors, startups, and community organizations to develop cutting-edge AI solutions for societal problems.

    We're inviting you to our Spring 2020 Projects Showcase on April 30 from 7-8:00 pm on Zoom (link below). Our student teams will be presenting the AI projects that they have worked on this semester. Some of the projects that will be presented at showcase include developing machine learning approaches for
    *Diagnosing Kawasaki disease
    *Generalized gene sequencing classification
    *Detecting deepfakes and manipulated media
    *Improving building security systems

    We will be recruiting a new cohort of undergraduates in Fall 2020, so coming to our showcase is a great way to learn about CAIS++ and see the type of work we do!

    If you're able to attend, please RSVP to our Facebook event:
    https://www.facebook.com/events/356918301922839/

    and join us on this Zoom link:
    (zoom link was emailed directly to CS community on April 20th)

    Best,
    The CAIS++ Team
    http://caisplusplus.usc.edu/index.html

    Location: Zoom

    Audiences: Everyone Is Invited

    Posted By: Ryan Rozan

    OutlookiCal