Título: | AUTOMATIC REINDEXING IN RELATIONAL DATABASES | ||||||||||||||||||||||||||||||||||||
Autor: |
EDUARDO MARIA TERRA MORELLI |
||||||||||||||||||||||||||||||||||||
Colaborador(es): |
SERGIO LIFSCHITZ - Orientador |
||||||||||||||||||||||||||||||||||||
Catalogação: | 15/FEV/2007 | 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=9531&idi=1 [en] https://www.maxwell.vrac.puc-rio.br/projetosEspeciais/ETDs/consultas/conteudo.php?strSecao=resultado&nrSeq=9531&idi=2 |
||||||||||||||||||||||||||||||||||||
DOI: | https://doi.org/10.17771/PUCRio.acad.9531 | ||||||||||||||||||||||||||||||||||||
Resumo: | |||||||||||||||||||||||||||||||||||||
One of the most important tasks of Database Administrators
certainly is to
guarantee optimal response times to statements submitted
by users of big
RDBMS. Our dissertation deals with Index Self-tuning,
which means creating,
dropping or recreating indexes automatically, in order to
decrease SQL queries
durations. We start from Marcos Salles´ dissertation [32],
which proposed an
automatic way of creating indexes. We extend [32] in many
ways: first using a
different workload, TPC-H like. Second, following created
indexes inspecting its
usage. Finally, we have gotten to drop and, mostly,
recreate indexes using
different fillfactor in leaf pages. Also, we have
elaborated many tests using
commercial tools, Microsoft SQL Server 2005 and Oracle 10g
in order to ratify
[32] ideas. Unfortunatelly, we could not test automatic
dropping and recreating in
these tools, as long as they do not offer this kind of
functionalities. Unlike related
work and commercial tools, we have created a code
prototype that not only
suggests new indexes creations, but also drops and
recreates indexes using an own
heuristics. To validate our ideas we have used a TPC-C
like workload, but we had
to make some changes to increase updates and force
reindexing.
|
|||||||||||||||||||||||||||||||||||||
|