Postupci za obnavljanje baze podataka u sustavima visoke dostupnosti

scientific master's theses

• Title (english): Database Recovery Procedures in High Availability Systems
• Author: Branimir Putniković
• Mentor: Zoran Skočir (mentor)
• Committee member: Boris Vrdoljak (član povjerenstva)
• Committee member: Zoran Skočir (član povjerenstva)
• Committee member: Mladen Varga (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; (Department of Telecommunications); Zagreb
• Defense date and country: 2007-10-12, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Electrical Engineering; Telecommunications and Informatics
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Computing
• Universal decimal classification (UDC): 621.3 - Electrical engineering ; 004 - Computer science and technology. Computing. Data processing

Abstract

Ključni zahtjevi nad bazom podataka su zaštita korisničkih podataka i osiguravanje visoke dostupnosti u slučaju greške. Baza podataka dio je računalnog sustava koji je izgrađen od mnogo komponenata. Da bi se osigurala visoka dostupnost podataka gledajući od strane korisnika neophodno je osigurati visoku dostupnost sustava u cjelini. Kako bi se korisnički podaci zaštitili od gubitka uslijed greške potrebno je imati dobro provjeren i uvježban plan za izradu sigurnosnih kopija korisničkih podataka i provođenje postupka obnavljanja baze podataka. Ovaj rad opisuje postupke osiguravanja visoke dostupnosti baze podataka za slučaj pojavljivanja sklopovske greške te postupke sigurnosnog spremanja i obnavljanja baze podataka za slučaj programske greške. Opisan je i postupak obnavljanja cjelokupne baze podataka. Naglašena je velika važnost postojanja pričuvne lokacije za slučaj katastrofalnog događaja. Postupci sigurnosnog spremanja i obnavljanja baze podataka određeni su mogućnostima programske podrške korištenog SUBP-a. Analizirani su postupci osiguravanja visoke dostupnosti te obnavljanja Oracle, DB2 i SQL Server baza podataka kao tri danas najzastupljenije baze podataka na tržištu [40]. U sklopu ovog rada razvijen je programski paket DBA 2007 za DB2 bazu podataka na z/OS operacijskom sustavu koji se koristi za obavljanje i automatizaciju administratorskih poslova. Koristeći programski paket DBA 2007 obavljena je provjera opisanih postupaka obnavljanja DB2 baze podataka. Ugrađene su funkcije koje omogućuju kreiranje skripta za sigurnosno spremanje i obnavljanje podataka i objekata baze podataka te automatizaciju postupka migracije baze podataka.

Abstract (english)

Key demands on database management system are user data protection and high availability in case of an error. Database system is a part of a computer system built of many components. To ensure high availability of data looking from user’s point of view it is necessary to have a high availability of a whole system. It is essential to have well tested and drilled plan for database backup and a recovery process in order to protect user’s data in case of an error. This thesis describes procedures for ensuring database high availability in case of hardware error and procedures for database backup and recovery in case of software error. Complete database restore procedure is also described. It is emphasized that it is most important to have disaster recovery location in case of disastrous event. Database recovery procedures are determined with software features supplied with database management system. Procedures for achieving both high availability and database recovery are analyzed for Oracle, DB2 and SQL Server databases which are top three databases on the market [40]. Within this thesis program package DBA 2007 has been developed for database DB2 on z/OS operating system to perform and automate administration tasks. Using program package DBA 2007 verification has been made for described DB2 backup and recovery procedures. There are functions built in for creation of scripts for database backup and recovery and automation of database migration procedure.

• Keywords: relacijska baza podataka; visoka dostupnost; migracija baze podataka; sigurnosno spremanje baze podataka; obnavljanje baze podataka; mainframe arhitektura; administracija baze podataka; automatizacija postupka; okolina baze podataka
• Keywords (english): relational database; high availability; database migration; database backup; database recovery; mainframe architecture; database administration; procedure automation; database environment
• Language: croatian
• URN:NBN: urn:nbn:hr:168:080219
• Study programme: Title: Postgraduate master programme in electrical engineering; Study programme type: university; Study level: postgraduate; Academic / professional title: Magistar znanosti elektrotehnike (Magistar znanosti elektrotehnike)
• Type of resource: Text
• File origin: Born digital
• Access conditions: Closed access
• Created on: 2020-04-06 08:04:40