diplomsko delo
Marcel Ogner (Author), Tomaž Dogša (Mentor), Boštjan Brumen (Co-mentor)

Abstract

Kljub novejšim pristopom hranjenja podatkov v podatkovnih bazah so tradicionalne relacijske baze še vedno prva izbira pri bazno podprtih aplikacijah, kjer je konsistentnost podatkov na prvem mestu. Relacijske podatkovne baze zagotavljajo izolacijo transakcij z zaklepanjem podatkov. Ob povečanem obsegu podatkov v bazi in procesiranju velikega števila sočasnih transakcij na časovno enoto lahko zaklepanje privede do zmogljivostnih problemov zaradi blokiranja transakcij, ki sočasno dostopajo do deljenih virov. V diplomski nalogi so obravnavani vzroki, zakaj lahko do tega prihaja. Opisane so različne tehnike, kako hitro zaznati in kako preprečevati takšne dogodke. Opisana je rešitev, ki v verigi blokiranih transakcij identificira transakcijo, ki je najverjetnejši vzrok zmogljivostnih težav, in hkrati omogoča stalen nadzor in alarmiranje v primeru daljših blokiranj transakcij.

Keywords

upravljanje s sočasnostjo;izolacijske stopnje transakcij;blokiranje;zaklepanje baze;diplomske naloge;

Data

Language: Slovenian
Year of publishing:
Typology: 2.11 - Undergraduate Thesis
Organization: UM FERI - Faculty of Electrical Engineering and Computer Science
Publisher: M. Ogner
UDC: 004.685.6(043.2)
COBISS: 19917078 Link will open in a new window
Views: 773
Downloads: 82
Average score: 0 (0 votes)
Metadata: JSON JSON-RDF JSON-LD TURTLE N-TRIPLES XML RDFA MICRODATA DC-XML DC-RDF RDF

Other data

Secondary language: English
Secondary title: CONCURRENCY CONTROL IN RELATIONAL DATABASES
Secondary abstract: Despite the new coming technologies for data storage in databases, conventional relational database are still the first choice for database supported applications where consistency of data is a main concern. Relational databases provide transaction isolation by locking data. With the increased volume of data in database and processing a large number of concurrent transactions per unit of time can lead to performance problems due to blocking transactions which concurrently access shared resources. The thesis discusses the causes why this may happen. Described are a variety of techniques to efficiently detect and to prevent such events. We describe a solution which identifies blocking lead transaction in a blocking chain, which is the most likely root cause of performance problems while enabling constant monitoring and alerting in case of long lasting blocking transactions.
Secondary keywords: concurrency control;transaction isolation level;blocking;locking;
URN: URN:SI:UM:
Type (COBISS): Undergraduate thesis
Thesis comment: Univ. v Mariboru, Fak. za elektrotehniko, računalništvo in informatiko, Elektrotehnika
Pages: IV, 65 str.
ID: 9148401
Recommended works:
, diplomsko delo
, no subtitle data available
, diplomska naloga univerzitetnega študijskega programa
, diplomska naloga visokošolskega strokovnega študijskega programa
, no subtitle data available