- AutorIn
- Wolfgang Lehner Technische Universität Dresden, Fakultät Informatik, Institut für Systemarchitektur, Professur Datenbanken
- Andreas Bauer
- Titel
- On solving the view selection problem in distributed data warehouse architectures
- Zitierfähige Url:
- https://nbn-resolving.org/urn:nbn:de:bsz:14-qucosa2-787813
- Konferenz
- 15th International Conference on Scientific and Statistical Database Management. Cambridge, MA, 09.-11.07.2003
- Quellenangabe
- 15th International Conference on Scientific and Statistical Database Management
Erscheinungsort: New York, NY
Verlag: Institute of Electrical and Electronics Engineers incorporated (IEEE)
Erscheinungsjahr: 2003
Seiten: 43-51
ISBN: 0-7695-1964-4 - Erstveröffentlichung
- 2003
- Abstract (EN)
- The use of materialized views in a data warehouse installation is a common tool to speed up mostly aggregation queries. The problems coming along with materialized aggregate views have triggered a huge variety of proposals, such as picking the optimal set of aggregation combinations, transparently rewriting user queries to take advantage of the summary data, or synchronizing pre-computed summary data as soon as the base data changes. The paper focuses on the problem of view selection in the context of distributed data warehouse architectures. While much research was done with regard to the view selection problem in the central case, we are not aware to any other work discussing the problem of view selection in distributed data warehouse systems. The paper proposes an extension of the concept of an aggregation lattice to capture the distributed semantics. Moreover, we extend a greedy-based selection algorithm based on an adequate cost model for the distributed case. Within a performance study, we finally compare our findings with the approach of applying a selection algorithm locally to each node in a distributed warehouse environment.
- Andere Ausgabe
- Link zum Artikel, der zuerst in der IEEE Xplore Digital Library erschienen ist:
DOI: 10.1109/SSDM.2003.1214953 - Freie Schlagwörter (DE)
- Data Warehouse-Systeme, Raumfahrttechnik, Gitternetze, Datenbanken, Materiallagerung, Konferenz-Management, Technologie-Management, Zeitfaktoren, Kosten, Aggregate
- Freie Schlagwörter (EN)
- Data warehouses, Space technology, Lattices, Databases, Material storage, Conference management, Technology management, Time factors, Costs, Aggregates
- Klassifikation (DDC)
- 004
- Verlag
- IEEE, New York, NY
- Version / Begutachtungsstatus
- angenommene Version / Postprint / Autorenversion
- URN Qucosa
- urn:nbn:de:bsz:14-qucosa2-787813
- Veröffentlichungsdatum Qucosa
- 02.06.2022
- Dokumenttyp
- Konferenzbeitrag
- Sprache des Dokumentes
- Englisch
- Lizenz / Rechtehinweis