Analiza odvisnosti med objekti podatkovne baze Oracle

diplomsko delo

Miha Tomšič (Author), Peter Kokol (Mentor)

Abstract

V diplomskem delu smo v teoretičnem delu proučevali podatkovno bazo Oracle, njeno strukturo, najpomembnejše stavke, s katerimi lahko manipuliramo s podatki, in vse bazne objekte ter njihovo uporabo. Nato smo v praktičnem delu prikazali več načinov, kako analizirati odvisnosti med baznimi objekti v podatkovni bazi Oracle s pomočjo programskih jezikov SQL in PL/SQL in razvojnega okolja PL/SQL Developer. Nato smo se odločili za rešitev, ki je bila primerna za vpeljavo v grafični vmesnik. Opisali smo razvojno okolje Oracle Apex in z njegovo pomočjo razvili grafični vmesnik, ki omogoča izbiro določenega baznega objekta in nam vrne podatek, kje v podatkovni bazi se uporablja

Keywords

podatkovna baza Oracle;podatkovne baze;analiza odvisnosti;bazni objekti;grafični vmesniki;diplomske naloge;

Data

Language:	Slovenian
Year of publishing:	2023
Typology:	2.11 - Undergraduate Thesis
Organization:	UM FERI - Faculty of Electrical Engineering and Computer Science
Publisher:	[Ž. Tomšič]
UDC:	004.633(043.2)
COBISS:	171261955
Views:	76
Downloads:	10
Average score:	0 (0 votes)
Metadata:

Other data

Secondary language:	English
Secondary title:	Dependency analysis between Oracle database objects
Secondary abstract:	In the thesis, in the theoretical part, we explored the Oracle database, its structure, the essential statements for data manipulation, all its database objects and their usage. In the practical part, we demonstrated multiple ways to analyze dependencies among database objects in the Oracle database using SQL and PL/SQL programming languages and the PL/SQL Developer development environment. Subsequently, we opted for a solution suitable for implementation in the graphical interface. We described the Oracle Apex development environment and utilized it to develop a graphical interface that allows selecting a particular database object and returns information on its usage within the database
Secondary keywords:	Oracle;database;dependency analysis;database objects;graphical interface;
Type (COBISS):	Bachelor thesis/paper
Thesis comment:	Univ. v Mariboru, Fak. za elektrotehniko, računalništvo in informatiko, Računalništvo in informacijske tehnologije
Pages:	1 spletni vir (1 datoteka PDF (XIII, 52 f.))
ID:	19828159