Fuzzy logic in database in time tuning - BTree Index creation

• Autorzy: Giersz J.
• Języki publikacji: EN

Abstrakty

EN

One of the most important features of a database, beside collecting and storing information, is its ability to extract and produce the required data within the quickest possible time. In many cases, during the modelling and design stage, the designers and analysts concentrate their efforts on the building the structure, leaving the data access time aside. The article presents a relational database time-based tuning system with the use of the fuzzy logic. Database in-time tuning is based mainly on database analysis (both on logical and physical level), SQL response time analysis and then creating more efficient indexes upon those analyses. The tuning is usually done by the people involved directly in applications needing efficiency improvement, i.e. the programmers, analysts or database administrators. The tuning is done based on data obtained from the system with the help of programs supplied along with the database management system. The experts, however, tend to use the expressions like 'huge amount of data', 'long response time', which strongly binds the optimisation with the knowledge, intuition and the expert's reality perception. Thus, it seems reasonable to apply the fuzzy logic to the in-time database structure tuning, in order to, for example, shorten the response time. The detailed information resulting from the database system analysis, together with the experts knowledge defined as sets and rules of fuzzy logic's concluding, thus closer to the natural language, can be a powerful tool in database tuning.

Słowa kluczowe

EN

BTREE Index; database tuning; fuzzy logic; fuzzification; inference

PL

logika rozmyta; dostrajanie bazy danych

• Wydawca: Instytut Telekomunikacji i Informatyki Uniwersytetu Technologiczno-Przyrodniczego w Bydgoszczy
• Czasopismo: Image Processing & Communications
• Rocznik: 2005
• Tom: Vol. 10, no 2
• Strony: 75--84
• Opis fizyczny: Bibliogr. 18 poz., rys., wykr.

Twórcy

autor

Giersz J.

• Faculty of Computer Science & Information Systems, Technical University of Szczecin, 49 Zolnierska St., 71-210 Szczecin, Poland,

Bibliografia

• [1] Anderson H, Bera P, "Minimum cost selection of secondary indexes for formatted data," ACM-TODS No. 2, 1997
• [2] Assilian S, "Artificial intelligence in the control of real dynamics systems," London University 1974
• [3] Babuska, R, Setnes M., Kaymak U. "Simplification of fuzzy rule bases," Proc. Int. Conf. EUFIT96, Aachen, Germany, vol. 2, Based on Logical Interpretation of If-then pp 1115-1119, 196
• [4] Batini C,, Ceri S. "Database Design: An Entity Relationship Approach," Beniamin/Cummings 1992
• [5] Ed Whalen, Mitchell Schroeter, "Oracle. Optymalizacja wydajnoci," Wydawnictwo Helion 2003
• [6] Elmasari E., Navathe S. B. "Fundamentals of Database Systems," 3rd ed. 2000 Benjamin/Cummings
• [7] Jacek Leski "A Fuzzy If-Then Rule-Based Nonlinear Classifier," Applied Mathematics and Computer Science 2003, vol. 13, No. 2
• [8] Janusz Charczuk, "Physical Structure Design for Relational Databases," ADBIS 1999
• [9] Jerzy Giersz, "Conception of relational database time-based tuning support system with the use of the fuzzy logic," ACS-CISIM 2005
• [10 ] Jerzy Giersz, "Effective extraction of the information from a database," ACS'2002, Szczecin, 2002
• [11] Jerzy Giersz, "Processing of the huge amount of data," ACS'2002, Szczecin, 2002
• [12 ] L. Bole, W. Borodziewicz, M. Wjcik, Podstawy przetwarzania informacji niepenej i niepewnej, PWN, 1991
• [13 ] Lech Banachowski, Krzysztof Stencel, Bazy danych. Projektowanie aplikacji w serwerze, Wydawnictwo EXIT 2003
• [14] Norbert Henzel A Neuro-Fuzzy System Based on Logical Interpretation of If-then Rules, Applied Mathematics and Computer Science, 2002, vol. 10, No. 4
• [15] O'Neil P. E., O'Neil E. Database: Principles, Programming and Performance, 2nd ed. 2001, Morgan, Kaufman
• [16] Piegat Andrzej, Modelowanie i sterowanie rozmyte, Akademicka Olicyna Wydawnicza EXIT, Warszawa 2003
• [17] Przemyslaw Grzegorzewski, Olgierd Hryniewicz, Computing With Words and Life Data, Applied Mathematics and Computer Science, 2002, vol. 12, No. 3
• [18] Rutkowska, M. Piliski, L. Rutkowski, Siecl neuronowe, algorytmy genetyczne i systemy rozmyte, PWN 1999