{"id":"https://openalex.org/W3197661828","doi":"https://doi.org/10.14778/3476311.3476353","title":"DICE","display_name":"DICE","publication_year":2021,"publication_date":"2021-07-01","ids":{"openalex":"https://openalex.org/W3197661828","doi":"https://doi.org/10.14778/3476311.3476353","mag":"3197661828"},"language":"en","primary_location":{"id":"doi:10.14778/3476311.3476353","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3476311.3476353","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-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/A5004937696","display_name":"El Kindi Rezig","orcid":"https://orcid.org/0000-0002-5187-3499"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"El Kindi Rezig","raw_affiliation_strings":["MIT CSAIL"],"affiliations":[{"raw_affiliation_string":"MIT CSAIL","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5112682973","display_name":"Anshul Bhandari","orcid":null},"institutions":[{"id":"https://openalex.org/I36909309","display_name":"National Institute of Technology Hamirpur","ror":"https://ror.org/01nc8zs04","country_code":"IN","type":"education","lineage":["https://openalex.org/I36909309","https://openalex.org/I4210152752"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Anshul Bhandari","raw_affiliation_strings":["NIT Hamirpur"],"affiliations":[{"raw_affiliation_string":"NIT Hamirpur","institution_ids":["https://openalex.org/I36909309"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5087503380","display_name":"Anna Fariha","orcid":"https://orcid.org/0000-0002-5275-7844"},"institutions":[{"id":"https://openalex.org/I24603500","display_name":"University of Massachusetts Amherst","ror":"https://ror.org/0072zz521","country_code":"US","type":"education","lineage":["https://openalex.org/I24603500"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Anna Fariha","raw_affiliation_strings":["University of Massachusetts Amherst"],"affiliations":[{"raw_affiliation_string":"University of Massachusetts Amherst","institution_ids":["https://openalex.org/I24603500"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5026927479","display_name":"Benjamin Price","orcid":"https://orcid.org/0000-0001-5497-4087"},"institutions":[{"id":"https://openalex.org/I4210122954","display_name":"MIT Lincoln Laboratory","ror":"https://ror.org/022z6jk58","country_code":"US","type":"facility","lineage":["https://openalex.org/I4210122954","https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Benjamin Price","raw_affiliation_strings":["MIT Lincoln Laboratory"],"affiliations":[{"raw_affiliation_string":"MIT Lincoln Laboratory","institution_ids":["https://openalex.org/I4210122954"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5061071407","display_name":"Allan Vanterpool","orcid":null},"institutions":[{"id":"https://openalex.org/I4210089612","display_name":"United States Air Force","ror":"https://ror.org/006gmme17","country_code":"US","type":"funder","lineage":["https://openalex.org/I1330347796","https://openalex.org/I4210089612","https://openalex.org/I4210102105"]},{"id":"https://openalex.org/I4389425236","display_name":"U.S. Air Force Test Center","ror":"https://ror.org/04k0tth05","country_code":null,"type":"facility","lineage":["https://openalex.org/I1330347796","https://openalex.org/I4210102105","https://openalex.org/I4389425236","https://openalex.org/I4389425425"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Allan Vanterpool","raw_affiliation_strings":["United States Air Force"],"affiliations":[{"raw_affiliation_string":"United States Air Force","institution_ids":["https://openalex.org/I4210089612","https://openalex.org/I4389425236"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5043450560","display_name":"Vijay Gadepally","orcid":"https://orcid.org/0000-0002-4598-2808"},"institutions":[{"id":"https://openalex.org/I4210122954","display_name":"MIT Lincoln Laboratory","ror":"https://ror.org/022z6jk58","country_code":"US","type":"facility","lineage":["https://openalex.org/I4210122954","https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Vijay Gadepally","raw_affiliation_strings":["MIT Lincoln Laboratory"],"affiliations":[{"raw_affiliation_string":"MIT Lincoln Laboratory","institution_ids":["https://openalex.org/I4210122954"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5074724644","display_name":"Michael Stonebraker","orcid":"https://orcid.org/0000-0001-9184-9058"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Michael Stonebraker","raw_affiliation_strings":["MIT CSAIL"],"affiliations":[{"raw_affiliation_string":"MIT CSAIL","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5004937696"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.0913,"has_fulltext":false,"cited_by_count":18,"citation_normalized_percentile":{"value":0.87033853,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":99},"biblio":{"volume":"14","issue":"12","first_page":"2819","last_page":"2822"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9998000264167786,"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"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9998000264167786,"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/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/T10215","display_name":"Semantic Web and Ontologies","score":0.9977999925613403,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/dice","display_name":"Dice","score":0.8805347084999084},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7678777575492859},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.7040212154388428},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6261478066444397},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3931303918361664},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.33435699343681335}],"concepts":[{"id":"https://openalex.org/C22029948","wikidata":"https://www.wikidata.org/wiki/Q45089","display_name":"Dice","level":2,"score":0.8805347084999084},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7678777575492859},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.7040212154388428},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6261478066444397},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3931303918361664},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.33435699343681335},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3476311.3476353","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3476311.3476353","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":16,"referenced_works":["https://openalex.org/W1911540707","https://openalex.org/W2007324466","https://openalex.org/W2038123353","https://openalex.org/W2057513751","https://openalex.org/W2275996142","https://openalex.org/W2518579368","https://openalex.org/W2585438896","https://openalex.org/W2626990892","https://openalex.org/W2795089200","https://openalex.org/W2966332071","https://openalex.org/W3011387886","https://openalex.org/W3011590361","https://openalex.org/W3013864782","https://openalex.org/W3102480827","https://openalex.org/W3135723248","https://openalex.org/W4255584681"],"related_works":["https://openalex.org/W3104750253","https://openalex.org/W3021239166","https://openalex.org/W4366341510","https://openalex.org/W2390936256","https://openalex.org/W2483429559","https://openalex.org/W2016385589","https://openalex.org/W2009559548","https://openalex.org/W2906397153","https://openalex.org/W2385445039","https://openalex.org/W3093723769"],"abstract_inverted_index":{"In":[0],"order":[1],"to":[2,10,50,157,210],"conduct":[3],"analytical":[4],"tasks,":[5],"data":[6,13,20,43,80,90,93,102,110,194,247],"scientists":[7,111],"often":[8,113],"need":[9],"find":[11,51],"relevant":[12,52],"from":[14],"an":[15,31,250],"avalanche":[16],"of":[17,73,78,121],"sources":[18],"(e.g.,":[19,60],"lakes,":[21,94],"large":[22],"organizational":[23],"databases).":[24],"This":[25,84],"effort":[26],"is":[27,67,86,97,156,234],"typically":[28,46],"made":[29],"in":[30,82,92,246],"ad":[32],"hoc,":[33],"non-systematic":[34],"manner,":[35],"which":[36],"makes":[37],"it":[38,70],"a":[39,117,159,175,182,207],"daunting":[40],"endeavour.":[41],"Current":[42],"discovery":[44,248],"systems":[45],"require":[47],"the":[48,74,79,107,150,164,193,201,220,225,229,232,237],"users":[49],"tables":[53,191],"manually,":[54],"usually":[55],"by":[56,125,136,186,205],"issuing":[57],"multiple":[58],"queries":[59,66,185],"using":[61],"SQL).":[62],"However,":[63],"expressing":[64],"such":[65],"nontrivial,":[68],"as":[69,142],"requires":[71],"knowledge":[72],"underlying":[75],"structure":[76],"(schema)":[77],"organization":[81],"advance.":[83],"issue":[85],"further":[87],"exacerbated":[88],"when":[89],"resides":[91],"where":[95],"there":[96],"no":[98],"predefined":[99],"schema":[100],"that":[101,148,162],"must":[103],"conform":[104],"to.":[105],"On":[106],"other":[108],"hand,":[109],"can":[112,244],"come":[114],"up":[115],"with":[116,200,236],"few":[118,183,208],"example":[119,140],"records":[120,141,147,209],"interest":[122],"quickly.":[123],"Motivated":[124],"this":[126,171],"observation,":[127],"we":[128],"developed":[129],"DICE---a":[130],"human-in-the-loop":[131],"system":[132],"for":[133,203],"<u>D</u>ata":[134],"d<u>I</u>s<u>C</u>overy":[135],"<u>E</u>xample---that":[137],"takes":[138],"user-provided":[139],"input":[143],"and":[144,227],"returns":[145],"more":[146],"satisfy":[149],"user":[151,165,202,221,233],"intent.":[152],"DICE's":[153],"key":[154],"idea":[155],"synthesize":[158],"SQL":[160],"query":[161],"captures":[163],"intent,":[166],"specified":[167],"via":[168],"examples.":[169],"To":[170],"end,":[172],"DICE":[173,179,198,223,243],"follows":[174],"three-step":[176],"process:":[177],"(1)":[178],"first":[180],"discovers":[181],"candidate":[184],"finding":[187],"join":[188],"paths":[189],"across":[190],"within":[192],"lake.":[195],"(2)":[196],"Then":[197],"consults":[199],"validation":[204],"presenting":[206],"them,":[211],"and,":[212],"thus,":[213],"eliminating":[214],"spurious":[215],"queries.":[216],"(3)":[217],"Based":[218],"on":[219],"feedback,":[222],"refines":[224],"search":[226],"repeats":[228],"process":[230],"until":[231],"satisfied":[235],"results.":[238],"We":[239],"will":[240],"demonstrate":[241],"how":[242],"help":[245],"through":[249],"interactive,":[251],"example-based":[252],"interaction.":[253]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":5},{"year":2024,"cited_by_count":5},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2021-09-13T00:00:00"}