{"id":"https://openalex.org/W2415539709","doi":"https://doi.org/10.1145/2939502.2939509","title":"The exception that improves the rule","display_name":"The exception that improves the rule","publication_year":2016,"publication_date":"2016-06-17","ids":{"openalex":"https://openalex.org/W2415539709","doi":"https://doi.org/10.1145/2939502.2939509","mag":"2415539709"},"language":"en","primary_location":{"id":"doi:10.1145/2939502.2939509","is_oa":true,"landing_page_url":"https://doi.org/10.1145/2939502.2939509","pdf_url":"http://dl.acm.org/ft_gateway.cfm?id=2939509&type=pdf","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Workshop on Human-In-the-Loop Data Analytics","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"http://dl.acm.org/ft_gateway.cfm?id=2939509&type=pdf","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5006773757","display_name":"Juliana Freire","orcid":"https://orcid.org/0000-0003-3915-7075"},"institutions":[{"id":"https://openalex.org/I57206974","display_name":"New York University","ror":"https://ror.org/0190ak572","country_code":"US","type":"education","lineage":["https://openalex.org/I57206974"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Juliana Freire","raw_affiliation_strings":["New York University"],"affiliations":[{"raw_affiliation_string":"New York University","institution_ids":["https://openalex.org/I57206974"]}]},{"author_position":"middle","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"],"affiliations":[{"raw_affiliation_string":"Illinois Institute of Technology","institution_ids":["https://openalex.org/I180949307"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5071259962","display_name":"Oliver Kennedy","orcid":"https://orcid.org/0000-0003-0632-1668"},"institutions":[{"id":"https://openalex.org/I63190737","display_name":"University at Buffalo, State University of New York","ror":"https://ror.org/01y64my43","country_code":"US","type":"education","lineage":["https://openalex.org/I63190737"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Oliver Kennedy","raw_affiliation_strings":["University at Buffalo"],"affiliations":[{"raw_affiliation_string":"University at Buffalo","institution_ids":["https://openalex.org/I63190737"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5049329526","display_name":"Heiko M\u00fceller","orcid":null},"institutions":[{"id":"https://openalex.org/I57206974","display_name":"New York University","ror":"https://ror.org/0190ak572","country_code":"US","type":"education","lineage":["https://openalex.org/I57206974"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Heiko Mueller","raw_affiliation_strings":["New York University"],"affiliations":[{"raw_affiliation_string":"New York University","institution_ids":["https://openalex.org/I57206974"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5006773757"],"corresponding_institution_ids":["https://openalex.org/I57206974"],"apc_list":null,"apc_paid":null,"fwci":1.8864,"has_fulltext":true,"cited_by_count":4,"citation_normalized_percentile":{"value":0.90738705,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"6"},"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.9990000128746033,"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.9990000128746033,"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/T11719","display_name":"Data Quality and Management","score":0.9986000061035156,"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.9950000047683716,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8284132480621338},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.7268502712249756},{"id":"https://openalex.org/keywords/workflow","display_name":"Workflow","score":0.6792387366294861},{"id":"https://openalex.org/keywords/data-curation","display_name":"Data curation","score":0.6103124022483826},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5540984272956848},{"id":"https://openalex.org/keywords/interface","display_name":"Interface (matter)","score":0.44987550377845764},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4438228905200958},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.41225767135620117},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.367910772562027},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3289576768875122}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8284132480621338},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.7268502712249756},{"id":"https://openalex.org/C177212765","wikidata":"https://www.wikidata.org/wiki/Q627335","display_name":"Workflow","level":2,"score":0.6792387366294861},{"id":"https://openalex.org/C91632574","wikidata":"https://www.wikidata.org/wiki/Q15088675","display_name":"Data curation","level":2,"score":0.6103124022483826},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5540984272956848},{"id":"https://openalex.org/C113843644","wikidata":"https://www.wikidata.org/wiki/Q901882","display_name":"Interface (matter)","level":4,"score":0.44987550377845764},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4438228905200958},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.41225767135620117},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.367910772562027},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3289576768875122},{"id":"https://openalex.org/C157915830","wikidata":"https://www.wikidata.org/wiki/Q2928001","display_name":"Bubble","level":2,"score":0.0},{"id":"https://openalex.org/C129307140","wikidata":"https://www.wikidata.org/wiki/Q6795880","display_name":"Maximum bubble pressure method","level":3,"score":0.0},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2939502.2939509","is_oa":true,"landing_page_url":"https://doi.org/10.1145/2939502.2939509","pdf_url":"http://dl.acm.org/ft_gateway.cfm?id=2939509&type=pdf","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Workshop on Human-In-the-Loop Data Analytics","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/2939502.2939509","is_oa":true,"landing_page_url":"https://doi.org/10.1145/2939502.2939509","pdf_url":"http://dl.acm.org/ft_gateway.cfm?id=2939509&type=pdf","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Workshop on Human-In-the-Loop Data Analytics","raw_type":"proceedings-article"},"sustainable_development_goals":[{"display_name":"Quality Education","score":0.6399999856948853,"id":"https://metadata.un.org/sdg/4"}],"awards":[{"id":"https://openalex.org/G2245245228","display_name":null,"funder_award_id":"MEMEX","funder_id":"https://openalex.org/F4320332180","funder_display_name":"Defense Advanced Research Projects Agency"},{"id":"https://openalex.org/G4172168046","display_name":null,"funder_award_id":"MEMEX FA8750-14-2-023","funder_id":"https://openalex.org/F4320332180","funder_display_name":"Defense Advanced Research Projects Agency"},{"id":"https://openalex.org/G4711686421","display_name":null,"funder_award_id":"CNS-1229185","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G4713059963","display_name":null,"funder_award_id":"FA8750","funder_id":"https://openalex.org/F4320332180","funder_display_name":"Defense Advanced Research Projects Agency"},{"id":"https://openalex.org/G519871063","display_name":"MRI: Acquisition of an Infrastructure for Prototyping Next-Generation Algorithms for Large-Scale Visualization, Data Processing and Analysis","funder_award_id":"1229185","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320307904","display_name":"Oracle","ror":"https://ror.org/006c77m33"},{"id":"https://openalex.org/F4320332180","display_name":"Defense Advanced Research Projects Agency","ror":"https://ror.org/02caytj08"},{"id":"https://openalex.org/F4320332815","display_name":"Advanced Research Projects Agency","ror":"https://ror.org/02caytj08"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2415539709.pdf","grobid_xml":"https://content.openalex.org/works/W2415539709.grobid-xml"},"referenced_works_count":27,"referenced_works":["https://openalex.org/W4287097","https://openalex.org/W22495568","https://openalex.org/W200275619","https://openalex.org/W1153724553","https://openalex.org/W1497542708","https://openalex.org/W1551291454","https://openalex.org/W2038765730","https://openalex.org/W2039649893","https://openalex.org/W2064766209","https://openalex.org/W2077207253","https://openalex.org/W2098935637","https://openalex.org/W2122088005","https://openalex.org/W2131932522","https://openalex.org/W2133986470","https://openalex.org/W2136530502","https://openalex.org/W2144593768","https://openalex.org/W2167486417","https://openalex.org/W2261869874","https://openalex.org/W2266577992","https://openalex.org/W2288912372","https://openalex.org/W2439594319","https://openalex.org/W2604108381","https://openalex.org/W4285719527","https://openalex.org/W4321508328","https://openalex.org/W6600916657","https://openalex.org/W6633158399","https://openalex.org/W6735804363"],"related_works":["https://openalex.org/W2267077731","https://openalex.org/W2386578196","https://openalex.org/W3091612633","https://openalex.org/W2483382562","https://openalex.org/W2085988990","https://openalex.org/W1528519853","https://openalex.org/W1510134535","https://openalex.org/W2376710457","https://openalex.org/W1897774768","https://openalex.org/W3006903421"],"abstract_inverted_index":{"The":[0],"database":[1,184],"community":[2],"has":[3],"developed":[4],"numerous":[5],"tools":[6,38,57],"and":[7,12,23,46,63,83,95,226],"techniques":[8,19],"for":[9,20,70,133,151,187,197,223],"data":[10,21,71,126,224,236],"curation":[11,190,237],"exploration,":[13],"from":[14],"declarative":[15],"languages,":[16,62],"to":[17,33,39,54,117,123,164,195,205],"specialized":[18],"repair,":[22],"more.":[24],"Yet,":[25],"there":[26],"is":[27,185],"currently":[28],"no":[29],"consensus":[30],"on":[31,56,88,109],"how":[32],"best":[34],"expose":[35],"these":[36],"powerful":[37],"an":[40,161,169,240],"analyst":[41],"in":[42,180,214],"a":[43,89,124,134,143,156,181,218,232],"simple,":[44],"intuitive,":[45],"above":[47],"all,":[48],"flexible":[49],"way.":[50],"Thus,":[51],"analysts":[52],"continue":[53],"rely":[55],"such":[58,176,239],"as":[59,189],"spreadsheets,":[60,81],"imperative":[61,96,162],"notebook":[64,97,157,166,221],"style":[65],"programming":[66],"environments":[67,98],"like":[68],"Jupyter":[69],"curation.":[72],"In":[73,141],"this":[74],"work,":[75],"we":[76],"explore":[77,208],"the":[78,115,149,209],"integration":[79],"of":[80,105,137,211,230],"notebooks,":[82],"relational":[84,102,112,183,215],"databases.":[85],"We":[86,172,207],"focus":[87],"key":[90],"advantage":[91],"that":[92,129,167,174,192,234],"both":[93],"spreadsheets":[94],"have":[99],"over":[100],"classical":[101,182],"databases:":[103],"ease":[104],"exception.":[106],"By":[107],"relying":[108],"set-at-a-time":[110],"operations,":[111,121],"databases":[113],"sacrifice":[114],"ability":[116],"easily":[118,147],"define":[119],"singleton":[120],"exceptions":[122],"normal":[125],"processing":[127,132],"workflow":[128],"affect":[130],"query":[131],"fixed":[135],"set":[136],"explicitly":[138],"targeted":[139],"records.":[140],"comparison,":[142],"spreadsheet":[144],"user":[145,158],"can":[146,159,200],"change":[148],"formula":[150],"just":[152],"one":[153],"cell,":[154],"while":[155],"add":[160],"operation":[163],"her":[165],"alters":[168],"output":[170],"\"view\".":[171],"believe":[173],"enabling":[175,212],"idiosyncratic":[177],"manual":[178],"transformations":[179],"critical":[186],"curation,":[188,225],"operations":[191],"are":[193],"easy":[194],"declare":[196],"individual":[198],"values":[199],"often":[201],"be":[202],"extremely":[203],"challenging":[204],"generalize.":[206],"challenges":[210],"singletons":[213],"databases,":[216],"propose":[217],"hybrid":[219],"spreadsheet/relational":[220],"environment":[222],"present":[227],"our":[228],"vision":[229],"Vizier,":[231],"system":[233],"exposes":[235],"through":[238],"interface.":[241]},"counts_by_year":[{"year":2023,"cited_by_count":2},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1}],"updated_date":"2026-04-14T08:04:32.555800","created_date":"2025-10-10T00:00:00"}