{"id":"https://openalex.org/W2007993174","doi":"https://doi.org/10.1145/1317331.1317335","title":"A comparison of five probabilistic view-size estimation techniques in OLAP","display_name":"A comparison of five probabilistic view-size estimation techniques in OLAP","publication_year":2007,"publication_date":"2007-11-09","ids":{"openalex":"https://openalex.org/W2007993174","doi":"https://doi.org/10.1145/1317331.1317335","mag":"2007993174"},"language":"en","primary_location":{"id":"doi:10.1145/1317331.1317335","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1317331.1317335","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM tenth international workshop on Data warehousing and OLAP","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/A5074043284","display_name":"Kamel Aouiche","orcid":null},"institutions":[{"id":"https://openalex.org/I159129438","display_name":"Universit\u00e9 du Qu\u00e9bec \u00e0 Montr\u00e9al","ror":"https://ror.org/002rjbv21","country_code":"CA","type":"education","lineage":["https://openalex.org/I159129438","https://openalex.org/I49663120"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"Kamel Aouiche","raw_affiliation_strings":["LICEF: Universit\u00e9 du Qu\u00e9bec \u00e0 Montr\u00e9al, Montreal, PQ, Canada"],"affiliations":[{"raw_affiliation_string":"LICEF: Universit\u00e9 du Qu\u00e9bec \u00e0 Montr\u00e9al, Montreal, PQ, Canada","institution_ids":["https://openalex.org/I159129438"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5045561693","display_name":"Daniel Lemire","orcid":"https://orcid.org/0000-0003-3306-6922"},"institutions":[{"id":"https://openalex.org/I159129438","display_name":"Universit\u00e9 du Qu\u00e9bec \u00e0 Montr\u00e9al","ror":"https://ror.org/002rjbv21","country_code":"CA","type":"education","lineage":["https://openalex.org/I159129438","https://openalex.org/I49663120"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Daniel Lemire","raw_affiliation_strings":["LICEF: Universit\u00e9 du Qu\u00e9bec \u00e0 Montr\u00e9al, Montreal, PQ, Canada"],"affiliations":[{"raw_affiliation_string":"LICEF: Universit\u00e9 du Qu\u00e9bec \u00e0 Montr\u00e9al, Montreal, PQ, Canada","institution_ids":["https://openalex.org/I159129438"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5074043284"],"corresponding_institution_ids":["https://openalex.org/I159129438"],"apc_list":null,"apc_paid":null,"fwci":1.9319,"has_fulltext":false,"cited_by_count":22,"citation_normalized_percentile":{"value":0.87810139,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"17","last_page":"24"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12761","display_name":"Data Stream Mining Techniques","score":0.9987999796867371,"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"}},"topics":[{"id":"https://openalex.org/T12761","display_name":"Data Stream Mining Techniques","score":0.9987999796867371,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9977999925613403,"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.9977999925613403,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.7128863334655762},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6754182577133179},{"id":"https://openalex.org/keywords/probabilistic-logic","display_name":"Probabilistic logic","score":0.654758095741272},{"id":"https://openalex.org/keywords/estimation","display_name":"Estimation","score":0.5370219349861145},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.36763960123062134},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.21625745296478271},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.0701414942741394},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.058328866958618164}],"concepts":[{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.7128863334655762},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6754182577133179},{"id":"https://openalex.org/C49937458","wikidata":"https://www.wikidata.org/wiki/Q2599292","display_name":"Probabilistic logic","level":2,"score":0.654758095741272},{"id":"https://openalex.org/C96250715","wikidata":"https://www.wikidata.org/wiki/Q965330","display_name":"Estimation","level":2,"score":0.5370219349861145},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.36763960123062134},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.21625745296478271},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.0701414942741394},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.058328866958618164},{"id":"https://openalex.org/C201995342","wikidata":"https://www.wikidata.org/wiki/Q682496","display_name":"Systems engineering","level":1,"score":0.0}],"mesh":[],"locations_count":5,"locations":[{"id":"doi:10.1145/1317331.1317335","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1317331.1317335","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM tenth international workshop on Data warehousing and OLAP","raw_type":"proceedings-article"},{"id":"pmh:oai:r-libre.teluq.ca:200","is_oa":false,"landing_page_url":"http://r-libre.teluq.ca/200/1/0703058-2","pdf_url":null,"source":{"id":"https://openalex.org/S4306401909","display_name":"R-libre (Universit\u00e9 T\u00e9luq)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I200745827","host_organization_name":"Universit\u00e9 T\u00c9LUQ","host_organization_lineage":["https://openalex.org/I200745827"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":"","raw_type":"Communications dans des actes de congr\u00e8s/colloques"},{"id":"pmh:oai:www.archipel.uqam.ca:373","is_oa":false,"landing_page_url":"http://www.archipel.uqam.ca/373/1/0703058-2","pdf_url":null,"source":{"id":"https://openalex.org/S4306401005","display_name":"Archipelago (Universit\u00e9 du Qu\u00e9bec \u00e0 Montr\u00e9al)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210093668","host_organization_name":"Quebec Intensive Silviculture Network","host_organization_lineage":["https://openalex.org/I4210093668"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":"","raw_type":"Communication, article de congr\u00e8s ou colloque"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.342.6687","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.342.6687","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://arxiv.org/pdf/cs/0703058v2.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.342.7615","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.342.7615","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://arxiv.org/pdf/cs/0703058v3.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.46000000834465027,"display_name":"Decent work and economic growth","id":"https://metadata.un.org/sdg/8"}],"awards":[],"funders":[{"id":"https://openalex.org/F4320311271","display_name":"Universit\u00e9 du Qu\u00e9bec \u00e0 Montr\u00e9al","ror":"https://ror.org/002rjbv21"},{"id":"https://openalex.org/F4320321747","display_name":"Fonds Qu\u00e9b\u00e9cois de la Recherche sur la Nature et les Technologies","ror":"https://ror.org/00b9f9778"},{"id":"https://openalex.org/F4320334593","display_name":"Natural Sciences and Engineering Research Council of Canada","ror":"https://ror.org/01h531d29"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":17,"referenced_works":["https://openalex.org/W1601435884","https://openalex.org/W1607125004","https://openalex.org/W1782917577","https://openalex.org/W1785933978","https://openalex.org/W1964089073","https://openalex.org/W2003262311","https://openalex.org/W2008365755","https://openalex.org/W2025051251","https://openalex.org/W2052884373","https://openalex.org/W2064379477","https://openalex.org/W2086604416","https://openalex.org/W2099480861","https://openalex.org/W2103201239","https://openalex.org/W2112400233","https://openalex.org/W2114712170","https://openalex.org/W2131491007","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W3004775508","https://openalex.org/W2057117937","https://openalex.org/W3011164083","https://openalex.org/W46087827","https://openalex.org/W2751504412","https://openalex.org/W2369735097","https://openalex.org/W4290792893","https://openalex.org/W1571563640","https://openalex.org/W2980494216","https://openalex.org/W4249420661"],"abstract_inverted_index":{"A":[0],"data":[1],"warehouse":[2],"cannot":[3],"materialize":[4],"all":[5],"possible":[6],"views,":[7],"hence":[8],"we":[9,109],"must":[10],"estimate":[11,51],"quickly,":[12],"accurately,":[13],"and":[14,37,53,74,86],"reliably":[15],"the":[16,22,95,98,111],"size":[17,96],"of":[18,94,97,100],"views":[19],"to":[20],"determine":[21],"best":[23],"candidates":[24],"for":[25,30],"materialization.":[26],"Many":[27],"available":[28],"techniques":[29,46,69],"view-size":[31,67],"estimation":[32,68],"make":[33],"particular":[34],"statistical":[35],"assumptions":[36],"their":[38],"error":[39],"can":[40],"be":[41],"large.":[42],"Comparatively,":[43],"unassuming":[44,65],"probabilistic":[45],"are":[47],"slower,":[48],"but":[49],"they":[50],"accurately":[52],"reliability":[54],"very":[55],"large":[56],"view":[57],"sizes":[58],"using":[59],"little":[60],"memory.":[61],"We":[62],"compare":[63],"five":[64],"hashing-based":[66],"including":[70],"Stochastic":[71],"Probabilistic":[72,76],"Counting":[73,88,104],"LOGLOG":[75],"Counting.":[77],"Our":[78],"experiments":[79],"show":[80],"that":[81],"only":[82,102],"Generalized":[83],"Counting,":[84],"Gibbons-Tirthapura,":[85],"Adaptive":[87,103],"provide":[89],"universally":[90],"tight":[91],"estimates":[92],"irrespective":[93],"view;":[99],"those,":[101],"remains":[105],"constantly":[106],"fast":[107],"as":[108],"increase":[110],"memory":[112],"budget.":[113]},"counts_by_year":[{"year":2020,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":3},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":3}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}