{"id":13284,"date":"2022-01-01T00:00:00","date_gmt":"2022-01-01T08:00:00","guid":{"rendered":"https:\/\/www.hmc.edu\/clinic\/?p=13284"},"modified":"2022-05-16T09:11:01","modified_gmt":"2022-05-16T16:11:01","slug":"catching-uncareful-code-static-analysis-of-arbitrary-data-queries","status":"publish","type":"post","link":"https:\/\/www.hmc.edu\/clinic\/2022\/catching-uncareful-code-static-analysis-of-arbitrary-data-queries\/","title":{"rendered":"Catching Uncareful Code: Static Analysis of (Arbitrary) Data Queries"},"content":{"rendered":"<h2 class=\"project-sponsor-dept-year\"><span class=\"project-sponsor\">ServiceNow<\/span> <span class=\"project-dept-year\">Computer Science, 2021\u201322<\/span><\/h2>\n<div class=\"project-team\">\n<p><strong>Liaison(s):<\/strong> Kyle Barron-Kraus, Magaly Drant, Marie Harrington<br \/>\n<strong>Advisor(s):<\/strong> Beth Trushkowsky<br \/>\n<strong>Students(s):<\/strong> Ria Gopu (PM-S), Tatsuki Kuze (PM-F), Dolly Efuye, Kip Lim, Josh Cordova<\/p>\n<\/div>\n<div class=\"project-abstract\">\n<p>ServiceNow provides an enterprise service management platform that allows clients to customize their own applications via their instance\u2019s user interface or in JavaScript for automating their company\u2019s common workflows. Sometimes, clients write applications that contain inefficient database queries. This project aims to reduce the number of deployments of such queries by creating a tool for client developers that conducts static analysis of scripted queries before runtime and produces warning messages for inefficient queries in their code.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>ServiceNow Computer Science, 2021\u201322 Liaison(s): Kyle Barron-Kraus, Magaly Drant, Marie Harrington Advisor(s): Beth Trushkowsky Students(s): Ria Gopu (PM-S), Tatsuki Kuze [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[140],"tags":[157],"class_list":["post-13284","post","type-post","status-publish","format-standard","hentry","category-computer-science","tag-servicenow"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.hmc.edu\/clinic\/wp-json\/wp\/v2\/posts\/13284","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hmc.edu\/clinic\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hmc.edu\/clinic\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hmc.edu\/clinic\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hmc.edu\/clinic\/wp-json\/wp\/v2\/comments?post=13284"}],"version-history":[{"count":1,"href":"https:\/\/www.hmc.edu\/clinic\/wp-json\/wp\/v2\/posts\/13284\/revisions"}],"predecessor-version":[{"id":13307,"href":"https:\/\/www.hmc.edu\/clinic\/wp-json\/wp\/v2\/posts\/13284\/revisions\/13307"}],"wp:attachment":[{"href":"https:\/\/www.hmc.edu\/clinic\/wp-json\/wp\/v2\/media?parent=13284"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hmc.edu\/clinic\/wp-json\/wp\/v2\/categories?post=13284"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hmc.edu\/clinic\/wp-json\/wp\/v2\/tags?post=13284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}