{"id":"https://openalex.org/W2079499902","doi":"https://doi.org/10.1145/1376616.1376721","title":"Efficient and scalable statistics gathering for large databases in Oracle 11g","display_name":"Efficient and scalable statistics gathering for large databases in Oracle 11g","publication_year":2008,"publication_date":"2008-06-09","ids":{"openalex":"https://openalex.org/W2079499902","doi":"https://doi.org/10.1145/1376616.1376721","mag":"2079499902"},"language":"en","primary_location":{"id":"doi:10.1145/1376616.1376721","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1376616.1376721","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2008 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-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/A5025582581","display_name":"Sunil Chakkappen","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Sunil Chakkappen","raw_affiliation_strings":["Oracle, Redwood Shores, CA, USA","Oracle, Redwood shores, CA, USA"],"affiliations":[{"raw_affiliation_string":"Oracle, Redwood Shores, CA, USA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle, Redwood shores, CA, USA","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5084497894","display_name":"Thierry Cruanes","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Thierry Cruanes","raw_affiliation_strings":["Oracle, Redwood Shores, CA, USA","Oracle, Redwood shores, CA, USA"],"affiliations":[{"raw_affiliation_string":"Oracle, Redwood Shores, CA, USA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle, Redwood shores, CA, USA","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5004037878","display_name":"Beno\u00eet Dageville","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Benoit Dageville","raw_affiliation_strings":["Oracle, Redwood Shores, CA, USA","Oracle, Redwood shores, CA, USA"],"affiliations":[{"raw_affiliation_string":"Oracle, Redwood Shores, CA, USA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle, Redwood shores, CA, USA","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5044802020","display_name":"Linan Jiang","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Linan Jiang","raw_affiliation_strings":["Oracle, Redwood Shores, CA, USA","Oracle, Redwood shores, CA, USA"],"affiliations":[{"raw_affiliation_string":"Oracle, Redwood Shores, CA, USA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle, Redwood shores, CA, USA","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5058457583","display_name":"Uri Shaft","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Uri Shaft","raw_affiliation_strings":["Oracle, Redwood Shores, CA, USA","Oracle, Redwood shores, CA, USA"],"affiliations":[{"raw_affiliation_string":"Oracle, Redwood Shores, CA, USA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle, Redwood shores, CA, USA","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5110155069","display_name":"Hong Su","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Hong Su","raw_affiliation_strings":["Oracle, Redwood Shores, CA, USA","Oracle, Redwood shores, CA, USA"],"affiliations":[{"raw_affiliation_string":"Oracle, Redwood Shores, CA, USA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle, Redwood shores, CA, USA","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5003966028","display_name":"Mohamed Za\u00eft","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mohamed Zait","raw_affiliation_strings":["Oracle, Redwood Shores, CA, USA","Oracle, Redwood shores, CA, USA"],"affiliations":[{"raw_affiliation_string":"Oracle, Redwood Shores, CA, USA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle, Redwood shores, CA, USA","institution_ids":["https://openalex.org/I1342911587"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5025582581"],"corresponding_institution_ids":["https://openalex.org/I1342911587"],"apc_list":null,"apc_paid":null,"fwci":2.5663,"has_fulltext":false,"cited_by_count":23,"citation_normalized_percentile":{"value":0.90307771,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"1053","last_page":"1064"},"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.9998999834060669,"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.9998999834060669,"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.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/T11719","display_name":"Data Quality and Management","score":0.9925000071525574,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7547928690910339},{"id":"https://openalex.org/keywords/oracle","display_name":"Oracle","score":0.7118285894393921},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.6805989742279053},{"id":"https://openalex.org/keywords/partition","display_name":"Partition (number theory)","score":0.6217288970947266},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5288264155387878},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5049567818641663},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.44377604126930237},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.4177822172641754},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3241000175476074},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.15850186347961426},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.09955957531929016}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7547928690910339},{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.7118285894393921},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.6805989742279053},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.6217288970947266},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5288264155387878},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5049567818641663},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.44377604126930237},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.4177822172641754},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3241000175476074},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.15850186347961426},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.09955957531929016},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1376616.1376721","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1376616.1376721","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2008 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":24,"referenced_works":["https://openalex.org/W135508010","https://openalex.org/W1517332488","https://openalex.org/W1601435884","https://openalex.org/W1660390307","https://openalex.org/W1964691382","https://openalex.org/W1965996575","https://openalex.org/W1992363839","https://openalex.org/W2008365755","https://openalex.org/W2025051251","https://openalex.org/W2058991275","https://openalex.org/W2064379477","https://openalex.org/W2071009745","https://openalex.org/W2119050385","https://openalex.org/W2134786002","https://openalex.org/W2141540383","https://openalex.org/W2153329411","https://openalex.org/W2160149182","https://openalex.org/W2165906949","https://openalex.org/W2197881366","https://openalex.org/W4246899237","https://openalex.org/W4254036315","https://openalex.org/W6605589084","https://openalex.org/W6630947089","https://openalex.org/W6637101025"],"related_works":["https://openalex.org/W2073713056","https://openalex.org/W3110702597","https://openalex.org/W2125620709","https://openalex.org/W2110441383","https://openalex.org/W2045932760","https://openalex.org/W4233149903","https://openalex.org/W2326878701","https://openalex.org/W4293864700","https://openalex.org/W23253958","https://openalex.org/W2327539013"],"abstract_inverted_index":{"Large":[0],"tables":[1],"are":[2],"often":[3],"decomposed":[4],"into":[5],"smaller":[6],"pieces":[7],"called":[8],"partitions":[9,38,89,100,156],"in":[10,87,183,231],"order":[11],"to":[12,39,96,101,111,117],"improve":[13],"query":[14],"performance":[15,225],"and":[16,32,66,157,207,221],"ease":[17],"the":[18,26,29,33,36,54,62,67,72,85,98,103,113,119,136,141,151,154,160,166,170,176,190,196,214,227],"data":[19,86,146,206],"management.":[20],"Query":[21],"optimizers":[22],"rely":[23],"on":[24,203],"both":[25,204],"statistics":[27,34,65,139,152,163],"of":[28,35,78,172],"entire":[30,55,114],"table":[31,56,63,115,120,137,161],"individual":[37],"select":[40],"a":[41,46,126],"good":[42],"execution":[43],"plan":[44],"for":[45,60,70,153,185],"SQL":[47],"statement.":[48],"In":[49],"Oracle":[50,123,148,188,232],"10g,":[51],"we":[52,94,109],"scan":[53,97,112],"twice,":[57],"one":[58],"pass":[59,69],"gathering":[61,71,80],"level":[64,74,105,121,138,143,162],"other":[68],"partition":[73,104,142],"statistics.":[75,122,144],"A":[76],"consequence":[77],"this":[79,215],"method":[81,131,217,229],"is":[82,189,218],"that,":[83],"when":[84],"some":[88,186],"change,":[90,147],"not":[91],"only":[92,149],"do":[93],"need":[95],"changed":[99,155],"gather":[102,118],"statistics,":[106],"but":[107],"also":[108],"have":[110,199],"again":[116],"11g":[124],"adopts":[125],"one-pass":[127,177],"distinct":[128,178],"sampling":[129,179],"based":[130],"which":[132],"can":[133],"accurately":[134],"derive":[135],"from":[140],"When":[145],"re-gathers":[150],"then":[158],"derives":[159],"without":[164],"touching":[165],"unchanged":[167],"partitions.":[168],"To":[169],"best":[171],"our":[173],"knowledge,":[174],"although":[175],"has":[180,222],"been":[181],"researched":[182],"academia":[184],"years,":[187],"first":[191],"commercial":[192],"database":[193],"that":[194],"implements":[195],"technique.":[197],"We":[198],"performed":[200],"extensive":[201],"experiments":[202,212],"benchmark":[205],"real":[208],"customer":[209],"data.":[210],"Our":[211],"illustrate":[213],"new":[216],"highly":[219],"accurate":[220],"significantly":[223],"better":[224],"than":[226],"old":[228],"used":[230],"10g.":[233]},"counts_by_year":[{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":5},{"year":2017,"cited_by_count":3},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}