{"id":"https://openalex.org/W3139931056","doi":"https://doi.org/10.18420/btw2021-07","title":"Aggregate-based Training Phase for ML-based Cardinality Estimation","display_name":"Aggregate-based Training Phase for ML-based Cardinality Estimation","publication_year":2021,"publication_date":"2021-01-01","ids":{"openalex":"https://openalex.org/W3139931056","doi":"https://doi.org/10.18420/btw2021-07","mag":"3139931056"},"language":"en","primary_location":{"id":"pmh:oai:qucosa:de:qucosa:89177","is_oa":true,"landing_page_url":"https://tud.qucosa.de/id/qucosa%3A89177","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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"doc-type:Text"},"type":"article","indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://tud.qucosa.de/id/qucosa%3A89177","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5077087558","display_name":"Lucas Woltmann","orcid":"https://orcid.org/0000-0003-0720-8878"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Woltmann, Lucas","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034533320","display_name":"Claudio Hartmann","orcid":"https://orcid.org/0000-0002-5334-059X"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Hartmann, Claudio","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057703543","display_name":"Dirk Habich","orcid":"https://orcid.org/0000-0002-8671-5466"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Habich, Dirk","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5063512642","display_name":"Wolfgang Lehner","orcid":"https://orcid.org/0000-0001-8107-2775"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Lehner, Wolfgang","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5077087558"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.2799,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.61930606,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"135","last_page":"154"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12535","display_name":"Machine Learning and Data Classification","score":0.628000020980835,"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/T12535","display_name":"Machine Learning and Data Classification","score":0.628000020980835,"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/T10181","display_name":"Natural Language Processing Techniques","score":0.582099974155426,"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/training","display_name":"Training (meteorology)","score":0.729853630065918},{"id":"https://openalex.org/keywords/phase","display_name":"Phase (matter)","score":0.5979149341583252},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.5183919072151184},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.4805236756801605},{"id":"https://openalex.org/keywords/estimation","display_name":"Estimation","score":0.47388002276420593},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.4660803973674774},{"id":"https://openalex.org/keywords/training-set","display_name":"Training set","score":0.4362291693687439},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.37262046337127686},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.37178125977516174},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.1940329372882843},{"id":"https://openalex.org/keywords/economics","display_name":"Economics","score":0.18378308415412903},{"id":"https://openalex.org/keywords/geography","display_name":"Geography","score":0.11716270446777344}],"concepts":[{"id":"https://openalex.org/C2777211547","wikidata":"https://www.wikidata.org/wiki/Q17141490","display_name":"Training (meteorology)","level":2,"score":0.729853630065918},{"id":"https://openalex.org/C44280652","wikidata":"https://www.wikidata.org/wiki/Q104837","display_name":"Phase (matter)","level":2,"score":0.5979149341583252},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.5183919072151184},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.4805236756801605},{"id":"https://openalex.org/C96250715","wikidata":"https://www.wikidata.org/wiki/Q965330","display_name":"Estimation","level":2,"score":0.47388002276420593},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.4660803973674774},{"id":"https://openalex.org/C51632099","wikidata":"https://www.wikidata.org/wiki/Q3985153","display_name":"Training set","level":2,"score":0.4362291693687439},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.37262046337127686},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.37178125977516174},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.1940329372882843},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.18378308415412903},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.11716270446777344},{"id":"https://openalex.org/C153294291","wikidata":"https://www.wikidata.org/wiki/Q25261","display_name":"Meteorology","level":1,"score":0.0},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C178790620","wikidata":"https://www.wikidata.org/wiki/Q11351","display_name":"Organic chemistry","level":1,"score":0.0},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"pmh:oai:qucosa:de:qucosa:89177","is_oa":true,"landing_page_url":"https://tud.qucosa.de/id/qucosa%3A89177","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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"doc-type:Text"},{"id":"doi:10.18420/btw2021-07","is_oa":true,"landing_page_url":"https://doi.org/10.18420/btw2021-07","pdf_url":null,"source":{"id":"https://openalex.org/S7407052918","display_name":"Gesellschaft f\u00fcr Informatik (GI)","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article-journal"},{"id":"mag:3139931056","is_oa":false,"landing_page_url":"https://dblp.uni-trier.de/db/conf/btw/btw2021.html#WoltmannHHL21","pdf_url":null,"source":{"id":"https://openalex.org/S4306504987","display_name":"BTW","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":"BTW","raw_type":null}],"best_oa_location":{"id":"pmh:oai:qucosa:de:qucosa:89177","is_oa":true,"landing_page_url":"https://tud.qucosa.de/id/qucosa%3A89177","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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"doc-type:Text"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2169027522","https://openalex.org/W2231243630","https://openalex.org/W2353899804","https://openalex.org/W1524715972","https://openalex.org/W2048000333","https://openalex.org/W2508520911","https://openalex.org/W3184006218","https://openalex.org/W2540425980","https://openalex.org/W2121436925","https://openalex.org/W2059869209","https://openalex.org/W2734657936","https://openalex.org/W3096615750","https://openalex.org/W2770734487","https://openalex.org/W3021999553","https://openalex.org/W2994425563","https://openalex.org/W3105986941","https://openalex.org/W2384246784","https://openalex.org/W1923692276","https://openalex.org/W2942927996"],"abstract_inverted_index":{"Cardinality":[0],"estimation":[1,123],"is":[2,89],"a":[3,31,47,92,115],"fundamental":[4],"task":[5],"in":[6,14,75,125,137],"database":[7],"query":[8,70],"processing":[9],"and":[10,72,99,155],"optimization.":[11],"As":[12,128],"shown":[13],"recent":[15],"papers,":[16],"machine":[17],"learning":[18],"(ML)-based":[19],"approaches":[20,124],"may":[21],"deliver":[22],"more":[23],"accurate":[24],"cardinality":[25,122],"estimations":[26],"than":[27],"traditional":[28],"approaches.":[29],"However,":[30],"lot":[32],"of":[33,56,95,148],"training":[34,43,58,84,118,153],"queries":[35,61,104],"have":[36,67],"to":[37,45,90,100,132,143],"be":[38],"executed":[39],"during":[40],"the":[41,63,68,82,96,102],"model":[42,50,83],"phase":[44,119,154],"learn":[46],"data-dependent":[48],"ML":[49],"making":[51],"it":[52],"very":[53],"time-consuming.":[54],"Many":[55],"those":[57],"or":[59],"example":[60,103],"use":[62],"same":[64,69],"base":[65,97],"data,":[66],"structure,":[71],"only":[73],"differ":[74],"their":[76],"selective":[77],"predicates.":[78],"To":[79],"speed":[80],"up":[81],"phase,":[85],"our":[86,138,151],"core":[87],"idea":[88],"determine":[91],"predicate-independent":[93],"pre-aggregation":[94],"data":[98],"execute":[101],"over":[105],"this":[106,111,126],"pre-aggregated":[107],"data.":[108],"Based":[109],"on":[110],"idea,":[112],"we":[113,129,140],"present":[114],"specific":[116],"aggregate-based":[117,152],"for":[120],"ML-based":[121],"paper.":[127],"are":[130,141],"going":[131],"show":[133],"with":[134,150],"different":[135],"workloads":[136],"evaluation,":[139],"able":[142],"achieve":[144],"an":[145],"average":[146],"speedup":[147],"63":[149],"thus":[156],"outperform":[157],"indexes.":[158]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}