prikaz prve stranice dokumenta Postupci za obnavljanje baze podataka u sustavima visoke dostupnosti
No public access
scientific master's theses
Postupci za obnavljanje baze podataka u sustavima visoke dostupnosti
Zagreb: University of Zagreb, Faculty of Electrical Engineering and Computing, 2007. urn:nbn:hr:168:080219
Putniković, Branimir
University of Zagreb
Faculty of Electrical Engineering and Computing
Department of Telecommunications

Institutional repository: FER Repository

Cite this document

Putniković, B. (2007). Postupci za obnavljanje baze podataka u sustavima visoke dostupnosti (Scientific master's theses). Zagreb: University of Zagreb, Faculty of Electrical Engineering and Computing. Retrieved from https://urn.nsk.hr/urn:nbn:hr:168:080219

Putniković, Branimir. "Postupci za obnavljanje baze podataka u sustavima visoke dostupnosti." Scientific master's theses, University of Zagreb, Faculty of Electrical Engineering and Computing, 2007. https://urn.nsk.hr/urn:nbn:hr:168:080219

Putniković, Branimir. "Postupci za obnavljanje baze podataka u sustavima visoke dostupnosti." Scientific master's theses, University of Zagreb, Faculty of Electrical Engineering and Computing, 2007. https://urn.nsk.hr/urn:nbn:hr:168:080219

Putniković, B. (2007). 'Postupci za obnavljanje baze podataka u sustavima visoke dostupnosti', Scientific master's theses, University of Zagreb, Faculty of Electrical Engineering and Computing, accessed 23 November 2024, https://urn.nsk.hr/urn:nbn:hr:168:080219

Putniković B. Postupci za obnavljanje baze podataka u sustavima visoke dostupnosti [Scientific master's theses]. Zagreb: University of Zagreb, Faculty of Electrical Engineering and Computing; 2007 [cited 2024 November 23] Available at: https://urn.nsk.hr/urn:nbn:hr:168:080219

B. Putniković, "Postupci za obnavljanje baze podataka u sustavima visoke dostupnosti", Scientific master's theses, University of Zagreb, Faculty of Electrical Engineering and Computing, Zagreb, 2007. Available at: https://urn.nsk.hr/urn:nbn:hr:168:080219

Metadata
TitlePostupci za obnavljanje baze podataka u sustavima visoke dostupnosti
Title (english)Database Recovery Procedures in High Availability Systems
AuthorBranimir Putniković
MentorZoran Skočir (mentor)
Committee memberBoris Vrdoljak (član povjerenstva)
Committee memberZoran Skočir (član povjerenstva)
Committee memberMladen Varga (član povjerenstva)
GranterUniversity of Zagreb
Faculty of Electrical Engineering and Computing
(Department of Telecommunications)
Zagreb
Defense date and country2007-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
Keywords (english)
Languagecroatian
URN:NBNurn:nbn:hr:168:080219
Study programmeTitle: Postgraduate master programme in electrical engineering
Study programme type: university
Study level: postgraduate
Academic / professional title: Magistar znanosti elektrotehnike (Magistar znanosti elektrotehnike)
Type of resourceText
File originBorn digital
Access conditionsClosed access
Terms of useLicence In copyright icon
Created on2020-04-06 08:04:40