Ma’lumotlar bazalarida indekslashning afzalliklari va kamchiliklari
Keywords:
ma’lumotlar bazasi, indeks, dasturiy ta’minot, saralash, samaradorlikAbstract
Indekslash ma’lumotlar bazasi ish faoliyatini optimallashtirish uchun kuchli vositadir. Indekslardan to‘g‘ri foydalanish so‘rovlarning bajarilishini sezilarli darajada tezlashtirishi va tizimning umumiy samaradorligini oshirishi mumkin.
References
Джеймс Грофф, Пол Вайнберг, Эндрю Опель. “SQL Полное руководство” Третье издание. Издательский дом "Вильяме" Москва, Санкт-Петербург, Киев 2015.
Aiken A., Hellerstein J.M., and Widom J. Static Analysis Techniques for Predicting the Behavior of Active Database Rules // ACM TODS. — March 1995. — 20, № 1.
Baralis E. and Widom J. An Algebraic Approach to Static Analysis of Active Database Rules // ACM TODS. — September 2000. — 25, № 3.
Bernstein P.A., Blaustein B.T., Clarke E.M. Fast Maintenance of Semantic Integrity Assertions Using Redundant Aggregate Data // Proc. 6th Intern. Conf. on Very Large Data Bases. — Montreal, Canada. — October 1980.
