prikaz prve stranice dokumenta Analiza učinkovitosti upita u bazi podataka i dojavljivanje obavijesti eksternim aplikacijama
Access restricted to students and staff of home institution
undergraduate thesis
Analiza učinkovitosti upita u bazi podataka i dojavljivanje obavijesti eksternim aplikacijama
Rijeka: University of Rijeka, Faculty of Engineering, 2020. urn:nbn:hr:190:604500
Krapić, Karlo
University of Rijeka
Faculty of Engineering
Department of Computer Engineering
Section of Software Engineering

Institutional repository: Repository of the University of Rijeka, Faculty of Engineering

Cite this document

Krapić, K. (2020). Analiza učinkovitosti upita u bazi podataka i dojavljivanje obavijesti eksternim aplikacijama (Undergraduate thesis). Rijeka: University of Rijeka, Faculty of Engineering. Retrieved from https://urn.nsk.hr/urn:nbn:hr:190:604500

Krapić, Karlo. "Analiza učinkovitosti upita u bazi podataka i dojavljivanje obavijesti eksternim aplikacijama." Undergraduate thesis, University of Rijeka, Faculty of Engineering, 2020. https://urn.nsk.hr/urn:nbn:hr:190:604500

Krapić, Karlo. "Analiza učinkovitosti upita u bazi podataka i dojavljivanje obavijesti eksternim aplikacijama." Undergraduate thesis, University of Rijeka, Faculty of Engineering, 2020. https://urn.nsk.hr/urn:nbn:hr:190:604500

Krapić, K. (2020). 'Analiza učinkovitosti upita u bazi podataka i dojavljivanje obavijesti eksternim aplikacijama', Undergraduate thesis, University of Rijeka, Faculty of Engineering, accessed 06 November 2024, https://urn.nsk.hr/urn:nbn:hr:190:604500

Krapić K. Analiza učinkovitosti upita u bazi podataka i dojavljivanje obavijesti eksternim aplikacijama [Undergraduate thesis]. Rijeka: University of Rijeka, Faculty of Engineering; 2020 [cited 2024 November 06] Available at: https://urn.nsk.hr/urn:nbn:hr:190:604500

K. Krapić, "Analiza učinkovitosti upita u bazi podataka i dojavljivanje obavijesti eksternim aplikacijama", Undergraduate thesis, University of Rijeka, Faculty of Engineering, Rijeka, 2020. Available at: https://urn.nsk.hr/urn:nbn:hr:190:604500

Metadata
TitleAnaliza učinkovitosti upita u bazi podataka i dojavljivanje obavijesti eksternim aplikacijama
Title (english)Database Query Performance Analysis and Notification Delivery to External Applications
AuthorKarlo Krapić
MentorSandi Ljubić (mentor)
Committee memberKristian Lenić (predsjednik povjerenstva)
Committee memberSandi Ljubić (član povjerenstva)
GranterUniversity of Rijeka
Faculty of Engineering
(Department of Computer Engineering)
(Section of Software Engineering)
Rijeka
Defense date and country2020-09-16, Croatia
Scientific / art field,
discipline and subdiscipline		TECHNICAL SCIENCES
Computing
Abstract
U ovom je radu s nekoliko različitih aspekata analiziran problem učinkovitosti baze podataka. Opisan je i testiran cjelokupni proces optimizacije u sustavu SQL Server, od detekcije neučinkovitih upita do unaprjeđenja u potrošnji resursa. Također, obrađena je problematika učinkovitosti komunikacije između web stranice i baze podataka. U radu je modelirana i implementirana ogledna baza podataka koja služi za demonstraciju optimizacije upita i alata koje poslužitelj nudi za uspješno obavljanje tog procesa. Opisan je rad ugrađenog optimizatora, a detaljnije su razrađeni pojmovi statistike, planova izvršavanja te procjene cijene koji se koriste u procesu odabira najučinkovitijih operacija. Kroz nekoliko primjera opisano je korištenje sustava Extended Events (EE) za praćenje događaja na poslužitelju te alata Database Tuning Advisor (DTA) za automatizirano pronalaženje mogućih poboljšanja. S aspekta komunikacije web stranice i potporne baze podataka, prikazana su i međusobno uspoređena dva pristupa – Query Notification i Polling. Usporedba navedenih pristupa zasniva se na detekciji prednosti i mana, pri čemu se relevantne metrike prate u različitim scenarijima opterećenja baze podataka.
Abstract (english)
In this thesis, the problem of database efficiency is analyzed from several different aspects. The entire optimization process within SQL Server is described and tested, from the detection of inefficient queries to improvements in resource consumption. Furthermore, the communication efficiency between the website and the database was addressed as well. A sample database was both modeled and implemented, in order to demonstrate query optimization and the server tools that support the corresponding process. The operation of the built-in optimizer is described, and the concepts of statistics, execution plans and cost estimations, being used for selecting the most efficient operations, are elaborated in more detail. Several examples are provided, which describe the utilization of Extended Events (EE) – for monitoring server events, and Database Tuning Advisor (DTA) – for finding possible improvements automatically. From the aspect of communication between the website and the underlying database, two approaches are presented and comparatively analyzed – Query Notification and Polling. The comparison of the mentioned methods is based on the detection of both advantages and disadvantages, wherein the relevant metrics are monitored in different database load scenarios.
Keywords
Keywords (english)
Languagecroatian
URN:NBNurn:nbn:hr:190:604500
Study programmeTitle: Computer Engineering
Study programme type: university
Study level: undergraduate
Academic / professional title: sveučilišni/a prvostupnik/ prvostupnica (baccalaureus/baccalaurea) inženjer/inženjerka računarstva (sveučilišni/a prvostupnik/ prvostupnica (baccalaureus/baccalaurea) inženjer/inženjerka računarstva)
Type of resourceText
File originBorn digital
Access conditionsAccess restricted to students and staff of home institution
Terms of useLicence In copyright icon
Created on2021-10-01 07:42:56