Access plan recommendation: A clustering based approach using queries similarity

Autor:	Abderrahim El Qadi, Salma Mouline, Jihad Zahir
Rok vydání:	2014
Předmět:	SQL Information retrieval Database Computer science InformationSystems_DATABASEMANAGEMENT computer.software_genre Query optimization Query plan Spatial query Similarity (network science) Query by Example Sargable Cluster analysis computer computer.programming_language
Zdroj:	2014 Second World Conference on Complex Systems (WCCS).
DOI:	10.1109/icocs.2014.7060936
Popis:	This work relates to SQL query plan reuse based optimization in Database Management Systems (DBMS). We use a collaborative recommendation approach that helps the DBMS optimizer to detect similarity between old queries (already executed by the optimizer) and new upcoming queries (that are yet to execute). This kind of methods, allows the optimizer to use the old access plans to execute future queries which reduces t he optimization cost. In our research, we benefit from clustering techniques to establish queries similarity. Hence, query plans are recommended to the optimizer using a log based recommendation approach.
Databáze:	OpenAIRE
Externí odkaz:	https://explore.openaire.eu/search/publication?articleId=doi_________::287ed2ab5c3d8d2e7423a2e642b21430 https://doi.org/10.1109/icocs.2014.7060936 Zobrazit plný text záznamu