EVALUATION MODEL OF ORACLE DATABASE MIGRATION

Pri diplomski nalogi smo raziskali prednosti in slabosti migracije iz podatkovne baze Oracle na podatkovno bazo PostgreSQL ponudnika Enterprise DB, ki zastopa delno odprtokodno rešitev. Za primerjavo smo uporabili še varianto popolno odprtokodne baze podatkov PostgreSQL. Osredotočili smo se na vpliv svetovne gospodarske krize na IT področju in v sklopu teh okoliščin na nove priložnosti ponudnikov cenejših storitev. Pomagali smo si s primerom (case study). Podali smo tudi finančni izračun stroškov migracije. Analizo prednosti in slabosti smo naredili v programu Dexi, kjer smo določili in opisali strukturo kriterijev. Analizo kaj-če smo izvedli najprej v programu Dexi, kasneje pa rezultate grafično prikazali še v Vredani. Končni rezultat naloge je grafično vrednotenje in analiza rezultatov.This paper introduces advantages and disadvantages of Oracle database migration to partly open source soultion that uses PostgreSQL from Enterprise DB. I added the third solution for the comparison, and that is totaly open source database – PosrgreSQL. I have focused on the influence of the world economical crises on the IT area and on the resulting new opportunities for cheaper solutions. I had a case study for assistance. I also did a cost evaluation for migration. I did the analysis of advantages and disadvantages using decision making software DEXi, where I appointed and described the criteria structure. The analysis what-if was made by DEXi and later graphically in Vredana. The final result of the paper was made after reviewing and analysing the results