{"id":"https://openalex.org/W2122902664","doi":"https://doi.org/10.1109/ssdm.2003.1214953","title":"On solving the view selection problem in distributed data warehouse architectures","display_name":"On solving the view selection problem in distributed data warehouse architectures","publication_year":2003,"publication_date":"2003-12-22","ids":{"openalex":"https://openalex.org/W2122902664","doi":"https://doi.org/10.1109/ssdm.2003.1214953","mag":"2122902664"},"language":"en","primary_location":{"id":"doi:10.1109/ssdm.2003.1214953","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ssdm.2003.1214953","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"15th International Conference on Scientific and Statistical Database Management, 2003.","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%3A78781","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5090765536","display_name":"Andreas Bauer","orcid":"https://orcid.org/0000-0002-0117-3793"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"A. Bauer","raw_affiliation_strings":["T-Systems Nova GmbH, Nuremberg, Germany","T-Syst. Nova GmbH, Nuremberg, Germany"],"affiliations":[{"raw_affiliation_string":"T-Systems Nova GmbH, Nuremberg, Germany","institution_ids":[]},{"raw_affiliation_string":"T-Syst. Nova GmbH, Nuremberg, Germany","institution_ids":[]}]},{"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":"TU Dresden","ror":"https://ror.org/042aqky30","country_code":"DE","type":"education","lineage":["https://openalex.org/I78650965"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"W. Lehner","raw_affiliation_strings":["Database Technology Group, Dresden University of Technology, Dresden, Germany","Dresden Univ. of Technol"],"affiliations":[{"raw_affiliation_string":"Database Technology Group, Dresden University of Technology, Dresden, Germany","institution_ids":["https://openalex.org/I78650965"]},{"raw_affiliation_string":"Dresden Univ. of Technol","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5090765536"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.2394,"has_fulltext":false,"cited_by_count":38,"citation_normalized_percentile":{"value":0.90533714,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"43","last_page":"51"},"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.9994000196456909,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9973999857902527,"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/materialized-view","display_name":"Materialized view","score":0.8713593482971191},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.829412579536438},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.8120681047439575},{"id":"https://openalex.org/keywords/synchronizing","display_name":"Synchronizing","score":0.5991848707199097},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.5551757216453552},{"id":"https://openalex.org/keywords/distributed-database","display_name":"Distributed database","score":0.48655667901039124},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.4810509979724884},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.4789469838142395},{"id":"https://openalex.org/keywords/node","display_name":"Node (physics)","score":0.45238757133483887},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.44788098335266113},{"id":"https://openalex.org/keywords/greedy-algorithm","display_name":"Greedy algorithm","score":0.4273325204849243},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3942241966724396},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.367293119430542},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.12163609266281128},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.12156075239181519},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.11746028065681458},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.11050847172737122}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.8713593482971191},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.829412579536438},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8120681047439575},{"id":"https://openalex.org/C162932704","wikidata":"https://www.wikidata.org/wiki/Q1058791","display_name":"Synchronizing","level":3,"score":0.5991848707199097},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.5551757216453552},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.48655667901039124},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.4810509979724884},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.4789469838142395},{"id":"https://openalex.org/C62611344","wikidata":"https://www.wikidata.org/wiki/Q1062658","display_name":"Node (physics)","level":2,"score":0.45238757133483887},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.44788098335266113},{"id":"https://openalex.org/C51823790","wikidata":"https://www.wikidata.org/wiki/Q504353","display_name":"Greedy algorithm","level":2,"score":0.4273325204849243},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3942241966724396},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.367293119430542},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.12163609266281128},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.12156075239181519},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.11746028065681458},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.11050847172737122},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","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/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C761482","wikidata":"https://www.wikidata.org/wiki/Q118093","display_name":"Transmission (telecommunications)","level":2,"score":0.0},{"id":"https://openalex.org/C66938386","wikidata":"https://www.wikidata.org/wiki/Q633538","display_name":"Structural engineering","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/ssdm.2003.1214953","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ssdm.2003.1214953","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"15th International Conference on Scientific and Statistical Database Management, 2003.","raw_type":"proceedings-article"},{"id":"pmh:oai:qucosa:de:qucosa:78781","is_oa":true,"landing_page_url":"https://tud.qucosa.de/id/qucosa%3A78781","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:78781","is_oa":true,"landing_page_url":"https://tud.qucosa.de/id/qucosa%3A78781","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":26,"referenced_works":["https://openalex.org/W38346608","https://openalex.org/W1482520531","https://openalex.org/W1520432709","https://openalex.org/W1523544086","https://openalex.org/W1538267625","https://openalex.org/W1549717312","https://openalex.org/W1591045846","https://openalex.org/W1826168298","https://openalex.org/W2054170837","https://openalex.org/W2058978608","https://openalex.org/W2103201239","https://openalex.org/W2113888164","https://openalex.org/W2114712170","https://openalex.org/W2146581901","https://openalex.org/W2160677885","https://openalex.org/W2164049396","https://openalex.org/W2950416404","https://openalex.org/W4255826646","https://openalex.org/W4289258943","https://openalex.org/W6601512833","https://openalex.org/W6628941440","https://openalex.org/W6631138925","https://openalex.org/W6631467539","https://openalex.org/W6632424119","https://openalex.org/W6632680533","https://openalex.org/W6635379732"],"related_works":["https://openalex.org/W2162280381","https://openalex.org/W2185691065","https://openalex.org/W2363712075","https://openalex.org/W2383931363","https://openalex.org/W1908544460","https://openalex.org/W2142569422","https://openalex.org/W2348265434","https://openalex.org/W2087983779","https://openalex.org/W2108498730","https://openalex.org/W152305489"],"abstract_inverted_index":{"The":[0,20,67,119],"use":[1],"of":[2,33,41,51,73,79,111,124,127,165],"materialized":[3,25],"views":[4,27],"in":[5,76,96,114,174],"a":[6,11,30,139,154,167,175],"data":[7,59,65,81,116],"warehouse":[8,82,117,177],"installation":[9],"is":[10],"common":[12],"tool":[13],"to":[14,48,91,104,131,171],"speed":[15],"up":[16],"mostly":[17],"aggregation":[18,42,129],"queries.":[19],"problems":[21],"coming":[22],"along":[23],"with":[24,89,162],"aggregate":[26],"have":[28],"triggered":[29],"huge":[31],"variety":[32],"proposals,":[34],"such":[35],"as":[36,60,62],"picking":[37],"the":[38,52,63,71,77,92,97,109,125,133,150,163],"optimal":[39],"set":[40],"combinations,":[43],"transparently":[44],"rewriting":[45],"user":[46],"queries":[47],"take":[49],"advantage":[50],"summary":[53,58],"data,":[54],"or":[55],"synchronizing":[56],"pre-computed":[57],"soon":[61],"base":[64],"changes.":[66],"paper":[68,120],"focuses":[69],"on":[70,144],"problem":[72,95,110],"view":[74,93,112],"selection":[75,94,113,141,168],"context":[78],"distributed":[80,115,134,151,176],"architectures.":[83],"While":[84],"much":[85],"research":[86],"was":[87],"done":[88],"regard":[90],"central":[98],"case,":[99],"we":[100,137,157],"are":[101],"not":[102],"aware":[103],"any":[105],"other":[106],"work":[107],"discussing":[108],"systems.":[118],"proposes":[121],"an":[122,128,145],"extension":[123],"concept":[126],"lattice":[130],"capture":[132],"semantics.":[135],"Moreover,":[136],"extend":[138],"greedy-based":[140],"algorithm":[142,169],"based":[143],"adequate":[146],"cost":[147],"model":[148],"for":[149],"case.":[152],"Within":[153],"performance":[155],"study,":[156],"finally":[158],"compare":[159],"our":[160],"findings":[161],"approach":[164],"applying":[166],"locally":[170],"each":[172],"node":[173],"environment.":[178]},"counts_by_year":[{"year":2023,"cited_by_count":2},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":6},{"year":2012,"cited_by_count":6}],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2025-10-10T00:00:00"}