prikaz prve stranice dokumenta Replikacija baze podataka u sustavu SQL Server
Access restricted to students and staff of home institution
undergraduate thesis
Replikacija baze podataka u sustavu SQL Server
Rijeka: University of Rijeka, Faculty of Engineering, 2021. urn:nbn:hr:190:980151
Antunović, Viktor
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

Antunović, V. (2021). Replikacija baze podataka u sustavu SQL Server (Undergraduate thesis). Rijeka: University of Rijeka, Faculty of Engineering. Retrieved from https://urn.nsk.hr/urn:nbn:hr:190:980151

Antunović, Viktor. "Replikacija baze podataka u sustavu SQL Server." Undergraduate thesis, University of Rijeka, Faculty of Engineering, 2021. https://urn.nsk.hr/urn:nbn:hr:190:980151

Antunović, Viktor. "Replikacija baze podataka u sustavu SQL Server." Undergraduate thesis, University of Rijeka, Faculty of Engineering, 2021. https://urn.nsk.hr/urn:nbn:hr:190:980151

Antunović, V. (2021). 'Replikacija baze podataka u sustavu SQL Server', Undergraduate thesis, University of Rijeka, Faculty of Engineering, accessed 02 May 2024, https://urn.nsk.hr/urn:nbn:hr:190:980151

Antunović V. Replikacija baze podataka u sustavu SQL Server [Undergraduate thesis]. Rijeka: University of Rijeka, Faculty of Engineering; 2021 [cited 2024 May 02] Available at: https://urn.nsk.hr/urn:nbn:hr:190:980151

V. Antunović, "Replikacija baze podataka u sustavu SQL Server", Undergraduate thesis, University of Rijeka, Faculty of Engineering, Rijeka, 2021. Available at: https://urn.nsk.hr/urn:nbn:hr:190:980151

Metadata
TitleReplikacija baze podataka u sustavu SQL Server
Title (english)Database Replication in SQL Server
AuthorViktor Antunović
MentorSandi Ljubić (mentor)
Committee memberKristijan Lenac (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 country2021-09-14, Croatia
Scientific / art field,
discipline and subdiscipline		TECHNICAL SCIENCES
Computing
Abstract
U kontekstu sustava za upravljanje bazama podataka, replikacija predstavlja proces kopiranja i distribucije podataka iz jedne baze u drugu, a zatim i sinkronizaciju između baza podataka radi održavanja konzistentnosti i integriteta podataka. U radu su istražene i predstavljene različite tehnike replikacije, s različitim pristupima problemu sinkronizacije, koje su omogućene u sustavu MS SQL Server. Konkretno, opisane su najvažnije značajke replikacije snimkom, replikacije spajanjem i transakcijske replikacije. S ciljem demonstracije učinaka P2P transakcijske replikacije, u radu je implementirano i testirano ogledno rješenje koje emulira uslugu kritičnog sustava. Sustav obuhvaća dva poslužitelja s konfiguriranom replikacijom baze podataka i eksternu aplikaciju koja generira i šalje podatke u obje baze, te omogućava nadgledanje podataka u bazama oba poslužitelja. U tako realiziranom sustavu provedena je analiza utjecaja veličine podataka i frekvencije unosa podataka na učinak replikacijskog mehanizma. Pokazano je kako oba faktora na odgovarajući način utječu na brzinu replikacije, pri čemu, očekivano, veličina podataka predstavlja faktor sa značajnijim utjecajem.
Abstract (english)
In the context of a database management system, replication is the process of copying and distributing data from one database to another, and synchronizing between databases in order to maintain data consistency and integrity. This thesis investigates and presents different replication techniques, with different approaches to the synchronization problem, which are enabled in MS SQL Server. Namely, the most important features of snapshot replication, merge replication, and transactional replication are described. In order to demonstrate the effects of P2P transactional replication, an example solution that emulates a critical system service was implemented and tested. The system includes two servers with configured database replication and an external application that generates and sends data to both databases, and allows data live monitoring. In such a system, an analysis of the effects of data size and data insertion frequency on the replication mechanism was performed. Both factors have been shown to adequately affect the speed of replication, with, as expected, data size representing a factor with a more significant impact.
Keywords
Keywords (english)
Languagecroatian
URN:NBNurn:nbn:hr:190:980151
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-13 10:00:28