{"id":"https://openalex.org/W2069555406","doi":"https://doi.org/10.1145/1989323.1989396","title":"Efficient auditing for complex SQL queries","display_name":"Efficient auditing for complex SQL queries","publication_year":2011,"publication_date":"2011-06-12","ids":{"openalex":"https://openalex.org/W2069555406","doi":"https://doi.org/10.1145/1989323.1989396","mag":"2069555406"},"language":"en","primary_location":{"id":"doi:10.1145/1989323.1989396","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1989323.1989396","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2011 ACM SIGMOD International Conference on Management of data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5103280746","display_name":"Raghav Kaushik","orcid":"https://orcid.org/0000-0003-1457-1384"},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Raghav Kaushik","raw_affiliation_strings":["Microsoft Research, Redmond, WA, USA"],"affiliations":[{"raw_affiliation_string":"Microsoft Research, Redmond, WA, USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5102897731","display_name":"Ravi Ramamurthy","orcid":null},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ravi Ramamurthy","raw_affiliation_strings":["Microsoft Corporation, Redmond, WA, USA"],"affiliations":[{"raw_affiliation_string":"Microsoft Corporation, Redmond, WA, USA","institution_ids":["https://openalex.org/I1290206253"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5103280746"],"corresponding_institution_ids":["https://openalex.org/I1290206253"],"apc_list":null,"apc_paid":null,"fwci":4.551,"has_fulltext":false,"cited_by_count":22,"citation_normalized_percentile":{"value":0.94724113,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"697","last_page":"708"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9993000030517578,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9993000030517578,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9983000159263611,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.996999979019165,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/audit","display_name":"Audit","score":0.9010865092277527},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8324425220489502},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7390975952148438},{"id":"https://openalex.org/keywords/perspective","display_name":"Perspective (graphical)","score":0.4876933991909027},{"id":"https://openalex.org/keywords/audit-trail","display_name":"Audit trail","score":0.4679141640663147},{"id":"https://openalex.org/keywords/information-security-audit","display_name":"Information security audit","score":0.45082494616508484},{"id":"https://openalex.org/keywords/class","display_name":"Class (philosophy)","score":0.4320881962776184},{"id":"https://openalex.org/keywords/computer-security","display_name":"Computer security","score":0.4009135961532593},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.36860257387161255},{"id":"https://openalex.org/keywords/accounting","display_name":"Accounting","score":0.12444174289703369},{"id":"https://openalex.org/keywords/information-security","display_name":"Information security","score":0.10301941633224487},{"id":"https://openalex.org/keywords/business","display_name":"Business","score":0.09115135669708252},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.07699903845787048}],"concepts":[{"id":"https://openalex.org/C199521495","wikidata":"https://www.wikidata.org/wiki/Q181487","display_name":"Audit","level":2,"score":0.9010865092277527},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8324425220489502},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7390975952148438},{"id":"https://openalex.org/C12713177","wikidata":"https://www.wikidata.org/wiki/Q1900281","display_name":"Perspective (graphical)","level":2,"score":0.4876933991909027},{"id":"https://openalex.org/C80958533","wikidata":"https://www.wikidata.org/wiki/Q1047174","display_name":"Audit trail","level":3,"score":0.4679141640663147},{"id":"https://openalex.org/C39358052","wikidata":"https://www.wikidata.org/wiki/Q2578632","display_name":"Information security audit","level":5,"score":0.45082494616508484},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.4320881962776184},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.4009135961532593},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.36860257387161255},{"id":"https://openalex.org/C121955636","wikidata":"https://www.wikidata.org/wiki/Q4116214","display_name":"Accounting","level":1,"score":0.12444174289703369},{"id":"https://openalex.org/C527648132","wikidata":"https://www.wikidata.org/wiki/Q189900","display_name":"Information security","level":2,"score":0.10301941633224487},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.09115135669708252},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.07699903845787048},{"id":"https://openalex.org/C29983905","wikidata":"https://www.wikidata.org/wiki/Q7445066","display_name":"Security service","level":3,"score":0.0},{"id":"https://openalex.org/C117110713","wikidata":"https://www.wikidata.org/wiki/Q3394676","display_name":"Network security policy","level":4,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1989323.1989396","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1989323.1989396","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2011 ACM SIGMOD International Conference on Management of data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","display_name":"Peace, Justice and strong institutions","score":0.7599999904632568}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":19,"referenced_works":["https://openalex.org/W16887288","https://openalex.org/W253264081","https://openalex.org/W1531366036","https://openalex.org/W1605782097","https://openalex.org/W1943411325","https://openalex.org/W1964934924","https://openalex.org/W2013682225","https://openalex.org/W2043226436","https://openalex.org/W2047658315","https://openalex.org/W2048001632","https://openalex.org/W2075827270","https://openalex.org/W2087154854","https://openalex.org/W2114423840","https://openalex.org/W2139551853","https://openalex.org/W2152191782","https://openalex.org/W2156717879","https://openalex.org/W2169002078","https://openalex.org/W2484915486","https://openalex.org/W3023740622"],"related_works":["https://openalex.org/W2331734816","https://openalex.org/W2373849942","https://openalex.org/W4210317576","https://openalex.org/W2080460539","https://openalex.org/W1796495254","https://openalex.org/W4400666451","https://openalex.org/W2352946410","https://openalex.org/W2368348502","https://openalex.org/W1563611063","https://openalex.org/W2750461430"],"abstract_inverted_index":{"We":[0],"address":[1,94],"the":[2,28,43,54,90],"problem":[3],"of":[4,13,27,45],"data":[5,32,61],"auditing":[6,33,62,73],"that":[7,18,47],"asks":[8],"for":[9,75],"an":[10,72],"audit":[11],"trail":[12],"all":[14],"users":[15],"and":[16,41,85,105],"queries":[17,46,78],"potentially":[19],"breached":[20],"information":[21],"about":[22],"sensitive":[23],"data.":[24],"A":[25],"lot":[26],"previous":[29],"work":[30],"in":[31],"has":[34],"focused":[35],"on":[36,89],"providing":[37],"strong":[38],"privacy":[39,100],"guarantees":[40,101],"studied":[42],"class":[44],"can":[48,103,108],"be":[49],"audited":[50],"efficiently":[51,109],"while":[52],"retaining":[53],"guarantees.":[55],"In":[56],"this":[57],"paper,":[58],"we":[59,97,102,107],"approach":[60],"from":[63],"a":[64],"different":[65],"perspective.":[66],"Our":[67],"goal":[68],"is":[69],"to":[70,92],"design":[71],"system":[74],"arbitrary":[76,95],"SQL":[77],"containing":[79],"constructs":[80],"such":[81],"as":[82],"grouping,":[83],"aggregation":[84],"correlated":[86],"subqueries.":[87],"Pivoted":[88],"ability":[91],"feasibly":[93],"queries,":[96],"study":[98],"(1)~what":[99],"expect,":[104],"(2)~how":[106],"perform":[110],"auditing.":[111]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":6},{"year":2012,"cited_by_count":3}],"updated_date":"2026-01-13T01:12:25.745995","created_date":"2025-10-10T00:00:00"}