{"id":"https://openalex.org/W2242120942","doi":"https://doi.org/10.1145/3092931.3092936","title":"A Closer Look at Variance Implementations In Modern Database Systems","display_name":"A Closer Look at Variance Implementations In Modern Database Systems","publication_year":2017,"publication_date":"2017-05-11","ids":{"openalex":"https://openalex.org/W2242120942","doi":"https://doi.org/10.1145/3092931.3092936","mag":"2242120942"},"language":"en","primary_location":{"id":"doi:10.1145/3092931.3092936","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3092931.3092936","pdf_url":null,"source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"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":"ACM SIGMOD Record","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/A5026699566","display_name":"Niranjan Kamat","orcid":null},"institutions":[{"id":"https://openalex.org/I52357470","display_name":"The Ohio State University","ror":"https://ror.org/00rs6vg23","country_code":"US","type":"education","lineage":["https://openalex.org/I52357470"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Niranjan Kamat","raw_affiliation_strings":["The Ohio State University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"The Ohio State University","institution_ids":["https://openalex.org/I52357470"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5001906560","display_name":"Arnab Nandi","orcid":"https://orcid.org/0000-0002-4138-603X"},"institutions":[{"id":"https://openalex.org/I52357470","display_name":"The Ohio State University","ror":"https://ror.org/00rs6vg23","country_code":"US","type":"education","lineage":["https://openalex.org/I52357470"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Arnab Nandi","raw_affiliation_strings":["The Ohio State University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"The Ohio State University","institution_ids":["https://openalex.org/I52357470"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I52357470"],"apc_list":null,"apc_paid":null,"fwci":0.7307,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.6857385,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":"45","issue":"4","first_page":"28","last_page":"33"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9997000098228455,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9997000098228455,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"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/T11303","display_name":"Bayesian Modeling and Causal Inference","score":0.9973000288009644,"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/variance","display_name":"Variance (accounting)","score":0.8517143726348877},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7979567050933838},{"id":"https://openalex.org/keywords/implementation","display_name":"Implementation","score":0.699059009552002},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.6093820333480835},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5644713044166565},{"id":"https://openalex.org/keywords/representation","display_name":"Representation (politics)","score":0.5215261578559875},{"id":"https://openalex.org/keywords/component","display_name":"Component (thermodynamics)","score":0.4976990520954132},{"id":"https://openalex.org/keywords/scale","display_name":"Scale (ratio)","score":0.46298232674598694},{"id":"https://openalex.org/keywords/point","display_name":"Point (geometry)","score":0.41747602820396423},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.3954964280128479},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.376930832862854},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.13745003938674927}],"concepts":[{"id":"https://openalex.org/C196083921","wikidata":"https://www.wikidata.org/wiki/Q7915758","display_name":"Variance (accounting)","level":2,"score":0.8517143726348877},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7979567050933838},{"id":"https://openalex.org/C26713055","wikidata":"https://www.wikidata.org/wiki/Q245962","display_name":"Implementation","level":2,"score":0.699059009552002},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.6093820333480835},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5644713044166565},{"id":"https://openalex.org/C2776359362","wikidata":"https://www.wikidata.org/wiki/Q2145286","display_name":"Representation (politics)","level":3,"score":0.5215261578559875},{"id":"https://openalex.org/C168167062","wikidata":"https://www.wikidata.org/wiki/Q1117970","display_name":"Component (thermodynamics)","level":2,"score":0.4976990520954132},{"id":"https://openalex.org/C2778755073","wikidata":"https://www.wikidata.org/wiki/Q10858537","display_name":"Scale (ratio)","level":2,"score":0.46298232674598694},{"id":"https://openalex.org/C28719098","wikidata":"https://www.wikidata.org/wiki/Q44946","display_name":"Point (geometry)","level":2,"score":0.41747602820396423},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3954964280128479},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.376930832862854},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.13745003938674927},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.0},{"id":"https://openalex.org/C94625758","wikidata":"https://www.wikidata.org/wiki/Q7163","display_name":"Politics","level":2,"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/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C97355855","wikidata":"https://www.wikidata.org/wiki/Q11473","display_name":"Thermodynamics","level":1,"score":0.0},{"id":"https://openalex.org/C121955636","wikidata":"https://www.wikidata.org/wiki/Q4116214","display_name":"Accounting","level":1,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3092931.3092936","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3092931.3092936","pdf_url":null,"source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"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":"ACM SIGMOD Record","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":14,"referenced_works":["https://openalex.org/W1969761972","https://openalex.org/W1981663184","https://openalex.org/W1986624837","https://openalex.org/W1987034518","https://openalex.org/W2020804487","https://openalex.org/W2026685536","https://openalex.org/W2028535383","https://openalex.org/W2044849727","https://openalex.org/W2062506051","https://openalex.org/W2088214068","https://openalex.org/W2113411758","https://openalex.org/W2153884194","https://openalex.org/W2617139084","https://openalex.org/W3022909171"],"related_works":["https://openalex.org/W1575263621","https://openalex.org/W1964111820","https://openalex.org/W1485630101","https://openalex.org/W2138904458","https://openalex.org/W1536235319","https://openalex.org/W2083338789","https://openalex.org/W2384497200","https://openalex.org/W4244853187","https://openalex.org/W2379533788","https://openalex.org/W1828744063"],"abstract_inverted_index":{"Variance":[0],"is":[1,12,32,119],"a":[2,16,68,110,116],"popular":[3],"and":[4,44,96,105,147,150,165,192],"often":[5],"necessary":[6],"component":[7],"of":[8,23,56],"aggregation":[9],"queries.":[10],"It":[11],"typically":[13],"used":[14],"as":[15,27,41,103,161],"secondary":[17],"measure":[18],"to":[19,35,50,67,188],"ascertain":[20],"statistical":[21],"properties":[22],"the":[24,54,136,145,173,183],"result":[25],"such":[26,40,102,160],"its":[28,189],"error.":[29],"Yet,":[30],"it":[31],"more":[33],"expensive":[34],"compute":[36,51],"than":[37],"primary":[38],"measures":[39],"SUM,":[42],"MEAN,":[43],"COUNT.":[45],"There":[46],"exist":[47],"numerous":[48],"techniques":[49],"variance.":[52],"While":[53],"definition":[55],"variance":[57,90,141,155,178],"implies":[58],"two":[59,180],"passes":[60,181],"overthe":[61],"data,":[62],"other":[63],"mathematical":[64,174],"formulations":[65],"lead":[66],"singlepass":[69],"computation.":[70],"Some":[71],"single-pass":[72],"formulations,":[73],"however,":[74],"can":[75],"suffer":[76],"from":[77,123,129],"severe":[78],"precision":[79,126],"loss,":[80],"especially":[81],"for":[82,176],"large":[83],"datasets.":[84],"In":[85],"this":[86],"paper,":[87],"we":[88,170],"study":[89],"implementations":[91],"in":[92,143,157],"various":[93,158],"real-world":[94],"systems":[95,101],"find":[97],"that":[98,118],"major":[99,111],"database":[100,148],"PostgreSQL":[104],"most":[106],"likely":[107],"System":[108],"X,":[109],"commercial":[112],"closed-source":[113],"database,":[114],"use":[115],"representation":[117],"efficient,":[120],"but":[121],"suffers":[122],"floating":[124],"point":[125],"loss":[127],"resulting":[128],"catastrophic":[130],"cancellation.":[131],"We":[132],"review":[133],"literature":[134],"over":[135,182],"past":[137],"five":[138],"decades":[139],"on":[140,153],"calculation":[142],"both":[144],"statistics":[146],"communities,":[149],"summarize":[151],"recommendations":[152],"implementing":[154],"functions":[156],"settings,":[159],"approximate":[162],"query":[163],"processing":[164],"large-scale":[166],"distributed":[167],"aggregation.":[168],"Interestingly,":[169],"recommend":[171],"using":[172],"formula":[175],"computing":[177],"if":[179],"data":[184],"are":[185],"acceptable":[186],"due":[187],"precision,":[190],"parallelizability,":[191],"surprisingly":[193],"computation":[194],"speed.":[195]},"counts_by_year":[{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}