{"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","alternate_titles":[],"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","doi":"https://doi.org/10.1145/1317331.1317335","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1317331.1317335","pdf_url":null,"source":{"id":"https://openalex.org/S7407086703","display_name":"ACM International Workshop on Data Warehousing and OLAP (DOLAP)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"conference"},"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"},"parent_works":[],"lineage":["https://openalex.org/W2007993174"],"child_works_count":0,"type":"conference-paper","is_traditional":true,"indexed_in":["arxiv","crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://r-libre.teluq.ca/200/1/0703058-2","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5074043284","display_name":"Kamel Aouiche","orcid":null,"observed_orcids":[]},"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":"Kamel Aouiche","raw_affiliation_strings":["LICEF: Universit\u00e9 du Qu\u00e9bec \u00e0 Montr\u00e9al, Montreal, PQ, Canada"],"raw_orcid":null,"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","observed_orcids":["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"],"raw_orcid":null,"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":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I159129438"],"apc_list":null,"apc_paid":null,"fwci":1.0331,"has_fulltext":true,"cited_by_count":24,"citation_normalized_percentile":{"value":0.73815129,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"17","last_page":"24"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.986299991607666,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.986299991607666,"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"}},{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.002199999988079071,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11269","display_name":"Algorithms and Data Compression","score":0.001500000013038516,"subfield":{"id":"https://openalex.org/subfields/2614","display_name":"Theoretical Computer Science"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/olap","display_name":"OLAP","score":0.9079999923706055},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"data warehouse","score":0.6800000071525574},{"id":"https://openalex.org/keywords/view-materialization","display_name":"view materialization","score":0.9010000228881836},{"id":"https://openalex.org/keywords/probabilistic-counting","display_name":"probabilistic counting","score":0.9570000171661377},{"id":"https://openalex.org/keywords/hashing","display_name":"hashing","score":0.41600000858306885},{"id":"https://openalex.org/keywords/memory-efficient-estimation","display_name":"memory-efficient estimation","score":0.5270000100135803}],"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":7,"locations":[{"id":"doi:10.1145/1317331.1317335","doi":"https://doi.org/10.1145/1317331.1317335","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1317331.1317335","pdf_url":null,"source":{"id":"https://openalex.org/S7407086703","display_name":"ACM International Workshop on Data Warehousing and OLAP (DOLAP)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"conference"},"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","doi":null,"is_oa":true,"landing_page_url":"https://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,"listed_in":[],"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":null,"raw_type":"PeerReviewed"},{"id":"pmh:oai:www.archipel.uqam.ca:373","doi":null,"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":"Archipel (Universit\u00e9 du Qu\u00e9bec \u00e0 Montr\u00e9al)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"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":"PeerReviewed"},{"id":"pmh:oai:arXiv.org:cs/0703058","doi":null,"is_oa":true,"landing_page_url":"https://arxiv.org/abs/cs/0703058","pdf_url":"https://arxiv.org/pdf/cs/0703058","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"doi:10.48550/arxiv.cs/0703058","doi":"https://doi.org/10.48550/arxiv.cs/0703058","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.cs/0703058","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.342.6687","doi":null,"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","doi":null,"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":{"id":"pmh:oai:r-libre.teluq.ca:200","doi":null,"is_oa":true,"landing_page_url":"https://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,"listed_in":[],"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":null,"raw_type":"PeerReviewed"},"sustainable_development_goals":[],"study_designs":[],"awards":[{"id":"https://openalex.org/G7101868061","display_name":null,"funder_award_id":"261437","funder_id":"https://openalex.org/F4320334593","funder_display_name":"Natural Sciences and Engineering Research Council of Canada"}],"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":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2007993174.pdf","grobid_xml":"https://content.openalex.org/works/W2007993174.grobid-xml"},"referenced_works_count":19,"referenced_works":["https://openalex.org/W1601435884","https://openalex.org/W1607125004","https://openalex.org/W1623444038","https://openalex.org/W1643439392","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","https://openalex.org/W7053186606"],"related_works":["https://openalex.org/W7053186606","https://openalex.org/W37169358","https://openalex.org/W2321190922","https://openalex.org/W2990246256","https://openalex.org/W7098486155","https://openalex.org/W2532060087","https://openalex.org/W3088491908","https://openalex.org/W1550799239","https://openalex.org/W2523379486","https://openalex.org/W2369265860"],"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]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2007993174","counts_by_year":[{"year":2020,"cited_by_count":1},{"year":2018,"cited_by_count":2},{"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":3},{"year":2012,"cited_by_count":2}],"updated_date":"2026-11-19T14:11:59.513116","created_date":"2016-06-24T00:00:00"}
