{"id":"https://openalex.org/W2798682670","doi":"https://doi.org/10.1145/3183713.3196914","title":"Bias in OLAP Queries","display_name":"Bias in OLAP Queries","publication_year":2018,"publication_date":"2018-05-25","ids":{"openalex":"https://openalex.org/W2798682670","doi":"https://doi.org/10.1145/3183713.3196914","mag":"2798682670"},"language":"en","primary_location":{"id":"doi:10.1145/3183713.3196914","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3183713.3196914","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3183713.3196914","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2018 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/3183713.3196914","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5103209063","display_name":"Babak Salimi","orcid":"https://orcid.org/0000-0003-2485-9533"},"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":true,"raw_author_name":"Babak Salimi","raw_affiliation_strings":["University of Washington, Seattle, WA, USA"],"affiliations":[{"raw_affiliation_string":"University of Washington, Seattle, WA, USA","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5023537206","display_name":"Johannes Gehrke","orcid":"https://orcid.org/0009-0006-6293-5209"},"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":"Johannes Gehrke","raw_affiliation_strings":["Microsoft, Seattle, WA, USA"],"affiliations":[{"raw_affiliation_string":"Microsoft, Seattle, WA, USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"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"],"affiliations":[{"raw_affiliation_string":"University of Washington, Seattle, WA, USA","institution_ids":["https://openalex.org/I201448701"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5103209063"],"corresponding_institution_ids":["https://openalex.org/I201448701"],"apc_list":null,"apc_paid":null,"fwci":3.0412,"has_fulltext":true,"cited_by_count":42,"citation_normalized_percentile":{"value":0.93104071,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"1021","last_page":"1035"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12761","display_name":"Data Stream Mining Techniques","score":0.9975000023841858,"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"}},"topics":[{"id":"https://openalex.org/T12761","display_name":"Data Stream Mining Techniques","score":0.9975000023841858,"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.9919000267982483,"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/T11652","display_name":"Imbalanced Data Classification Techniques","score":0.9907000064849854,"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/online-analytical-processing","display_name":"Online analytical processing","score":0.9756829142570496},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8486284017562866},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5484659075737},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5200885534286499},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.4980354309082031},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4887392520904541},{"id":"https://openalex.org/keywords/independence","display_name":"Independence (probability theory)","score":0.4553838074207306},{"id":"https://openalex.org/keywords/decision-support-system","display_name":"Decision support system","score":0.4192701280117035},{"id":"https://openalex.org/keywords/simple","display_name":"Simple (philosophy)","score":0.41626471281051636},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.3663216233253479},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.33455103635787964}],"concepts":[{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.9756829142570496},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8486284017562866},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5484659075737},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5200885534286499},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4980354309082031},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4887392520904541},{"id":"https://openalex.org/C35651441","wikidata":"https://www.wikidata.org/wiki/Q625303","display_name":"Independence (probability theory)","level":2,"score":0.4553838074207306},{"id":"https://openalex.org/C107327155","wikidata":"https://www.wikidata.org/wiki/Q330268","display_name":"Decision support system","level":2,"score":0.4192701280117035},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.41626471281051636},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.3663216233253479},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.33455103635787964},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3183713.3196914","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3183713.3196914","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3183713.3196914","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2018 International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3183713.3196914","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3183713.3196914","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3183713.3196914","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2018 International Conference on Management of Data","raw_type":"proceedings-article"},"sustainable_development_goals":[{"score":0.49000000953674316,"id":"https://metadata.un.org/sdg/16","display_name":"Peace, Justice and strong institutions"},{"score":0.4699999988079071,"id":"https://metadata.un.org/sdg/10","display_name":"Reduced inequalities"}],"awards":[{"id":"https://openalex.org/G620229259","display_name":null,"funder_award_id":"1614738","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G6872048155","display_name":null,"funder_award_id":"1703281","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G848032724","display_name":null,"funder_award_id":"Science","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"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2798682670.pdf","grobid_xml":"https://content.openalex.org/works/W2798682670.grobid-xml"},"referenced_works_count":55,"referenced_works":["https://openalex.org/W152848236","https://openalex.org/W1501375624","https://openalex.org/W1524326598","https://openalex.org/W1526097585","https://openalex.org/W1534906344","https://openalex.org/W1565683517","https://openalex.org/W1568769775","https://openalex.org/W1569279788","https://openalex.org/W1615454278","https://openalex.org/W1617895125","https://openalex.org/W1963921006","https://openalex.org/W1968634175","https://openalex.org/W1978108654","https://openalex.org/W1988368118","https://openalex.org/W2008312103","https://openalex.org/W2011087402","https://openalex.org/W2018300356","https://openalex.org/W2026019770","https://openalex.org/W2048087720","https://openalex.org/W2059141064","https://openalex.org/W2096900271","https://openalex.org/W2097421443","https://openalex.org/W2105494575","https://openalex.org/W2129564794","https://openalex.org/W2143117649","https://openalex.org/W2145429839","https://openalex.org/W2159080219","https://openalex.org/W2161642932","https://openalex.org/W2162670686","https://openalex.org/W2165547877","https://openalex.org/W2181616869","https://openalex.org/W2184369383","https://openalex.org/W2484145743","https://openalex.org/W2492794003","https://openalex.org/W2511010068","https://openalex.org/W2529658886","https://openalex.org/W2585857961","https://openalex.org/W2613752415","https://openalex.org/W2801358783","https://openalex.org/W2940461062","https://openalex.org/W2964116855","https://openalex.org/W3120740533","https://openalex.org/W3121520943","https://openalex.org/W4211064163","https://openalex.org/W4239725157","https://openalex.org/W4248700314","https://openalex.org/W4299828299","https://openalex.org/W4301884499","https://openalex.org/W4302423442","https://openalex.org/W6606169510","https://openalex.org/W6631500773","https://openalex.org/W6632100894","https://openalex.org/W6684072790","https://openalex.org/W6686224169","https://openalex.org/W6722721424"],"related_works":["https://openalex.org/W2378213774","https://openalex.org/W2357522326","https://openalex.org/W6138692","https://openalex.org/W2363019959","https://openalex.org/W1535822977","https://openalex.org/W23190051","https://openalex.org/W2367419170","https://openalex.org/W2377387014","https://openalex.org/W2353410296","https://openalex.org/W2084266952"],"abstract_inverted_index":{"On":[0],"line":[1],"analytical":[2],"processing":[3],"(OLAP)":[4],"is":[5],"an":[6,90,100,109],"essential":[7],"element":[8],"of":[9,61,69,136,144],"decision-support":[10,54],"systems.":[11],"OLAP":[12,27],"tools":[13],"provide":[14],"insights":[15,147],"and":[16,32,36,49,133],"understanding":[17,93],"needed":[18],"for":[19,86,103],"improved":[20],"decision":[21],"making.":[22],"However,":[23],"the":[24,73,115,131,134,140,145],"answers":[25],"to":[26,34,46,50,75,118],"queries":[28],"can":[29],"be":[30],"biased":[31,63,106],"lead":[33],"perplexing":[35],"incorrect":[37],"insights.":[38],"In":[39,120],"this":[40],"paper,":[41],"we":[42,98,128],"propose,":[43],"a":[44,58,62,67,80,105,121,149],"system":[45],"detect,":[47],"explain,":[48],"resolve":[51],"bias":[52],"in":[53,92],"queries.":[55],"We":[56,78],"give":[57],"simple":[59],"definition":[60],"query,":[64,111],"which":[65,112],"performs":[66],"set":[68],"independence":[70],"tests":[71],"on":[72,124],"data":[74],"detect":[76],"bias.":[77],"propose":[79],"novel":[81],"technique":[82],"that":[83],"gives":[84],"explanations":[85],"bias,":[87],"thus":[88],"assisting":[89],"analyst":[91,116],"what":[94,114],"goes":[95],"on.":[96],"Additionally,":[97],"develop":[99],"automated":[101],"method":[102],"rewriting":[104],"query":[107],"into":[108],"unbiased":[110],"shows":[113],"intended":[117],"examine.":[119],"thorough":[122],"evaluation":[123],"several":[125],"real":[126],"datasets":[127],"show":[129],"both":[130],"quality":[132],"performance":[135],"our":[137],"techniques,":[138],"including":[139],"completely":[141],"automatic":[142],"discovery":[143],"revolutionary":[146],"from":[148],"famous":[150],"1973":[151],"discrimination":[152],"case.":[153]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":5},{"year":2023,"cited_by_count":6},{"year":2022,"cited_by_count":8},{"year":2021,"cited_by_count":5},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":8},{"year":2018,"cited_by_count":1}],"updated_date":"2026-03-18T14:38:29.013473","created_date":"2025-10-10T00:00:00"}