Održavanje baze podataka

master's thesis

• Author: Milka Miličević
• Mentor: Robert Manger (mentor)
• Committee member: Robert Manger (predsjednik povjerenstva)
• Committee member: Mladen Jurak (član povjerenstva)
• Committee member: Matija Kazalicki (član povjerenstva)
• Committee member: Nikola Sandrić (član povjerenstva)
• Granter: University of Zagreb; Faculty of Science; (Department of Mathematics); Zagreb
• Defense date and country: 2019-09-25, Croatia
• Scientific / art field, discipline and subdiscipline: NATURAL SCIENCES; Mathematics

Abstract

Tema ovog diplomskog rada je održavanje baze podataka. Diplomski rad je podijeljen u tri poglavlja. U prvom poglavlju su opisani poslovi koje obavlja administrator baze podataka, a to su: oblikovanje baze podataka, praćenje i podešavanje performansi, osiguravanje dostupnosti baze korisnicima, čuvanje sigurnosti podataka, stvaranje rezervnih kopija baze podataka, oporavak baze u slučaju njezinog oštećenja i osiguravanje integriteta podataka. U drugom poglavlju se daje pregled kategorija i vrsta proizvoda dostupnih DBA-u kao pomoć u upravljanju i održavanju baza podataka. U trećem poglavlju je prikazan studijski primjer baze podataka, koji se sastoji od izrada baze podataka i njezinih objekata. Prikazani su načini na koji se baza organizira, te kako se održava i nadzire baza podataka. Također je prikazano kako se osigurava sigurnost. Za izradu praktičnog rada koristili smo Visual Paradigm i Microsoft SQL Server.

Abstract (english)

The theme of this thesis is database administration. The thesis is divided into three chapters. The first chapter describes the tasks that the database administrator performs, and those are: database design, monitoring and tuning of performance, ensuring database availability to users, maintaining security, backing up the database, recovering the database in the event of damage, and ensuring data integrity. Chapter two provides an overview of the categories and types of products available to the DBA to help manage and maintain databases. Chapter three presents a case study of a database, which consists of creating a database and its objects. The ways are presented in which the database is organized and how the database is maintained and monitored. Database security is also shown. We used Visual Paradigm and Microsoft SQL Server to create the practical work.

• Keywords: održavanje baza podataka; Visual Paradigm; Microsoft SQL Server
• Keywords (english): database administration; Visual Paradigm; Microsoft SQL Server
• Language: croatian
• URN:NBN: urn:nbn:hr:217:289964
• Study programme: Title: Computer Science and Mathematics; Study programme type: university; Study level: graduate; Academic / professional title: magistar/magistra računarstva i matematike (magistar/magistra računarstva i matematike)
• Type of resource: Text
• File origin: Born digital
• Access conditions: Open access
• Created on: 2020-02-11 13:44:58