Spletna aplikacija za pripravo namestitve objektov v podatkovni bazi Oracle

GLIGOREVIĆ, ZORAN (author), Zrnec, Aljaž (mentor), Poženel, Marko (comentor)

V diplomskem delu sta predstavljena razvoj in delovanje spletne aplikacije za pripravo namestitve baznih objektov. Namen aplikacije, ki je bila razvita za specifično podjetje, je zagotoviti uporabnikom hitro in enostavno pripravo namestitvenih skript. Glavne funkcionalnosti aplikacije so samodejna priprava in posodabljanje namestitvenih skript, samodejno generiranje ukazov DDL za izbrane bazne objekte ter samodejna priprava celotne namestitve baznih objektov. V prvem delu diplomske naloge na kratko opišemo tehnologije in orodja, ki so bila uporabljena pri razvoju aplikacije. V nadaljevanju predstavimo načrt samodejne priprave ukazov DDL in samodejne priprave celotne namestitve baznih objektov v spletni aplikaciji. Tako samodejno pripravo ukazov DDL kot pripravo virov, ki so potrebni za samodejno pripravo namestitve baznih objektov, smo implementirali v podatkovni bazi Oracle, s pomočjo programskega jezika PL/SQL. Nato bolj podrobno predstavimo in opišemo še ostale ključne funkcionalnosti aplikacije, ki uporabniku pomagajo pri pripravi namestitvenih skript. V zadnjem delu diplomske naloge predstavimo še sorodna orodja ter podamo zaključne misli.

• Language: Slovenian
• Keywords: namestitev, DDL, Oracle, objekti v podatkovni bazi, skripte SQL, avtomatizacija postopka priprave namestitve, spletna aplikacija
• Work type: Bachelor thesis/paper
• Typology: 2.11 - Undergraduate Thesis
• Organization: FRI - Faculty of Computer and Information Science
• Year: 2021
• PID: 20.500.12556/RUL-128571
• COBISS.SI-ID: 70938115
• Publication date in RUL: 20.07.2021

Secondary language

• Language: English
• Title: Web application for deployment preparation of database objects in Oracle database

Abstract

This thesis presents the development and operation of a Web application for deployment preparation of database objects. The purpose of our application, which was developed for a specific company, is to enable users quick and easy deployment preparation. The main functionalities of our application are automatic preparation and updating of deployment scripts, automatic generation of DDL commands for selected objects, and automatic preparation of the entire deployment of database objects in Web application. In the first part of the thesis, we briefly describe the technologies and tools that were used in the development phase. Next, we present a plan for automatic preparation of DDL commands and automatic preparation of the entire deployment of database objects in Web application. Both, automatic preparation of DDL commands as well as preparation of resources required for the automatic preparation of deployment of database objects, were implemented in the Oracle database, using the PL / SQL programming language. We also present key functionalities of our application that facilitate the end user to prepare deployment scripts and other deployment resources. In the last part of this thesis, we also review related tools and give concluding thoughts.

• Keywords: deployment, DDL, Oracle, database objects, SQL scripts, automated preparation of deployment, Web application