{"id":"https://openalex.org/W2024834471","doi":"https://doi.org/10.1145/2588555.2588578","title":"A formal approach to finding explanations for database queries","display_name":"A formal approach to finding explanations for database queries","publication_year":2014,"publication_date":"2014-06-18","ids":{"openalex":"https://openalex.org/W2024834471","doi":"https://doi.org/10.1145/2588555.2588578","mag":"2024834471"},"language":"en","primary_location":{"id":"doi:10.1145/2588555.2588578","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2588555.2588578","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},"type":"conference-paper","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/A5110322079","display_name":"Sudeepa Roy","orcid":null},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sudeepa Roy","raw_affiliation_strings":["University of Washington, Seattle, WA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Washington, Seattle, WA, USA","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5048204602","display_name":"Dan Suciu","orcid":"https://orcid.org/0000-0002-4144-0868"},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Dan Suciu","raw_affiliation_strings":["University of Washington, Seattle, WA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Washington, Seattle, WA, USA","institution_ids":["https://openalex.org/I201448701"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I201448701"],"apc_list":null,"apc_paid":null,"fwci":10.2113,"has_fulltext":false,"cited_by_count":135,"citation_normalized_percentile":{"value":0.99055544,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"1579","last_page":"1590"},"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.9987999796867371,"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.9987999796867371,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9980999827384949,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"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.9959999918937683,"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/computer-science","display_name":"Computer science","score":0.8349108099937439},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.7848612666130066},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7662075757980347},{"id":"https://openalex.org/keywords/popularity","display_name":"Popularity","score":0.5531080961227417},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5427340269088745},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.50177001953125},{"id":"https://openalex.org/keywords/variety","display_name":"Variety (cybernetics)","score":0.47203198075294495},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.46266651153564453},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.43525630235671997},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.13186165690422058},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.12789884209632874},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.09737694263458252}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8349108099937439},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.7848612666130066},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7662075757980347},{"id":"https://openalex.org/C2780586970","wikidata":"https://www.wikidata.org/wiki/Q1357284","display_name":"Popularity","level":2,"score":0.5531080961227417},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5427340269088745},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.50177001953125},{"id":"https://openalex.org/C136197465","wikidata":"https://www.wikidata.org/wiki/Q1729295","display_name":"Variety (cybernetics)","level":2,"score":0.47203198075294495},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.46266651153564453},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.43525630235671997},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.13186165690422058},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.12789884209632874},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.09737694263458252},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C77805123","wikidata":"https://www.wikidata.org/wiki/Q161272","display_name":"Social psychology","level":1,"score":0.0},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/2588555.2588578","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2588555.2588578","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.647.757","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.647.757","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://homes.cs.washington.edu/~sudeepa/sigmod2014-explanation.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.46000000834465027,"display_name":"Partnerships for the goals","id":"https://metadata.un.org/sdg/17"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":25,"referenced_works":["https://openalex.org/W144096106","https://openalex.org/W284239745","https://openalex.org/W1491318920","https://openalex.org/W1507625188","https://openalex.org/W1558832481","https://openalex.org/W1961009203","https://openalex.org/W2017137564","https://openalex.org/W2022953760","https://openalex.org/W2047182010","https://openalex.org/W2074663022","https://openalex.org/W2115010808","https://openalex.org/W2118370002","https://openalex.org/W2124026371","https://openalex.org/W2131920243","https://openalex.org/W2145429839","https://openalex.org/W2159080219","https://openalex.org/W2263581552","https://openalex.org/W2625773614","https://openalex.org/W3133236490","https://openalex.org/W4206031975","https://openalex.org/W4247303118","https://openalex.org/W6629137921","https://openalex.org/W6633513001","https://openalex.org/W6681432938","https://openalex.org/W7075292137"],"related_works":["https://openalex.org/W3030674916","https://openalex.org/W119841348","https://openalex.org/W2171948294","https://openalex.org/W2573939812","https://openalex.org/W316061934","https://openalex.org/W2120098008","https://openalex.org/W4312445213","https://openalex.org/W1639806124","https://openalex.org/W2902831276","https://openalex.org/W2540682188"],"abstract_inverted_index":{"As":[0],"a":[1,12,59,87,110],"consequence":[2],"of":[3,6,14,74,90,95,112,160],"the":[4,77,82,93,117,142,156],"popularity":[5],"big":[7],"data,":[8],"many":[9],"users":[10,48],"with":[11,101],"variety":[13],"backgrounds":[15],"seek":[16],"to":[17,43,46,62,67,115],"extract":[18],"high":[19],"level":[20],"information":[21],"from":[22,25,76],"datasets":[23],"collected":[24],"various":[26],"sources":[27],"and":[28,132,158],"combined":[29],"using":[30,146],"data":[31,40],"integration":[32],"techniques.":[33],"A":[34],"major":[35],"challenge":[36],"for":[37,65,119],"research":[38],"in":[39,49,92,123],"management":[41,149],"is":[42],"develop":[44],"tools":[45],"assist":[47],"explaining":[50],"observed":[51],"query":[52,83],"outputs.":[53],"In":[54],"this":[55],"paper":[56],"we":[57,108,129],"introduce":[58],"principled":[60],"approach":[61,162],"provide":[63,86],"explanations":[64,144],"answers":[66],"SQL":[68,137],"queries":[69,138],"based":[70,135],"on":[71,136,165],"intervention:":[72],"removal":[73],"tuples":[75],"database":[78,148],"that":[79,139],"significantly":[80],"affect":[81],"answers.":[84],"We":[85,154],"formal":[88],"definition":[89],"intervention":[91,118],"presence":[94],"multiple":[96],"relations":[97],"which":[98],"can":[99,140],"interact":[100],"each":[102],"other":[103],"through":[104],"foreign":[105],"keys.":[106],"First":[107],"give":[109,130],"set":[111],"recursive":[113],"rules":[114],"compute":[116,141],"any":[120],"given":[121],"explanation":[122],"polynomial":[124],"time":[125],"(data":[126],"complexity).":[127],"Then":[128],"simple":[131],"efficient":[133],"algorithms":[134],"top-K":[143],"by":[145,163],"standard":[147],"systems":[150],"under":[151],"certain":[152],"conditions.":[153],"evaluate":[155],"quality":[157],"performance":[159],"our":[161],"experiments":[164],"real":[166],"datasets.":[167]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":6},{"year":2024,"cited_by_count":8},{"year":2023,"cited_by_count":8},{"year":2022,"cited_by_count":10},{"year":2021,"cited_by_count":10},{"year":2020,"cited_by_count":22},{"year":2019,"cited_by_count":24},{"year":2018,"cited_by_count":8},{"year":2017,"cited_by_count":12},{"year":2016,"cited_by_count":11},{"year":2015,"cited_by_count":13},{"year":2014,"cited_by_count":1}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}