Programski okvir za prikupljanje podataka o promjenama podataka u heterogenim distribuiranim relacijskim sustavima za upravljanje bazama podataka

master's thesis

• Title (english): A Framework for Change Data Capture in Heterogeneous Distributed Relational Database Management Systems
• Author: Dorijan Grgić
• Mentor: Slaven Zakošek (mentor)
• Committee member: Slaven Zakošek (predsjednik povjerenstva)
• Committee member: Mirta Baranović (član povjerenstva)
• Committee member: Ljiljana Brkić (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2021-07-06, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Computing

Abstract

Ovim diplomskim radom prikazana je implementacija programskog okvira za prikupljanje podataka o promjenama podataka u heterogenim distribuiranim sustavima za upravljanje bazama podataka. Korišteni sustavi su PostgreSQL, MySQL i Microsoft SQLServer. Korišteni programski jezik za implementaciju programskog okvira je C#, a korišteni programski okvir je .NET Standard koji zapravo nije programski okvir već standard za izradu tzv. class library projekata, ali se koristi kao programski okvir. Rad opisuje CDC funkcionalnost, primjene CDC funkcionalnosti, implementacije CDC funkcionalnosti u korištenim SUBP-ovima te opis implementiranog programskog okvira uz upute za instalaciju i konfiguraciju. Prikazana je arhitektura cjelokupnog sustava, dijagram razreda programskog okvira i opisani su funkcionalni i nefunkcionalni zahtjevi.

Abstract (english)

This master thesis describes an implementation of a programming framework used for gathering data of changed data inside heterogeneous distributed relational database systems. Used database systems are PostgreSQL, MySQL, and Microsoft SQLServer. Used programming language for implementing programming framework is C# and used programming framework is .NET Standard which is not a real programming framework but a defined standard for developing class library projects and is used as a programming framework. Thesis contains description of CDC functionality, usage of CDC functionality, implementation of CDC functionality in used database systems, and implemented programming framework with instructions for installation and configuration. Thesis also shows architecture of an overall system, class diagram of a programming framework and functional and nonfunctional requirements.

• Keywords: CDC; Funkcionalnost praćenja promjena podataka; ETL; Proces ekstrakcije; transformacije i skladištenja; MySQL; PostgreSQL; SQLServer
• Keywords (english): CDC; Change Data Capture; ETL; Extract Transform and Load; MySQL; PostgreSQL; SQLServer
• Language: croatian
• URN:NBN: urn:nbn:hr:168:670816
• 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: 2023-01-13 15:00:28