| | SLO | ENG | Cookies and privacy

Bigger font | Smaller font

Show document Help

Title:Analiza odvisnosti med objekti podatkovne baze Oracle : diplomsko delo
Authors:ID Tomšič, Miha (Author)
ID Kokol, Peter (Mentor) More about this mentor... New window
Files:.pdf VS_Tomsic_Miha_2023.pdf (2,67 MB)
MD5: C765E3FF9C0AC638B62CCD180E0ADA85
 
Language:Slovenian
Work type:Bachelor thesis/paper
Typology:2.11 - Undergraduate Thesis
Organization:FERI - Faculty of Electrical Engineering and Computer Science
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:Oracle, podatkovna baza, analiza odvisnosti, bazni objekti, grafični vmesnik
Place of publishing:Maribor
Place of performance:Maribor
Publisher:[Ž. Tomšič]
Year of publishing:2023
Number of pages:1 spletni vir (1 datoteka PDF (XIII, 52 f.))
PID:20.500.12556/DKUM-85183 New window
UDC:004.633(043.2)
COBISS.SI-ID:171261955 New window
Publication date in DKUM:13.10.2023
Views:239
Downloads:33
Metadata:XML RDF-CHPDL DC-XML DC-RDF
Categories:KTFMB - FERI
:
Copy citation
  
Average score:(0 votes)
Your score:Voting is allowed only for logged in users.
Share:Bookmark and Share


Hover the mouse pointer over a document title to show the abstract or click on the title to get all document metadata.

Licences

License:CC BY-NC-ND 4.0, Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International
Link:http://creativecommons.org/licenses/by-nc-nd/4.0/
Description:The most restrictive Creative Commons license. This only allows people to download and share the work for no commercial gain and for no other purposes.
Licensing start date:21.08.2023

Secondary language

Language:English
Title:Dependency analysis between Oracle database objects
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
Keywords:Oracle, database, dependency analysis, database objects, graphical interface


Comments

Leave comment

You must log in to leave a comment.

Comments (0)
0 - 0 / 0
 
There are no comments!

Back
Logos of partners University of Maribor University of Ljubljana University of Primorska University of Nova Gorica