Sustav za praćenje promjena podataka u Microsoft SQL Server bazi podataka

master's thesis

• Title (english): System for Tracking Data Changes in Microsoft SQL Server Database
• Author: Nejra Muslić
• Mentor: Boris Vrdoljak (mentor)
• Committee member: Boris Vrdoljak (predsjednik povjerenstva)
• Committee member: Gordan Gledec (član povjerenstva)
• Committee member: Slaven Zakošek (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2017-07-07, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Computing

Abstract

U ovom radu je analizirana izgradnja sustava za praćenje promjena Microsoft SQL
Server baze podataka kako bi se smanjilo nepotrebno opterećenje baze podataka s
upitima o promjenama. Sustav za praćenje promjena Microsoft SQL Server baze
podataka omogućuje automatsko dojavljivanje promjena podataka pretplaćenim
klijentima. Napravljena je relacijska baza podataka koristeći Microsoft SQL Server i
izgrađen je odgovarajući objektni model. Uspostavljen je Service Broker na bazi
podataka. Izgrađen je Windows servis za komunikaciju reda Service Brokera i
demonstracijske aplikacije. Izgrađen je WCF REST API za pretplaćivanje korisnika i
upravljanje pretplatama. Izgrađena je i Windows Forms demonstracijska aplikacija koja
prikazuje način rada sustava. Sustav je razvijen u tehnologijama ASP.NET, Windows
services, WCF, Windows forms, te Microsoft SQL Server i Service Broker.

Abstract (english)

Process of building a system for tracking changes on Microsoft SQL Server database is
analyzed in this thesis. This prevents unnecessary database load.
System for tracking changes on Microsoft SQL Server database enables automatic
notifying to subscribed clients. Database is developed in Microsoft SQL Server with
proper object model. Service Broker is enabled on database. Windows service is built
for communication between Service Broker queue and demo application. WCF REST
API is built for subscription management. Demo application is built using Windows
Forms. System was developed in the following technologies: ASP.NET, Windows
services, WCF, Windows forms, Microsoft SQL Server and Service Broker.

• Keywords: sustav za praćenje promjena podataka; service broker; asp.net; Microsoft SQL Server
• Keywords (english): change tracking system; service broker; asp.net; Microsoft SQL Server
• Language: croatian
• URN:NBN: urn:nbn:hr:168:111683
• Study programme: Title: Computing; Study programme type: university; Study level: graduate; Academic / professional title: magistar/magistra inženjer/inženjerka računarstva (magistar/magistra inženjer/inženjerka računarstva)
• Type of resource: Text
• File origin: Born digital
• Access conditions: Closed access
• Created on: 2019-03-13 23:19:31