{"id":"https://openalex.org/W2036461974","doi":"https://doi.org/10.1145/1516360.1516408","title":"Sample synopses for approximate answering of group-by queries","display_name":"Sample synopses for approximate answering of group-by queries","publication_year":2009,"publication_date":"2009-03-24","ids":{"openalex":"https://openalex.org/W2036461974","doi":"https://doi.org/10.1145/1516360.1516408","mag":"2036461974"},"language":"en","primary_location":{"id":"doi:10.1145/1516360.1516408","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1516360.1516408","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology","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%3A76731","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5083506277","display_name":"Philipp R\u00f6sch","orcid":null},"institutions":[{"id":"https://openalex.org/I78650965","display_name":"Technische Universit\u00e4t Dresden","ror":"https://ror.org/042aqky30","country_code":"DE","type":"education","lineage":["https://openalex.org/I78650965"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Philipp R\u00f6sch","raw_affiliation_strings":["Technische Universit\u00e4t Dresden, Dresden, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Technische Universit\u00e4t Dresden, Dresden, Germany","institution_ids":["https://openalex.org/I78650965"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5063512642","display_name":"Wolfgang Lehner","orcid":"https://orcid.org/0000-0001-8107-2775"},"institutions":[{"id":"https://openalex.org/I78650965","display_name":"Technische Universit\u00e4t Dresden","ror":"https://ror.org/042aqky30","country_code":"DE","type":"education","lineage":["https://openalex.org/I78650965"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Wolfgang Lehner","raw_affiliation_strings":["Technische Universit\u00e4t Dresden, Dresden, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Technische Universit\u00e4t Dresden, Dresden, Germany","institution_ids":["https://openalex.org/I78650965"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.0887,"has_fulltext":false,"cited_by_count":17,"citation_normalized_percentile":{"value":0.78920901,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"403","last_page":"414"},"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.9998000264167786,"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.9998000264167786,"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.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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9973000288009644,"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/computer-science","display_name":"Computer science","score":0.7321274876594543},{"id":"https://openalex.org/keywords/sample","display_name":"Sample (material)","score":0.7142063975334167},{"id":"https://openalex.org/keywords/group","display_name":"Group (periodic table)","score":0.6056384444236755},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4707910120487213},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.36397886276245117},{"id":"https://openalex.org/keywords/chemistry","display_name":"Chemistry","score":0.09605255722999573}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7321274876594543},{"id":"https://openalex.org/C198531522","wikidata":"https://www.wikidata.org/wiki/Q485146","display_name":"Sample (material)","level":2,"score":0.7142063975334167},{"id":"https://openalex.org/C2781311116","wikidata":"https://www.wikidata.org/wiki/Q83306","display_name":"Group (periodic table)","level":2,"score":0.6056384444236755},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4707910120487213},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.36397886276245117},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.09605255722999573},{"id":"https://openalex.org/C43617362","wikidata":"https://www.wikidata.org/wiki/Q170050","display_name":"Chromatography","level":1,"score":0.0},{"id":"https://openalex.org/C178790620","wikidata":"https://www.wikidata.org/wiki/Q11351","display_name":"Organic chemistry","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1516360.1516408","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1516360.1516408","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology","raw_type":"proceedings-article"},{"id":"pmh:oai:qucosa:de:qucosa:76731","is_oa":true,"landing_page_url":"https://tud.qucosa.de/id/qucosa%3A76731","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:76731","is_oa":true,"landing_page_url":"https://tud.qucosa.de/id/qucosa%3A76731","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":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":31,"referenced_works":["https://openalex.org/W153182319","https://openalex.org/W1510305954","https://openalex.org/W1577912117","https://openalex.org/W1597532222","https://openalex.org/W1597561788","https://openalex.org/W1784244685","https://openalex.org/W1968032985","https://openalex.org/W2020584928","https://openalex.org/W2021850646","https://openalex.org/W2037701287","https://openalex.org/W2049127440","https://openalex.org/W2078907037","https://openalex.org/W2092090135","https://openalex.org/W2101748181","https://openalex.org/W2102489964","https://openalex.org/W2110557355","https://openalex.org/W2117348908","https://openalex.org/W2119885577","https://openalex.org/W2132734085","https://openalex.org/W2139276812","https://openalex.org/W2151065878","https://openalex.org/W2169982181","https://openalex.org/W2171903035","https://openalex.org/W2199389590","https://openalex.org/W4241185933","https://openalex.org/W4242587584","https://openalex.org/W4250212406","https://openalex.org/W6635637936","https://openalex.org/W6635650928","https://openalex.org/W6845883598","https://openalex.org/W7027112824"],"related_works":["https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W2358668433","https://openalex.org/W2376932109","https://openalex.org/W2382290278","https://openalex.org/W2350741829","https://openalex.org/W2130043461","https://openalex.org/W2530322880","https://openalex.org/W1596801655"],"abstract_inverted_index":{"With":[0,150],"the":[1,30,44,50,53,57,73,77,109,112,132,138,163,167],"amount":[2],"of":[3,23,35,67,79,111,154],"data":[4,7,45],"in":[5,17,95,143],"current":[6],"warehouse":[8],"databases":[9],"growing":[10],"steadily,":[11],"random":[12],"sampling":[13,90],"is":[14,70,93,121,130],"continuously":[15],"gaining":[16],"importance.":[18],"In":[19,83],"particular,":[20],"interactive":[21],"analyses":[22],"large":[24],"datasets":[25],"can":[26],"greatly":[27],"benefit":[28],"from":[29],"significantly":[31],"shorter":[32],"response":[33],"times":[34],"approximate":[36],"query":[37],"processing.":[38],"Typically,":[39],"those":[40],"analytical":[41],"queries":[42,69,100],"partition":[43],"into":[46],"groups":[47],"and":[48,61,166],"aggregate":[49],"values":[51],"within":[52],"groups.":[54],"Further,":[55],"with":[56,101],"commonly":[58],"used":[59],"roll-up":[60],"drill-down":[62],"operations":[63],"a":[64,88,135,147],"broad":[65],"range":[66],"group-by":[68,99],"posed":[71],"to":[72,97,145,171],"system,":[74],"which":[75],"makes":[76],"construction":[78,168],"highly-specialized":[80],"synopses":[81],"difficult.":[82],"this":[84],"paper,":[85],"we":[86,156],"propose":[87],"general-purpose":[89],"scheme":[91],"that":[92,131,158],"biased":[94],"order":[96,144],"answer":[98],"high":[102],"accuracy.":[103],"While":[104],"existing":[105,172],"techniques":[106],"focus":[107],"on":[108,123],"size":[110],"group":[113,136],"when":[114],"computing":[115],"its":[116,124],"sample":[117],"size,":[118],"our":[119,159],"technique":[120],"based":[122],"standard":[125],"deviation.":[126],"The":[127],"basic":[128],"idea":[129],"more":[133],"homogeneous":[134],"is,":[137],"less":[139],"representatives":[140],"are":[141],"required":[142],"give":[146],"good":[148],"estimate.":[149],"an":[151],"extensive":[152],"set":[153],"experiments,":[155],"show":[157],"approach":[160],"reduces":[161],"both":[162],"estimation":[164],"error":[165],"cost":[169],"compared":[170],"techniques.":[173]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}