{"id":"https://openalex.org/W2913724667","doi":"https://doi.org/10.1145/1559845.1559943","title":"Filtered statistics","display_name":"Filtered statistics","publication_year":2009,"publication_date":"2009-06-29","ids":{"openalex":"https://openalex.org/W2913724667","doi":"https://doi.org/10.1145/1559845.1559943","mag":"2913724667"},"language":"en","primary_location":{"id":"doi:10.1145/1559845.1559943","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1559845.1559943","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2009 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/A5062985495","display_name":"Pawe\u0142 Terlecki","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":"Pawel Terlecki","raw_affiliation_strings":["Microsoft Corp., Redmond, WA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Corp., Redmond, WA, USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5091879948","display_name":"Hardik Bati","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":"Hardik Bati","raw_affiliation_strings":["Microsoft Corp., Redmond, WA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Corp., Redmond, WA, USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5016107143","display_name":"C\u00e9sar Galindo-Legaria","orcid":"https://orcid.org/0009-0006-5344-9495"},"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":"Cesar Galindo-Legaria","raw_affiliation_strings":["Microsoft Corp., Redmond, WA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Corp., Redmond, WA, USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"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 Corp., Redmond, WA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Corp., Redmond, WA, USA","institution_ids":["https://openalex.org/I1290206253"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I1290206253"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"897","last_page":"904"},"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.9991000294685364,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9983000159263611,"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.7713416218757629},{"id":"https://openalex.org/keywords/row","display_name":"Row","score":0.6245129108428955},{"id":"https://openalex.org/keywords/predicate","display_name":"Predicate (mathematical logic)","score":0.6186427474021912},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.5940934419631958},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.5684265494346619},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.5465701222419739},{"id":"https://openalex.org/keywords/sql-server","display_name":"Sql server","score":0.49024850130081177},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.46860942244529724},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.46408841013908386},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.43516814708709717},{"id":"https://openalex.org/keywords/row-and-column-spaces","display_name":"Row and column spaces","score":0.43161600828170776},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.41290879249572754},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.37834492325782776},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3285776376724243},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.32154905796051025},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2475118339061737},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.13147372007369995}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7713416218757629},{"id":"https://openalex.org/C135598885","wikidata":"https://www.wikidata.org/wiki/Q1366302","display_name":"Row","level":2,"score":0.6245129108428955},{"id":"https://openalex.org/C140146324","wikidata":"https://www.wikidata.org/wiki/Q1144319","display_name":"Predicate (mathematical logic)","level":2,"score":0.6186427474021912},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.5940934419631958},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.5684265494346619},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.5465701222419739},{"id":"https://openalex.org/C2984286706","wikidata":"https://www.wikidata.org/wiki/Q400708","display_name":"Sql server","level":2,"score":0.49024850130081177},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.46860942244529724},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.46408841013908386},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.43516814708709717},{"id":"https://openalex.org/C104140500","wikidata":"https://www.wikidata.org/wiki/Q2088159","display_name":"Row and column spaces","level":3,"score":0.43161600828170776},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.41290879249572754},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.37834492325782776},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3285776376724243},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.32154905796051025},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2475118339061737},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.13147372007369995},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C126042441","wikidata":"https://www.wikidata.org/wiki/Q1324888","display_name":"Frame (networking)","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1559845.1559943","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1559845.1559943","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2009 ACM SIGMOD International Conference on Management of data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.6600000262260437}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":12,"referenced_works":["https://openalex.org/W1505165912","https://openalex.org/W1569148339","https://openalex.org/W2060091058","https://openalex.org/W2079557302","https://openalex.org/W2088306184","https://openalex.org/W2097710895","https://openalex.org/W2102489964","https://openalex.org/W2135779119","https://openalex.org/W2143672210","https://openalex.org/W2151310484","https://openalex.org/W2162946535","https://openalex.org/W6682418189"],"related_works":["https://openalex.org/W2313440505","https://openalex.org/W3123744736","https://openalex.org/W2137691148","https://openalex.org/W1505848319","https://openalex.org/W4281399881","https://openalex.org/W3166006430","https://openalex.org/W4281971614","https://openalex.org/W2049180840","https://openalex.org/W1992086467","https://openalex.org/W3121299875"],"abstract_inverted_index":{"Column":[0],"statistics":[1],"are":[2],"an":[3],"important":[4],"element":[5],"of":[6,16,41],"cardinality":[7,89],"estimation":[8,90],"frameworks.":[9],"More":[10],"accurate":[11],"estimates":[12],"allow":[13],"the":[14,25,87],"optimizer":[15],"a":[17,39,45],"RDBMS":[18],"to":[19,57],"generate":[20],"better":[21],"plans":[22],"and":[23],"improve":[24],"overall":[26],"system's":[27],"efficiency.":[28],"This":[29,47],"paper":[30],"introduces":[31],"filtered":[32],"statistics,":[33],"which":[34],"model":[35],"value":[36],"distribution":[37],"over":[38],"set":[40],"rows":[42],"restricted":[43],"by":[44],"predicate.":[46],"feature,":[48],"available":[49],"in":[50],"Microsoft":[51],"SQL":[52],"Server,":[53],"can":[54],"be":[55],"used":[56],"handle":[58],"column":[59],"correlation,":[60],"as":[61,63],"well":[62,73],"focus":[64],"on":[65],"interesting":[66],"data":[67],"ranges.":[68],"In":[69],"particular,":[70],"it":[71],"fits":[72],"for":[74],"scenarios":[75],"with":[76,86],"logical":[77],"subtables,":[78],"like":[79],"flexible":[80],"schema":[81],"or":[82],"multi-tenant":[83],"applications.":[84],"Integration":[85],"existing":[88],"infrastructure":[91],"is":[92],"presented.":[93]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2013,"cited_by_count":1}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}