Título: | A NON-INTRUSIVE APPROACH FOR AUTOMATED PHYSICAL DESIGN TUNING | |||||||
Autor: |
JOSÉ MARIA DA SILVA MONTEIRO FILHO |
|||||||
Colaborador(es): |
SERGIO LIFSCHITZ - Orientador |
|||||||
Catalogação: | 14/JAN/2009 | Língua(s): | PORTUGUESE - BRAZIL |
|||||
Tipo: | TEXT | Subtipo: | THESIS | |||||
Notas: |
[pt] Todos os dados constantes dos documentos são de inteira responsabilidade de seus autores. Os dados utilizados nas descrições dos documentos estão em conformidade com os sistemas da administração da PUC-Rio. [en] All data contained in the documents are the sole responsibility of the authors. The data used in the descriptions of the documents are in conformity with the systems of the administration of PUC-Rio. |
|||||||
Referência(s): |
[pt] https://www.maxwell.vrac.puc-rio.br/projetosEspeciais/ETDs/consultas/conteudo.php?strSecao=resultado&nrSeq=12965&idi=1 [en] https://www.maxwell.vrac.puc-rio.br/projetosEspeciais/ETDs/consultas/conteudo.php?strSecao=resultado&nrSeq=12965&idi=2 |
|||||||
DOI: | https://doi.org/10.17771/PUCRio.acad.12965 | |||||||
Resumo: | ||||||||
The physical design of a database plays a critical role in
performance.
There has been considerable work on automated physical
design tuning for
database systems. Existing solutions require offline
invocations of the tuning
tool and depend on DBAs identifying representative workloads
manually.
However, in dynamic environments involving various ad-hoc
queries it is
difficult to identify potentially useful physical design in
advance. Recently,
a few initiatives present brief descriptions of prototypes
that address some
aspects of online physical tuning. Nevertheless, these
references work in an
intrusive manner and work only with a specific DBMS. In this
work, we propose
a non intrusive approach to automated and on-the-fly
physical design
problems, in order to speed up processing of subsequent
queries. Specifically,
we design algorithms that are always-on and continuously
modify the current
physical design, reacting to changes in the query workload.
To prove
the viability of the presented ideas, the proposed approach
was instantiated
to solve two major problems related to the database physical
design:
indexing and alternative data clusters automatic maintenance.
|
||||||||