{"id":"https://openalex.org/W2153160273","doi":"https://doi.org/10.1145/1247480.1247502","title":"Cardinality estimation using sample views with quality assurance","display_name":"Cardinality estimation using sample views with quality assurance","publication_year":2007,"publication_date":"2007-06-11","ids":{"openalex":"https://openalex.org/W2153160273","doi":"https://doi.org/10.1145/1247480.1247502","mag":"2153160273"},"language":"en","primary_location":{"id":"doi:10.1145/1247480.1247502","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1247480.1247502","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2007 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://tud.qucosa.de/id/qucosa%3A80621","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5109039470","display_name":"Per-\u00c5ke Larson","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":true,"raw_author_name":"Per-Ake Larson","raw_affiliation_strings":["Microsoft Research, Redmond, WA","Dresden Univ. of"],"affiliations":[{"raw_affiliation_string":"Microsoft Research, Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]},{"raw_affiliation_string":"Dresden Univ. of","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063512642","display_name":"Wolfgang Lehner","orcid":"https://orcid.org/0000-0001-8107-2775"},"institutions":[{"id":"https://openalex.org/I4210164937","display_name":"Microsoft Research (United Kingdom)","ror":"https://ror.org/05k87vq12","country_code":"GB","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210164937"]},{"id":"https://openalex.org/I78650965","display_name":"TU Dresden","ror":"https://ror.org/042aqky30","country_code":"DE","type":"education","lineage":["https://openalex.org/I78650965"]}],"countries":["DE","GB"],"is_corresponding":false,"raw_author_name":"Wolfgang Lehner","raw_affiliation_strings":["Dresden Technical University, Dresden, Germany","Microsoft Research"],"affiliations":[{"raw_affiliation_string":"Dresden Technical University, Dresden, Germany","institution_ids":["https://openalex.org/I78650965"]},{"raw_affiliation_string":"Microsoft Research","institution_ids":["https://openalex.org/I4210164937"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057864403","display_name":"Jingren Zhou","orcid":"https://orcid.org/0000-0002-4220-2634"},"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":"Jingren Zhou","raw_affiliation_strings":["Microsoft Research, Redmond, WA","Dresden Univ. of"],"affiliations":[{"raw_affiliation_string":"Microsoft Research, Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]},{"raw_affiliation_string":"Dresden Univ. of","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5082617310","display_name":"Peter Zabback","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":"Peter Zabback","raw_affiliation_strings":["Microsoft, Redmond, WA","Dresden Univ. of"],"affiliations":[{"raw_affiliation_string":"Microsoft, Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]},{"raw_affiliation_string":"Dresden Univ. of","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5109039470"],"corresponding_institution_ids":["https://openalex.org/I1290206253"],"apc_list":null,"apc_paid":null,"fwci":3.8862,"has_fulltext":false,"cited_by_count":53,"citation_normalized_percentile":{"value":0.94496496,"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":"175","last_page":"186"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998000264167786,"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.9998000264167786,"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.9988999962806702,"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.9973999857902527,"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/quality-assurance","display_name":"Quality assurance","score":0.7432733774185181},{"id":"https://openalex.org/keywords/sample","display_name":"Sample (material)","score":0.6996371150016785},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6197508573532104},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.6149873733520508},{"id":"https://openalex.org/keywords/estimation","display_name":"Estimation","score":0.577584445476532},{"id":"https://openalex.org/keywords/quality","display_name":"Quality (philosophy)","score":0.5057566165924072},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.2392544150352478},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.10023114085197449},{"id":"https://openalex.org/keywords/operations-management","display_name":"Operations management","score":0.07770934700965881}],"concepts":[{"id":"https://openalex.org/C106436119","wikidata":"https://www.wikidata.org/wiki/Q836575","display_name":"Quality assurance","level":3,"score":0.7432733774185181},{"id":"https://openalex.org/C198531522","wikidata":"https://www.wikidata.org/wiki/Q485146","display_name":"Sample (material)","level":2,"score":0.6996371150016785},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6197508573532104},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.6149873733520508},{"id":"https://openalex.org/C96250715","wikidata":"https://www.wikidata.org/wiki/Q965330","display_name":"Estimation","level":2,"score":0.577584445476532},{"id":"https://openalex.org/C2779530757","wikidata":"https://www.wikidata.org/wiki/Q1207505","display_name":"Quality (philosophy)","level":2,"score":0.5057566165924072},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2392544150352478},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.10023114085197449},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.07770934700965881},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C201995342","wikidata":"https://www.wikidata.org/wiki/Q682496","display_name":"Systems engineering","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C43617362","wikidata":"https://www.wikidata.org/wiki/Q170050","display_name":"Chromatography","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/C2778618615","wikidata":"https://www.wikidata.org/wiki/Q4008393","display_name":"External quality assessment","level":2,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1247480.1247502","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1247480.1247502","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2007 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"},{"id":"pmh:oai:qucosa:de:qucosa:80621","is_oa":true,"landing_page_url":"https://tud.qucosa.de/id/qucosa%3A80621","pdf_url":null,"source":{"id":"https://openalex.org/S4377196312","display_name":"Qucosa (Saxon State and University Library Dresden)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I3132420320","host_organization_name":"SLUB Dresden","host_organization_lineage":["https://openalex.org/I3132420320"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"doc-type:Text"}],"best_oa_location":{"id":"pmh:oai:qucosa:de:qucosa:80621","is_oa":true,"landing_page_url":"https://tud.qucosa.de/id/qucosa%3A80621","pdf_url":null,"source":{"id":"https://openalex.org/S4377196312","display_name":"Qucosa (Saxon State and University Library Dresden)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I3132420320","host_organization_name":"SLUB Dresden","host_organization_lineage":["https://openalex.org/I3132420320"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"doc-type:Text"},"sustainable_development_goals":[{"score":0.5400000214576721,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":32,"referenced_works":["https://openalex.org/W1558982506","https://openalex.org/W1569148339","https://openalex.org/W1595687138","https://openalex.org/W1601435884","https://openalex.org/W1647250085","https://openalex.org/W1964857063","https://openalex.org/W1978336241","https://openalex.org/W1998085622","https://openalex.org/W2018666252","https://openalex.org/W2020018978","https://openalex.org/W2020584928","https://openalex.org/W2021850646","https://openalex.org/W2022257958","https://openalex.org/W2041563709","https://openalex.org/W2041912938","https://openalex.org/W2047061289","https://openalex.org/W2058991275","https://openalex.org/W2102489964","https://openalex.org/W2106578604","https://openalex.org/W2114413252","https://openalex.org/W2118229812","https://openalex.org/W2119050385","https://openalex.org/W2120062331","https://openalex.org/W2139276812","https://openalex.org/W2147982575","https://openalex.org/W2167811976","https://openalex.org/W2170730319","https://openalex.org/W2326231806","https://openalex.org/W4237172715","https://openalex.org/W4241185933","https://openalex.org/W4242587584","https://openalex.org/W6635625694"],"related_works":["https://openalex.org/W2058438338","https://openalex.org/W2168299207","https://openalex.org/W2019471580","https://openalex.org/W2002177687","https://openalex.org/W4224920876","https://openalex.org/W2941284322","https://openalex.org/W2017309389","https://openalex.org/W2585354854","https://openalex.org/W2026059297","https://openalex.org/W4246121856"],"abstract_inverted_index":{"Accurate":[0],"cardinality":[1,16,56,125],"estimation":[2,17,57],"is":[3,11],"critically":[4],"important":[5],"to":[6,67,90],"high-quality":[7],"query":[8,84],"optimization.":[9],"It":[10],"well":[12],"known":[13],"that":[14,59,92],"conventional":[15],"based":[18,104],"on":[19,105],"histograms":[20],"or":[21,43],"similar":[22],"statistics":[23],"may":[24,127],"produce":[25,68],"extremely":[26],"poor":[27],"estimates":[28,70,93,126],"in":[29,72,109],"a":[30,53,76,106],"variety":[31],"of":[32,116],"situations,":[33],"for":[34],"example,":[35],"queries":[36],"with":[37],"complex":[38],"predicates,":[39],"correlation":[40],"among":[41],"columns,":[42],"predicates":[44],"containing":[45],"user-defined":[46],"functions.":[47],"In":[48],"this":[49],"paper,":[50],"we":[51,79],"propose":[52],"new,":[54],"general":[55],"technique":[58],"combines":[60],"random":[61],"sampling":[62],"and":[63,86,119],"materialized":[64],"view":[65],"technology":[66],"accurate":[69],"even":[71],"these":[73],"situations.":[74],"As":[75],"major":[77],"innovation,":[78],"exploit":[80],"feedback":[81],"information":[82],"from":[83],"execution":[85],"process":[87],"control":[88],"techniques":[89],"assure":[91],"remain":[94],"statistically":[95],"valid":[96],"when":[97],"the":[98,114,117,121],"underlying":[99],"data":[100],"changes.":[101],"Experimental":[102],"results":[103],"prototype":[107],"implementation":[108],"Microsoft":[110],"SQL":[111],"Server":[112],"demonstrate":[113],"practicality":[115],"approach":[118],"illustrate":[120],"dramatic":[122],"effects":[123],"improved":[124],"have.":[128]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":6},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":4},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":4}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}