Database optimization for improvement of existing systems

• Autorzy: Wosiak A. , Koper R.
• Języki publikacji: EN

Abstrakty

EN

Due to the increasing volume of data, which is the result of market globalization and the computer development of the largest commercial enterprises, performance problems at the database level in existing systems become common and are a top priority. In this research database optimization methods were presented, taking into account the constraints deriving from the existing system architecture. Both technical and business constraints were considered. The increase in efficiency in each case was assessed by the time required to perform a particular database operation. The numbers of disk reads and buffer gets, as the technical factors of efficiency growth, were determined when possible.

Słowa kluczowe

EN

database optimization; database performance; Oracle Database

PL

optymalizacja baz danych; wydajność baz danych; Oracle Database

• Wydawca: Wydawnictwo Politechniki Łódzkiej
• Czasopismo: Journal of Applied Computer Science
• Rocznik: 2015
• Tom: Vol. 23, nr 2
• Strony: 101--118
• Opis fizyczny: Bibliogr. 12 poz.

Twórcy

autor

Wosiak A.

• Institute of Information Technology, Lodz University of Technology, Wólczańska 215, 90-924 Łódź

autor

Koper R.

• Institute of Information Technology, Lodz University of Technology, Wólczańska 215, 90-924 Łódź

Bibliografia

• [1] Duraj, A., Korzeniewska, E., and Krawczyk, A., Classification algorithms to identify changes in resistance, Przegląd Elektrotechniczny, Vol. 91, No. 12, 2015, pp. 80–82.
• [2] Drzymała, P. and Welfle, H., DB2 pureXML - advanced of data storage in the relational - hierarchical structures, Przegląd Elektrotechniczny, Vol. 90, No. 3, 2014, pp. 165–168.
• [3] Powell, G., Oracle Performance Tuning for 10gR2, Elsevier Inc., 2007.
• [4] Niemiec, R., Oracle Database 11g Release 2 Performance Tuning Tips and Techniques, McGraw-Hill Osborne Media, 2012.
• [5] Koper, R., Analysis of the database optimization methods in the context of existing systems, Master’s thesis, Lodz University of Technology, 2015, (in Polish).
• [6] Alapati, S. and Kuhn, D., Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach, Apress, 2011.
• [7] Alapati, S. and Kuhn, D., Expert Indexing in Oracle Database 11g: Maximum Performance for your Database, Apress, 2012.
• [8] Bulusu, L., Oracle PL/SQL: Expert Techniques For Developers and Database Administrators, Course Technology PTR, 2008.
• [9] Harper, J. and McLaughlin, M., Oracle Database 11g PL/SQL Programming Workbook, McGraw-Hill Osborne Media, 2010.
• [10] Feuerstein, S., Oracle Database 11g PL/SQL Programming Workbook, O’Reilly Media, 2007.
• [11] Loney, K., Oracle Database 11g The Complete Reference, McGraw-Hill Osborne Media, 2009.
• [12] Antognini, C., Troubleshooting Oracle Performance, Apress, 2014.