{"id":"https://openalex.org/W2082087526","doi":"https://doi.org/10.1145/2304510.2304526","title":"Testing cardinality estimation models in SQL server","display_name":"Testing cardinality estimation models in SQL server","publication_year":2012,"publication_date":"2012-05-21","ids":{"openalex":"https://openalex.org/W2082087526","doi":"https://doi.org/10.1145/2304510.2304526","mag":"2082087526"},"language":"en","primary_location":{"id":"doi:10.1145/2304510.2304526","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2304510.2304526","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Fifth International Workshop on Testing Database Systems","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/A5023294162","display_name":"Campbell Fraser","orcid":"https://orcid.org/0009-0005-2035-4409"},"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":true,"raw_author_name":"Campbell Fraser","raw_affiliation_strings":["Microsoft Corporation, Redmond, WA"],"affiliations":[{"raw_affiliation_string":"Microsoft Corporation, Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5050292833","display_name":"Leo Giakoumakis","orcid":null},"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":"Leo Giakoumakis","raw_affiliation_strings":["Microsoft Corporation, Redmond, WA"],"affiliations":[{"raw_affiliation_string":"Microsoft Corporation, Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5040874009","display_name":"Vikas Hamine","orcid":null},"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":"Vikas Hamine","raw_affiliation_strings":["Microsoft Corporation, Redmond, WA"],"affiliations":[{"raw_affiliation_string":"Microsoft Corporation, Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5011366281","display_name":"Katherine F. Moore-Smith","orcid":null},"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":"Katherine F. Moore-Smith","raw_affiliation_strings":["Microsoft Corporation, Redmond, WA"],"affiliations":[{"raw_affiliation_string":"Microsoft Corporation, Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5023294162"],"corresponding_institution_ids":["https://openalex.org/I1290206253"],"apc_list":null,"apc_paid":null,"fwci":0.3751,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.66029862,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"7"},"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.9997000098228455,"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.9997000098228455,"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.9988999962806702,"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/T12016","display_name":"Web Data Mining and Analysis","score":0.9941999912261963,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/cardinality","display_name":"Cardinality (data modeling)","score":0.894289493560791},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8111164569854736},{"id":"https://openalex.org/keywords/code-refactoring","display_name":"Code refactoring","score":0.571909487247467},{"id":"https://openalex.org/keywords/sketch","display_name":"Sketch","score":0.5420398116111755},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4464930593967438},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.38146549463272095},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3795580267906189},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.33731138706207275},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.2425159513950348},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2415543794631958}],"concepts":[{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.894289493560791},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8111164569854736},{"id":"https://openalex.org/C152752567","wikidata":"https://www.wikidata.org/wiki/Q116877","display_name":"Code refactoring","level":3,"score":0.571909487247467},{"id":"https://openalex.org/C2779231336","wikidata":"https://www.wikidata.org/wiki/Q7534724","display_name":"Sketch","level":2,"score":0.5420398116111755},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4464930593967438},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.38146549463272095},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3795580267906189},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.33731138706207275},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.2425159513950348},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2415543794631958}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2304510.2304526","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2304510.2304526","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Fifth International Workshop on Testing Database Systems","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":11,"referenced_works":["https://openalex.org/W192214595","https://openalex.org/W1480809079","https://openalex.org/W1504218467","https://openalex.org/W1978144040","https://openalex.org/W1997472281","https://openalex.org/W2141575847","https://openalex.org/W2151310484","https://openalex.org/W2153329411","https://openalex.org/W2153406069","https://openalex.org/W2159359962","https://openalex.org/W4249653116"],"related_works":["https://openalex.org/W4313549863","https://openalex.org/W2072205733","https://openalex.org/W2395465245","https://openalex.org/W2101762871","https://openalex.org/W3176957927","https://openalex.org/W4296534969","https://openalex.org/W4312761314","https://openalex.org/W2476494490","https://openalex.org/W3194667890","https://openalex.org/W4231266416"],"abstract_inverted_index":{"Reliable":[0],"query":[1],"optimization":[2],"greatly":[3],"depends":[4],"on":[5,17],"accurate":[6],"Cardinality":[7],"Estimation":[8],"(CE),":[9],"which":[10],"is":[11,74],"inherently":[12],"inexact":[13],"as":[14],"it":[15,73],"relies":[16],"statistical":[18],"information.":[19],"In":[20,101],"commercial":[21],"database":[22],"systems,":[23],"cardinality":[24,43,116,146],"estimation":[25,44,117,147],"models":[26],"are":[27],"sophisticated":[28],"components":[29],"that":[30,41,51,143],"over":[31,70],"years":[32],"of":[33,56,113,136,157],"development":[34],"can":[35,61],"become":[36],"very":[37],"complex.":[38],"The":[39],"code":[40],"implements":[42],"models,":[45],"like":[46],"most":[47],"complex":[48],"software":[49],"systems":[50],"handle":[52],"a":[53,97,114,132],"large":[54],"space":[55],"possible":[57],"inputs":[58,87],"and":[59,67,79,88,90,111,130],"conditions,":[60,89],"deviate":[62],"from":[63],"its":[64,150],"original":[65],"architecture":[66],"design":[68],"points":[69],"time.":[71],"Hence,":[72],"often":[75],"necessary":[76],"to":[77,84,92,141],"refactor":[78],"redesign":[80],"the":[81,109,125,137,144,154],"entire":[82],"system":[83],"accommodate":[85],"new":[86,115,145],"also":[91],"reflect":[93],"existing":[94,161],"ones":[95],"in":[96,119],"more":[98],"intentional":[99],"way.":[100],"this":[102,128],"paper,":[103],"we":[104],"describe":[105,124],"such":[106],"an":[107],"exercise:":[108],"replacement":[110],"validation":[112],"model":[118,148],"Microsoft":[120],"SQL":[121],"Server.":[122],"We":[123],"motivation":[126],"behind":[127],"change,":[129],"provide":[131],"high":[133],"level":[134],"sketch":[135],"empirical":[138],"methods":[139],"used":[140],"ensure":[142],"satisfies":[149],"goals":[151],"while":[152],"minimizing":[153],"potential":[155],"risk":[156],"plan":[158],"regressions":[159],"for":[160],"customers.":[162]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":1}],"updated_date":"2026-03-06T13:50:29.536080","created_date":"2025-10-10T00:00:00"}