{"id":"https://openalex.org/W2030528599","doi":"https://doi.org/10.1145/1066157.1066293","title":"Automated statistics collection in action","display_name":"Automated statistics collection in action","publication_year":2005,"publication_date":"2005-06-14","ids":{"openalex":"https://openalex.org/W2030528599","doi":"https://doi.org/10.1145/1066157.1066293","mag":"2030528599"},"language":"en","primary_location":{"id":"doi:10.1145/1066157.1066293","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1066157.1066293","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2005 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"},"type":"conference-paper","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/A5090729930","display_name":"Peter J. Haas","orcid":"https://orcid.org/0000-0001-5694-3065"},"institutions":[{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"P. Haas","raw_affiliation_strings":["IBM Almaden Research Center, San Jose, CA","IBM Almaden Research Center San Jose , CA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center San Jose , CA","institution_ids":["https://openalex.org/I4210085935"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5040248448","display_name":"Mokhtar Kandil","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210113654","display_name":"IBM (Canada)","ror":"https://ror.org/025sxka56","country_code":"CA","type":"company","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210113654"]}],"countries":["CA","US"],"is_corresponding":false,"raw_author_name":"M. Kandil","raw_affiliation_strings":["IBM Toronto Development Laboratory, ON, Canada","IBM Toronto Development Laboratory, ON, Canada#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Toronto Development Laboratory, ON, Canada","institution_ids":["https://openalex.org/I4210113654"]},{"raw_affiliation_string":"IBM Toronto Development Laboratory, ON, Canada#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5039354204","display_name":"Anat Lerner","orcid":"https://orcid.org/0000-0002-9293-3195"},"institutions":[{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"A. Lerner","raw_affiliation_strings":["IBM Almaden Research Center, San Jose, CA","IBM Almaden Research Center San Jose , CA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center San Jose , CA","institution_ids":["https://openalex.org/I4210085935"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5002413906","display_name":"Volker Markl","orcid":"https://orcid.org/0009-0009-0964-026X"},"institutions":[{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"V. Markl","raw_affiliation_strings":["IBM Almaden Research Center, San Jose, CA","IBM Almaden Research Center San Jose , CA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center San Jose , CA","institution_ids":["https://openalex.org/I4210085935"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5059722683","display_name":"Ivan Popivanov","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210113654","display_name":"IBM (Canada)","ror":"https://ror.org/025sxka56","country_code":"CA","type":"company","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210113654"]}],"countries":["CA","US"],"is_corresponding":false,"raw_author_name":"I. Popivanov","raw_affiliation_strings":["IBM Toronto Development Laboratory, Markham, ON, Canada","IBM Toronto Development Laboratory, Markham, ON, Canada#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Toronto Development Laboratory, Markham, ON, Canada","institution_ids":["https://openalex.org/I4210113654"]},{"raw_affiliation_string":"IBM Toronto Development Laboratory, Markham, ON, Canada#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5036513384","display_name":"Venkat Raman","orcid":"https://orcid.org/0000-0002-2750-0246"},"institutions":[{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"V. Raman","raw_affiliation_strings":["IBM Almaden Research Center, San Jose, CA","IBM Almaden Research Center San Jose , CA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center San Jose , CA","institution_ids":["https://openalex.org/I4210085935"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5102959813","display_name":"Daniel C. Zilio","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210113654","display_name":"IBM (Canada)","ror":"https://ror.org/025sxka56","country_code":"CA","type":"company","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210113654"]}],"countries":["CA","US"],"is_corresponding":false,"raw_author_name":"D. Zilio","raw_affiliation_strings":["IBM Toronto Development Laboratory, Markham, ON, Canada","IBM Toronto Development Laboratory, Markham, ON, Canada#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Toronto Development Laboratory, Markham, ON, Canada","institution_ids":["https://openalex.org/I4210113654"]},{"raw_affiliation_string":"IBM Toronto Development Laboratory, Markham, ON, Canada#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.15442795,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"933","last_page":"935"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"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/T11106","display_name":"Data Management and Algorithms","score":0.9966999888420105,"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/T11269","display_name":"Algorithms and Data Compression","score":0.9955999851226807,"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/computer-science","display_name":"Computer science","score":0.7033138871192932},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.5796915888786316},{"id":"https://openalex.org/keywords/ibm","display_name":"IBM","score":0.5655361413955688},{"id":"https://openalex.org/keywords/statistic","display_name":"Statistic","score":0.5590455532073975},{"id":"https://openalex.org/keywords/guard","display_name":"Guard (computer science)","score":0.5428547859191895},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.5400699973106384},{"id":"https://openalex.org/keywords/summary-statistics","display_name":"Summary statistics","score":0.5292983055114746},{"id":"https://openalex.org/keywords/parameterized-complexity","display_name":"Parameterized complexity","score":0.5069873332977295},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.47368124127388},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.47330012917518616},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.47033625841140747},{"id":"https://openalex.org/keywords/sufficient-statistic","display_name":"Sufficient statistic","score":0.4612495005130768},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.4612419009208679},{"id":"https://openalex.org/keywords/plan","display_name":"Plan (archaeology)","score":0.43753692507743835},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.20459583401679993},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.16920793056488037}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7033138871192932},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.5796915888786316},{"id":"https://openalex.org/C70388272","wikidata":"https://www.wikidata.org/wiki/Q5968558","display_name":"IBM","level":2,"score":0.5655361413955688},{"id":"https://openalex.org/C89128539","wikidata":"https://www.wikidata.org/wiki/Q1949963","display_name":"Statistic","level":2,"score":0.5590455532073975},{"id":"https://openalex.org/C141141315","wikidata":"https://www.wikidata.org/wiki/Q2379942","display_name":"Guard (computer science)","level":2,"score":0.5428547859191895},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.5400699973106384},{"id":"https://openalex.org/C32792767","wikidata":"https://www.wikidata.org/wiki/Q1370484","display_name":"Summary statistics","level":2,"score":0.5292983055114746},{"id":"https://openalex.org/C165464430","wikidata":"https://www.wikidata.org/wiki/Q1570441","display_name":"Parameterized complexity","level":2,"score":0.5069873332977295},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.47368124127388},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.47330012917518616},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.47033625841140747},{"id":"https://openalex.org/C178197554","wikidata":"https://www.wikidata.org/wiki/Q1099110","display_name":"Sufficient statistic","level":2,"score":0.4612495005130768},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.4612419009208679},{"id":"https://openalex.org/C2776505523","wikidata":"https://www.wikidata.org/wiki/Q4785468","display_name":"Plan (archaeology)","level":2,"score":0.43753692507743835},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.20459583401679993},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.16920793056488037},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C171250308","wikidata":"https://www.wikidata.org/wiki/Q11468","display_name":"Nanotechnology","level":1,"score":0.0},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","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/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C126042441","wikidata":"https://www.wikidata.org/wiki/Q1324888","display_name":"Frame (networking)","level":2,"score":0.0},{"id":"https://openalex.org/C95457728","wikidata":"https://www.wikidata.org/wiki/Q309","display_name":"History","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1066157.1066293","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1066157.1066293","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2005 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","id":"https://metadata.un.org/sdg/16","score":0.5}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":2,"referenced_works":["https://openalex.org/W2102166438","https://openalex.org/W2160149182"],"related_works":["https://openalex.org/W4300943255","https://openalex.org/W2021631302","https://openalex.org/W2903948779","https://openalex.org/W3121630503","https://openalex.org/W2123478819","https://openalex.org/W2386091484","https://openalex.org/W2050515813","https://openalex.org/W3168146613","https://openalex.org/W4287117365","https://openalex.org/W1971018524"],"abstract_inverted_index":{"If":[0],"presented":[1],"with":[2],"inaccurate":[3],"statistics,":[4],"even":[5],"the":[6,17,57,80,94,107,110,126,174,197,206],"most":[7],"sophisticated":[8],"query":[9],"optimizers":[10],"make":[11,26],"mistakes.":[12],"They":[13],"may":[14,43],"wrongly":[15],"estimate":[16],"output":[18],"cardinality":[19,178],"of":[20,49,82,112,132,185],"a":[21,45,65,136,145],"certain":[22,141],"operation":[23],"and":[24,51,78,152],"thus":[25],"sub-optimal":[27],"plan":[28,203],"choices":[29,204],"based":[30],"on":[31,144],"that":[32,91],"cardinality.":[33],"Maintaining":[34],"accurate":[35,115],"statistics":[36,50,53,84,116,127,156],"is":[37,64,122,191],"hard,":[38],"both":[39],"because":[40,52],"each":[41],"table":[42],"need":[44],"specifically":[46],"parameterized":[47],"set":[48],"get":[54],"outdated":[55,155],"as":[56],"database":[58],"changes.":[59],"Automated":[60],"Statistic":[61],"Collection":[62],"(ASC)":[63],"new":[66],"component":[67],"in":[68,86,117,162,182,196],"IBM":[69],"DB2":[70],"UDB":[71],"that,":[72],"without":[73],"any":[74],"DBA":[75,108],"intervention,":[76],"observes":[77],"analyzes":[79],"effects":[81],"faulty":[83],"and,":[85],"response,":[87],"it":[88],"triggers":[89],"actions":[90],"continuously":[92],"repair":[93],"latter.":[95],"In":[96],"this":[97,189,201],"demonstration,":[98],"we":[99],"will":[100,167],"show":[101,169],"how":[102,170,177,188,200],"ASC":[103,121,148,171],"works":[104,172],"to":[105,124,187,193,199],"alleviate":[106],"from":[109,173,176],"task":[111],"maintaining":[113],"fresh,":[114],"several":[118],"challenging":[119],"scenarios.":[120],"able":[123],"reconfigure":[125],"collection":[128],"parameters":[129],"(e.g,":[130],"number":[131],"frequent":[133],"values":[134],"for":[135],"column,":[137],"or":[138],"correlations":[139],"between":[140],"column":[142],"pairs)":[143],"per-table":[146],"basis.":[147],"can":[149],"also":[150,168],"detect":[151],"guard":[153],"against":[154],"caused":[157],"by":[158],"high":[159],"updates/inserts/deletes":[160],"rates":[161],"volatile,":[163],"dynamic":[164],"databases.":[165],"We":[166],"inside:":[175],"mis-estimations":[179],"are":[180],"introduced":[181],"different":[183],"kind":[184],"operators,":[186],"error":[190],"propagated":[192],"later":[194],"operations":[195],"plan,":[198],"influences":[202],"inside":[205],"optimizer.":[207]},"counts_by_year":[{"year":2019,"cited_by_count":1},{"year":2014,"cited_by_count":2}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}