| | SLO | ENG | Cookies and privacy

Bigger font | Smaller font

Show document Help

Title:UPRAVLJANJE S SOČASNOSTJO V RELACIJSKIH PODATKOVNIH BAZAH
Authors:ID Ogner, Marcel (Author)
ID Dogša, Tomaž (Mentor) More about this mentor... New window
ID Brumen, Boštjan (Comentor)
Files:.pdf UN_Ogner_Marcel_2016.pdf (1,39 MB)
MD5: 5C06C8EC75397ABB67869D736A99F7FB
 
Language:Slovenian
Work type:Undergraduate thesis
Typology:2.11 - Undergraduate Thesis
Organization:FERI - Faculty of Electrical Engineering and Computer Science
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
Place of publishing:[Maribor
Publisher:M. Ogner
Year of publishing:2016
PID:20.500.12556/DKUM-59930 New window
UDC:004.685.6(043.2)
COBISS.SI-ID:19917078 New window
NUK URN:URN:SI:UM:DK:UQNZ4WZV
Publication date in DKUM:22.09.2016
Views:1300
Downloads:112
Metadata:XML RDF-CHPDL DC-XML DC-RDF
Categories:KTFMB - FERI
:
Copy citation
  
Average score:(0 votes)
Your score:Voting is allowed only for logged in users.
Share:Bookmark and Share


Hover the mouse pointer over a document title to show the abstract or click on the title to get all document metadata.

Secondary language

Language:English
Title:CONCURRENCY CONTROL IN RELATIONAL DATABASES
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.
Keywords:concurrency control, transaction isolation level, blocking, locking


Comments

Leave comment

You must log in to leave a comment.

Comments (0)
0 - 0 / 0
 
There are no comments!

Back
Logos of partners University of Maribor University of Ljubljana University of Primorska University of Nova Gorica