A solution to the materialized view selection problem in data warehousing
One of the most important decisions in the physical designing of a data warehouse is the selection of materialized views and indexes to be created. The problem is to select an appropriate set of views and indexes to storage that minimizes the total query response time, as long as the cost of maintai...
Guardado en:
| Autores principales: | , |
|---|---|
| Formato: | Objeto de conferencia |
| Lenguaje: | Inglés |
| Publicado: |
2014
|
| Materias: | |
| Acceso en línea: | http://sedici.unlp.edu.ar/handle/10915/42286 |
| Aporte de: |
| id |
I19-R120-10915-42286 |
|---|---|
| record_format |
dspace |
| institution |
Universidad Nacional de La Plata |
| institution_str |
I-19 |
| repository_str |
R-120 |
| collection |
SEDICI (UNLP) |
| language |
Inglés |
| topic |
Ciencias Informáticas views view selection data warehouse indexes materialization |
| spellingShingle |
Ciencias Informáticas views view selection data warehouse indexes materialization Tamiozzo, Ayelén S. Ale, Juan María A solution to the materialized view selection problem in data warehousing |
| topic_facet |
Ciencias Informáticas views view selection data warehouse indexes materialization |
| description |
One of the most important decisions in the physical designing of a data warehouse is the selection of materialized views and indexes to be created. The problem is to select an appropriate set of views and indexes to storage that minimizes the total query response time, as long as the cost of maintaining them, given a constraint of some resource like storage space, is kept as low as possible.In this work, we have developed a new algorithm for the general problem of se-lection of views considering indexes, as an extension to a well-known algorithm.
We present a heuristic for selection of views and indexes to optimize total que-ry response under a materialization time constraint. Finally, we present an ex-perimental comparison of our proposal with the considered state-of-art ap-proach. |
| format |
Objeto de conferencia Objeto de conferencia |
| author |
Tamiozzo, Ayelén S. Ale, Juan María |
| author_facet |
Tamiozzo, Ayelén S. Ale, Juan María |
| author_sort |
Tamiozzo, Ayelén S. |
| title |
A solution to the materialized view selection problem in data warehousing |
| title_short |
A solution to the materialized view selection problem in data warehousing |
| title_full |
A solution to the materialized view selection problem in data warehousing |
| title_fullStr |
A solution to the materialized view selection problem in data warehousing |
| title_full_unstemmed |
A solution to the materialized view selection problem in data warehousing |
| title_sort |
solution to the materialized view selection problem in data warehousing |
| publishDate |
2014 |
| url |
http://sedici.unlp.edu.ar/handle/10915/42286 |
| work_keys_str_mv |
AT tamiozzoayelens asolutiontothematerializedviewselectionproblemindatawarehousing AT alejuanmaria asolutiontothematerializedviewselectionproblemindatawarehousing AT tamiozzoayelens solutiontothematerializedviewselectionproblemindatawarehousing AT alejuanmaria solutiontothematerializedviewselectionproblemindatawarehousing |
| bdutipo_str |
Repositorios |
| _version_ |
1764820473522159618 |