Assessment of impact of selected factors on the effectiveness of cost-based optimizer in database systems

• Autorzy: Pacholewicz, R.
• Języki publikacji: EN

Abstrakty

EN

The paper presents the results of experiments, which aim was to evaluate the influence of selected factors on the cost and time of the query in database systems. The cost and execution time are criteria of assessment of query plans by the cost-based optimizer of a database system. Essential for constructing queries and for the efficiency of cost-based optimizer are: indexing, aliasing, asymmetry of the data and the availability of statistics referring to the tables. Experiments confirmed that the appropriate way to implement a query, based on the use of indexation or aliasing, and on modification of query parameters with the systematic generation of statistical information about the data can significantly reduce the time to obtain query results, offload the processor and reduce the number of disk reads. The experiment was conducted using the real data in the database ORACLE.

Słowa kluczowe

EN

database; query efficiency; cost-based optimizer

• Czasopismo: Zeszyty Naukowe Akademii Morskiej w Gdyni
• Rocznik: 2014
• Tom: nr 84
• Strony: 92--105
• Opis fizyczny: Bibliogr. 6 poz., rys., tab.

Twórcy

autor

Pacholewicz, R.

• Department of Marine Electronics Gdynia Maritime University Poland

Bibliografia

• [1] Gurry M., Oracle SQL Tunning Pocket Reference, Wydawnictwo Helion, Gliwice 2002.
• [2] Zakrzewicz M., http://explainit.pl/blog/?paged=2 [online], [09.09.2014].
• [3] Cyran M., Lane P., Oracle Database Concepts, 10g Release 1 (10.1)[online], Oracle Press, December 2003, http://docs.oracle.com/cd/B12037_01/server.101/b10743.pdf [16.06.2014].
• [4] Ashdown L., Kyte T., Oracle Database Concepts, 11g Release 2 (11.2)[online], Oracle Press, September 2011, http://docs.oracle.com/cd/E29505_01/server.1111/e25789/ process.htm [16.06.2014].
• [5] http://pl.wikipedia.org/wiki/Indeks_%28bazy_danych%29 [online],[16.06.2014].
• [6] Muryjas P., Skublewska-Paszkowska M., Gutek D., Współczesne technologie informatyczne. Eksploatacja baz danych., Politechnika Lubelska [online], Lublin 2011, http://www.bc.pollub.pl/dlibra/docmetadata?id=675&from=&dirids=1&ver_id=&lp=1 &QI= [16.06.2014].