{"id":"https://openalex.org/W4301397229","doi":"https://doi.org/10.1007/s10796-022-10320-2","title":"Cost-based Optimization of Multistore Query Plans","display_name":"Cost-based Optimization of Multistore Query Plans","publication_year":2022,"publication_date":"2022-10-04","ids":{"openalex":"https://openalex.org/W4301397229","doi":"https://doi.org/10.1007/s10796-022-10320-2"},"language":"en","primary_location":{"id":"doi:10.1007/s10796-022-10320-2","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s10796-022-10320-2","pdf_url":null,"source":{"id":"https://openalex.org/S181659395","display_name":"Information Systems Frontiers","issn_l":"1387-3326","issn":["1387-3326","1572-9419"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information Systems Frontiers","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://doi.org/10.1007/s10796-022-10320-2","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5085402801","display_name":"Chiara Forresi","orcid":"https://orcid.org/0000-0001-5652-2455"},"institutions":[{"id":"https://openalex.org/I9360294","display_name":"University of Bologna","ror":"https://ror.org/01111rn36","country_code":"IT","type":"education","lineage":["https://openalex.org/I9360294"]}],"countries":["IT"],"is_corresponding":true,"raw_author_name":"Chiara Forresi","raw_affiliation_strings":["DISI - Department of Computer Science and Engineering, University of Bologna, Via dell\u2019Universit\u00e0 50, Cesena, 47522, Italy","DISI - Department of Computer Science and Engineering, University of Bologna, Via dell'Universit\u00e0 50, Cesena, 47522, Italy"],"affiliations":[{"raw_affiliation_string":"DISI - Department of Computer Science and Engineering, University of Bologna, Via dell\u2019Universit\u00e0 50, Cesena, 47522, Italy","institution_ids":["https://openalex.org/I9360294"]},{"raw_affiliation_string":"DISI - Department of Computer Science and Engineering, University of Bologna, Via dell'Universit\u00e0 50, Cesena, 47522, Italy","institution_ids":["https://openalex.org/I9360294"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5066196370","display_name":"Matteo Francia","orcid":"https://orcid.org/0000-0002-0805-1051"},"institutions":[{"id":"https://openalex.org/I9360294","display_name":"University of Bologna","ror":"https://ror.org/01111rn36","country_code":"IT","type":"education","lineage":["https://openalex.org/I9360294"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Matteo Francia","raw_affiliation_strings":["DISI - Department of Computer Science and Engineering, University of Bologna, Via dell\u2019Universit\u00e0 50, Cesena, 47522, Italy","DISI - Department of Computer Science and Engineering, University of Bologna, Via dell'Universit\u00e0 50, Cesena, 47522, Italy"],"affiliations":[{"raw_affiliation_string":"DISI - Department of Computer Science and Engineering, University of Bologna, Via dell\u2019Universit\u00e0 50, Cesena, 47522, Italy","institution_ids":["https://openalex.org/I9360294"]},{"raw_affiliation_string":"DISI - Department of Computer Science and Engineering, University of Bologna, Via dell'Universit\u00e0 50, Cesena, 47522, Italy","institution_ids":["https://openalex.org/I9360294"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5042827875","display_name":"Enrico Gallinucci","orcid":"https://orcid.org/0000-0002-0931-4255"},"institutions":[{"id":"https://openalex.org/I9360294","display_name":"University of Bologna","ror":"https://ror.org/01111rn36","country_code":"IT","type":"education","lineage":["https://openalex.org/I9360294"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Enrico Gallinucci","raw_affiliation_strings":["DISI - Department of Computer Science and Engineering, University of Bologna, Via dell\u2019Universit\u00e0 50, Cesena, 47522, Italy","DISI - Department of Computer Science and Engineering, University of Bologna, Via dell'Universit\u00e0 50, Cesena, 47522, Italy"],"affiliations":[{"raw_affiliation_string":"DISI - Department of Computer Science and Engineering, University of Bologna, Via dell\u2019Universit\u00e0 50, Cesena, 47522, Italy","institution_ids":["https://openalex.org/I9360294"]},{"raw_affiliation_string":"DISI - Department of Computer Science and Engineering, University of Bologna, Via dell'Universit\u00e0 50, Cesena, 47522, Italy","institution_ids":["https://openalex.org/I9360294"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5029448963","display_name":"Matteo Golfarelli","orcid":"https://orcid.org/0000-0002-0437-0725"},"institutions":[{"id":"https://openalex.org/I9360294","display_name":"University of Bologna","ror":"https://ror.org/01111rn36","country_code":"IT","type":"education","lineage":["https://openalex.org/I9360294"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Matteo Golfarelli","raw_affiliation_strings":["DISI - Department of Computer Science and Engineering, University of Bologna, Via dell\u2019Universit\u00e0 50, Cesena, 47522, Italy","DISI - Department of Computer Science and Engineering, University of Bologna, Via dell'Universit\u00e0 50, Cesena, 47522, Italy"],"affiliations":[{"raw_affiliation_string":"DISI - Department of Computer Science and Engineering, University of Bologna, Via dell\u2019Universit\u00e0 50, Cesena, 47522, Italy","institution_ids":["https://openalex.org/I9360294"]},{"raw_affiliation_string":"DISI - Department of Computer Science and Engineering, University of Bologna, Via dell'Universit\u00e0 50, Cesena, 47522, Italy","institution_ids":["https://openalex.org/I9360294"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5085402801"],"corresponding_institution_ids":["https://openalex.org/I9360294"],"apc_list":{"value":2290,"currency":"EUR","value_usd":2890},"apc_paid":{"value":2290,"currency":"EUR","value_usd":2890},"fwci":0.8947,"has_fulltext":true,"cited_by_count":6,"citation_normalized_percentile":{"value":0.72645215,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":97},"biblio":{"volume":"25","issue":"5","first_page":"1925","last_page":"1951"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9997000098228455,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9997000098228455,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994000196456909,"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/T11719","display_name":"Data Quality and Management","score":0.9993000030517578,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.908929705619812},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.6918060779571533},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.6535245180130005},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.6473371982574463},{"id":"https://openalex.org/keywords/exploit","display_name":"Exploit","score":0.6230297684669495},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5442519187927246},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.40895015001296997},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3943255543708801},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.32805290818214417},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.27311334013938904},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.19275382161140442},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.16790810227394104},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.12216386198997498}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.908929705619812},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.6918060779571533},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.6535245180130005},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.6473371982574463},{"id":"https://openalex.org/C165696696","wikidata":"https://www.wikidata.org/wiki/Q11287","display_name":"Exploit","level":2,"score":0.6230297684669495},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5442519187927246},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.40895015001296997},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3943255543708801},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.32805290818214417},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.27311334013938904},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.19275382161140442},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.16790810227394104},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.12216386198997498},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1007/s10796-022-10320-2","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s10796-022-10320-2","pdf_url":null,"source":{"id":"https://openalex.org/S181659395","display_name":"Information Systems Frontiers","issn_l":"1387-3326","issn":["1387-3326","1572-9419"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information Systems Frontiers","raw_type":"journal-article"},{"id":"pmh:oai:cris.unibo.it:11585/897260","is_oa":true,"landing_page_url":"https://hdl.handle.net/11585/897260","pdf_url":"https://cris.unibo.it/bitstream/11585/897260/1/s10796-022-10320-2.pdf","source":{"id":"https://openalex.org/S4306402579","display_name":"Archivio istituzionale della ricerca (Alma Mater Studiorum Universit\u00e0 di Bologna)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210117483","host_organization_name":"Istituto di Ematologia di Bologna","host_organization_lineage":["https://openalex.org/I4210117483"],"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":"","raw_type":"info:eu-repo/semantics/article"},{"id":"pmh:oai:RePEc:spr:infosf:v:25:y:2023:i:5:d:10.1007_s10796-022-10320-2","is_oa":false,"landing_page_url":"http://link.springer.com/10.1007/s10796-022-10320-2","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"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":"article"}],"best_oa_location":{"id":"doi:10.1007/s10796-022-10320-2","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s10796-022-10320-2","pdf_url":null,"source":{"id":"https://openalex.org/S181659395","display_name":"Information Systems Frontiers","issn_l":"1387-3326","issn":["1387-3326","1572-9419"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information Systems Frontiers","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":42,"referenced_works":["https://openalex.org/W72855768","https://openalex.org/W108054527","https://openalex.org/W1578512165","https://openalex.org/W1967969088","https://openalex.org/W2008120802","https://openalex.org/W2008235117","https://openalex.org/W2027837929","https://openalex.org/W2041106018","https://openalex.org/W2059268928","https://openalex.org/W2079329679","https://openalex.org/W2100088960","https://openalex.org/W2124011064","https://openalex.org/W2132204247","https://openalex.org/W2140749167","https://openalex.org/W2180737804","https://openalex.org/W2260616469","https://openalex.org/W2295240344","https://openalex.org/W2434390175","https://openalex.org/W2437615532","https://openalex.org/W2523955029","https://openalex.org/W2607033965","https://openalex.org/W2627491027","https://openalex.org/W2639544096","https://openalex.org/W2783360436","https://openalex.org/W2791574640","https://openalex.org/W2889140904","https://openalex.org/W2908805957","https://openalex.org/W2911731033","https://openalex.org/W2913041555","https://openalex.org/W2917247870","https://openalex.org/W2944056255","https://openalex.org/W2953028579","https://openalex.org/W2953177763","https://openalex.org/W2982382150","https://openalex.org/W2982629221","https://openalex.org/W3105473355","https://openalex.org/W3128828942","https://openalex.org/W3171610324","https://openalex.org/W3176405775","https://openalex.org/W3194766394","https://openalex.org/W4240869453","https://openalex.org/W4323053763"],"related_works":["https://openalex.org/W2378924333","https://openalex.org/W2362446711","https://openalex.org/W2064616681","https://openalex.org/W1495801388","https://openalex.org/W2551308855","https://openalex.org/W1977331029","https://openalex.org/W1760549314","https://openalex.org/W50436801","https://openalex.org/W2941854747","https://openalex.org/W1943557536"],"abstract_inverted_index":{"Abstract":[0],"Multistores":[1],"are":[2],"data":[3,26,34,55,100],"management":[4],"systems":[5],"that":[6,154],"enable":[7],"query":[8],"processing":[9],"across":[10],"different":[11,83,93,105,159],"and":[12,25,33,56,60,81,99,120,145],"heterogeneous":[13],"databases;":[14],"besides":[15],"the":[16,46,53,58,74,87,122,129,132,137,142,152,156],"distribution":[17],"of":[18,52,62,76,131,158],"data,":[19],"complexity":[20],"factors":[21,153],"like":[22],"schema":[23,106],"heterogeneity":[24],"replication":[27],"must":[28],"be":[29],"resolved":[30],"through":[31],"integration":[32],"fusion":[35,101],"activities.":[36],"Our":[37],"multistore":[38,148],"solution":[39],"relies":[40],"on":[41,86,104],"a":[42,70,109],"dataspace":[43],"to":[44,72,95,116,150],"provide":[45],"user":[47],"with":[48],"an":[49],"integrated":[50],"view":[51],"available":[54],"enables":[57],"formulation":[59],"execution":[61,75,84,118,139],"GPSJ":[63,77],"queries.":[64],"In":[65,89],"this":[66],"paper,":[67],"we":[68,91],"propose":[69],"technique":[71],"optimize":[73],"queries":[78,144],"by":[79,102],"formulating":[80],"evaluating":[82],"plans":[85],"multistore.":[88],"particular,":[90],"outline":[92],"strategies":[94],"carry":[96],"out":[97],"joins":[98],"relying":[103],"representations;":[107],"then,":[108],"self-learning":[110],"black-box":[111],"cost":[112,133],"model":[113,134],"is":[114],"used":[115],"estimate":[117],"times":[119],"select":[121],"most":[123],"efficient":[124],"plan.":[125],"The":[126],"experiments":[127],"assess":[128],"effectiveness":[130],"in":[135],"choosing":[136],"best":[138],"plan":[140],"for":[141],"given":[143],"exploit":[146],"multiple":[147],"benchmarks":[149],"investigate":[151],"influence":[155],"performance":[157],"plans.":[160]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":2}],"updated_date":"2026-03-18T14:38:29.013473","created_date":"2025-10-10T00:00:00"}