Implementacija operacije temporalnog spajanja u relacijskom sustavu baza podataka

master's thesis

• Title (english): Implementation of Temporal Join to the Relational Database System
• Author: Anett Balazsics
• Mentor: Ljiljana Brkić (mentor)
• Committee member: Ljiljana Brkić (predsjednik povjerenstva)
• Committee member: Damir Kalpić (član povjerenstva)
• Committee member: Krešimir Fertalj (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2017-07-17, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Computing

Abstract

Vremenske baze podataka (eng. temporal databases) omogućuju pohranu informacija vezano uz prošlost, sadašnjost i budućnost za razliku od uobičajenih baza podataka koje sadrže vrijednosti koje su istinite u trenutnom vremenu. U ovom radu detaljno se opisuju osnovni vremenski koncepti te različiti relacijski sustavi (PostgreSQL, Oracle Database i Microsoft SQL Server.) koji u određenoj mjeri podupiru vremenske značajke propisane standardnom SQL:2011. Dodatno, detaljno su opisane operacije različitih temporalnih spajanja i potrebne izmjene relacijskog sustava PostgreSQL kako bi podupirao temporalno spajanje relacija.

Abstract (english)

Temporal databases offer the ability to store past, present and future-related information in contrast to current databases which store facts that contain values that are true at the current time. This thesis describes basic temporal concepts, various temporal join operations and relational database management systems (PostgreSQL, Oracle Database and Microsoft SQL Server) which support temporal features differently based on the standard SQL:2011. In addition, the necessary changes in order to support temporal joining operations in PostgreSQL are also described.

• Keywords: temporalno spajanje; vremenska baza podataka; relacijski sustav baza podataka; PostgreSQL
• Keywords (english): temporal join; temporal database; relational database system; PostgreSQL
• Language: croatian
• URN:NBN: urn:nbn:hr:168:514508
• 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 18:47:30