{"id":"https://openalex.org/W3177222803","doi":"https://doi.org/10.1145/3448016.3457249","title":"To Not Miss the Forest for the Trees - A Holistic Approach for Explaining Missing Answers over Nested Data","display_name":"To Not Miss the Forest for the Trees - A Holistic Approach for Explaining Missing Answers over Nested Data","publication_year":2021,"publication_date":"2021-06-09","ids":{"openalex":"https://openalex.org/W3177222803","doi":"https://doi.org/10.1145/3448016.3457249","mag":"3177222803"},"language":"en","primary_location":{"id":"doi:10.1145/3448016.3457249","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3448016.3457249","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3448016.3457249","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2021 International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3448016.3457249","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5041289033","display_name":"Ralf Diestelk\u00e4mper","orcid":null},"institutions":[{"id":"https://openalex.org/I100066346","display_name":"University of Stuttgart","ror":"https://ror.org/04vnq7t77","country_code":"DE","type":"education","lineage":["https://openalex.org/I100066346"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Ralf Diestelk\u00e4mper","raw_affiliation_strings":["Universit\u00e4t Stuttgart - IPVS, Stuttgart, Germany"],"affiliations":[{"raw_affiliation_string":"Universit\u00e4t Stuttgart - IPVS, Stuttgart, Germany","institution_ids":["https://openalex.org/I100066346"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5079405484","display_name":"Seokki Lee","orcid":"https://orcid.org/0000-0002-5637-252X"},"institutions":[{"id":"https://openalex.org/I63135867","display_name":"University of Cincinnati","ror":"https://ror.org/01e3m7079","country_code":"US","type":"education","lineage":["https://openalex.org/I63135867"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Seokki Lee","raw_affiliation_strings":["University of Cincinnati, Cincinnati, OH, USA"],"affiliations":[{"raw_affiliation_string":"University of Cincinnati, Cincinnati, OH, USA","institution_ids":["https://openalex.org/I63135867"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5087589863","display_name":"Melanie Herschel","orcid":"https://orcid.org/0009-0007-9821-5921"},"institutions":[{"id":"https://openalex.org/I100066346","display_name":"University of Stuttgart","ror":"https://ror.org/04vnq7t77","country_code":"DE","type":"education","lineage":["https://openalex.org/I100066346"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Melanie Herschel","raw_affiliation_strings":["Universit\u00e4t Stuttgart - IPVS, Stuttgart, Germany"],"affiliations":[{"raw_affiliation_string":"Universit\u00e4t Stuttgart - IPVS, Stuttgart, Germany","institution_ids":["https://openalex.org/I100066346"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5061858093","display_name":"Boris Glavic","orcid":"https://orcid.org/0000-0003-2887-2452"},"institutions":[{"id":"https://openalex.org/I180949307","display_name":"Illinois Institute of Technology","ror":"https://ror.org/037t3ry66","country_code":"US","type":"education","lineage":["https://openalex.org/I180949307"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Boris Glavic","raw_affiliation_strings":["Illinois Institute of Technology, Chicago, IL, USA"],"affiliations":[{"raw_affiliation_string":"Illinois Institute of Technology, Chicago, IL, USA","institution_ids":["https://openalex.org/I180949307"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5041289033"],"corresponding_institution_ids":["https://openalex.org/I100066346"],"apc_list":null,"apc_paid":null,"fwci":5.5191,"has_fulltext":true,"cited_by_count":13,"citation_normalized_percentile":{"value":0.95875627,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"405","last_page":"417"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9993000030517578,"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"}},"topics":[{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9993000030517578,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.996399998664856,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.9958000183105469,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7982571125030518},{"id":"https://openalex.org/keywords/missing-data","display_name":"Missing data","score":0.7101332545280457},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.6525599956512451},{"id":"https://openalex.org/keywords/debugging","display_name":"Debugging","score":0.6013338565826416},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4733569622039795},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.45734190940856934},{"id":"https://openalex.org/keywords/spark","display_name":"SPARK (programming language)","score":0.4515756666660309},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.45076048374176025},{"id":"https://openalex.org/keywords/data-integrity","display_name":"Data integrity","score":0.4316953420639038},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3757270574569702},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.20865094661712646},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.19543462991714478},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.19283455610275269}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7982571125030518},{"id":"https://openalex.org/C9357733","wikidata":"https://www.wikidata.org/wiki/Q6878417","display_name":"Missing data","level":2,"score":0.7101332545280457},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.6525599956512451},{"id":"https://openalex.org/C168065819","wikidata":"https://www.wikidata.org/wiki/Q845566","display_name":"Debugging","level":2,"score":0.6013338565826416},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4733569622039795},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.45734190940856934},{"id":"https://openalex.org/C2781215313","wikidata":"https://www.wikidata.org/wiki/Q3493345","display_name":"SPARK (programming language)","level":2,"score":0.4515756666660309},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.45076048374176025},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.4316953420639038},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3757270574569702},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.20865094661712646},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.19543462991714478},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.19283455610275269}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3448016.3457249","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3448016.3457249","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3448016.3457249","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2021 International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3448016.3457249","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3448016.3457249","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3448016.3457249","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2021 International Conference on Management of Data","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G108573351","display_name":"III: Medium: Collaborative Research: U4U - Taming Uncertainty with Uncertainty-Annotated Databases","funder_award_id":"1956123","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G4104632002","display_name":null,"funder_award_id":"-EXC 2075 -390740016","funder_id":"https://openalex.org/F4320320879","funder_display_name":"Deutsche Forschungsgemeinschaft"},{"id":"https://openalex.org/G5106512922","display_name":null,"funder_award_id":"Deutsche Forschungsgemeinschaft (DFG","funder_id":"https://openalex.org/F4320320879","funder_display_name":"Deutsche Forschungsgemeinschaft"},{"id":"https://openalex.org/G5456246324","display_name":null,"funder_award_id":"OAC-1640864","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G5543094940","display_name":null,"funder_award_id":"EXC 2075 -390740016","funder_id":"https://openalex.org/F4320320879","funder_display_name":"Deutsche Forschungsgemeinschaft"},{"id":"https://openalex.org/G5643887040","display_name":null,"funder_award_id":"EXC 2075 - 390740016","funder_id":"https://openalex.org/F4320320879","funder_display_name":"Deutsche Forschungsgemeinschaft"},{"id":"https://openalex.org/G6024419964","display_name":null,"funder_award_id":"Deutsche Forschungsgemeinschaft (DFG)","funder_id":"https://openalex.org/F4320320879","funder_display_name":"Deutsche Forschungsgemeinschaft"},{"id":"https://openalex.org/G6052429835","display_name":null,"funder_award_id":"(DFG)","funder_id":"https://openalex.org/F4320320879","funder_display_name":"Deutsche Forschungsgemeinschaft"},{"id":"https://openalex.org/G6942502395","display_name":null,"funder_award_id":"IIS #1956123 and OAC #1640864","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G7478733536","display_name":null,"funder_award_id":"1640864","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G8784604414","display_name":null,"funder_award_id":"390740016","funder_id":"https://openalex.org/F4320320879","funder_display_name":"Deutsche Forschungsgemeinschaft"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320320879","display_name":"Deutsche Forschungsgemeinschaft","ror":"https://ror.org/018mejw64"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3177222803.pdf","grobid_xml":"https://content.openalex.org/works/W3177222803.grobid-xml"},"referenced_works_count":41,"referenced_works":["https://openalex.org/W135267584","https://openalex.org/W1975612259","https://openalex.org/W1978478796","https://openalex.org/W1996545223","https://openalex.org/W1998982581","https://openalex.org/W2003889154","https://openalex.org/W2005048938","https://openalex.org/W2022171653","https://openalex.org/W2024958874","https://openalex.org/W2029138494","https://openalex.org/W2030433745","https://openalex.org/W2057294899","https://openalex.org/W2082156752","https://openalex.org/W2089434603","https://openalex.org/W2103219113","https://openalex.org/W2103598815","https://openalex.org/W2105819430","https://openalex.org/W2133986470","https://openalex.org/W2141933093","https://openalex.org/W2157060173","https://openalex.org/W2159720813","https://openalex.org/W2403572391","https://openalex.org/W2439212191","https://openalex.org/W2535959639","https://openalex.org/W2548125635","https://openalex.org/W2583864825","https://openalex.org/W2743230100","https://openalex.org/W2753109262","https://openalex.org/W2766945679","https://openalex.org/W2784053383","https://openalex.org/W2798866333","https://openalex.org/W2889190943","https://openalex.org/W2935254085","https://openalex.org/W2950063476","https://openalex.org/W2955815015","https://openalex.org/W2963123445","https://openalex.org/W3013738447","https://openalex.org/W3013753857","https://openalex.org/W3135932187","https://openalex.org/W3177222803","https://openalex.org/W6657893237"],"related_works":["https://openalex.org/W4321442002","https://openalex.org/W2015265939","https://openalex.org/W2284072287","https://openalex.org/W2611067230","https://openalex.org/W2480201319","https://openalex.org/W2387706296","https://openalex.org/W2155788121","https://openalex.org/W4235469518","https://openalex.org/W362492756","https://openalex.org/W2890345561"],"abstract_inverted_index":{"Query-based":[0],"explanations":[1,26,147],"for":[2,13,107],"missing":[3,19,85,124],"answers":[4],"identify":[5],"which":[6],"operators":[7,68],"of":[8,21,25,75,84],"a":[9,18,50,93,108],"query":[10,109],"are":[11,38],"responsible":[12],"the":[14,59,71,76,123,137],"failure":[15],"to":[16,31,53,61,66,122,139,141,152],"return":[17],"answer":[20],"interest.":[22],"This":[23],"type":[24],"has":[27],"proven":[28],"useful,":[29],"e.g.,":[30],"debug":[32],"complex":[33],"analytical":[34],"queries.":[35],"Such":[36],"queries":[37],"frequent":[39],"in":[40],"big":[41],"data":[42,64,77],"systems":[43],"such":[44],"as":[45,81],"Apache":[46],"Spark.":[47],"We":[48],"present":[49],"novel":[51,99],"approach":[52,135],"produce":[54],"query-based":[55],"explanations.":[56],"It":[57],"is":[58,136],"first":[60,138],"support":[62],"nested":[63],"and":[65,73,110],"consider":[67],"that":[69,96,133,148],"modify":[70],"schema":[72,105],"structure":[74],"(e.g.,":[78],"nesting,":[79],"projections)":[80],"potential":[82],"causes":[83],"answers.":[86],"To":[87],"efficiently":[88],"compute":[89],"explanations,":[90],"we":[91,131],"propose":[92],"heuristic":[94],"algorithm":[95],"applies":[97],"two":[98],"techniques:":[100],"(i)":[101],"reasoning":[102],"about":[103],"multiple":[104],"alternatives":[106],"(ii)":[111],"re-validating":[112],"at":[113],"each":[114],"step":[115],"whether":[116],"an":[117,127],"intermediate":[118],"result":[119],"can":[120],"contribute":[121],"answer.":[125],"Using":[126],"implementation":[128],"on":[129],"Spark,":[130],"demonstrate":[132],"our":[134],"scale":[140],"large":[142],"datasets":[143],"while":[144],"often":[145],"finding":[146],"existing":[149],"techniques":[150],"fail":[151],"identify.":[153]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2}],"updated_date":"2026-03-18T14:38:29.013473","created_date":"2025-10-10T00:00:00"}