prikaz prve stranice dokumenta Optimizacija upita korištenjem pogleda i materijaliziranih pogleda
  Download
PDF 1.65 MB
undergraduate thesis
Optimizacija upita korištenjem pogleda i materijaliziranih pogleda
Split: University of Split, Faculty of Science, 2024. urn:nbn:hr:166:901706
Skočibušić, Danijela
University of Split
Faculty of Science

Institutional repository: Repository of Faculty of Science

Cite this document

Skočibušić, D. (2024). Optimizacija upita korištenjem pogleda i materijaliziranih pogleda (Undergraduate thesis). Split: University of Split, Faculty of Science. Retrieved from https://urn.nsk.hr/urn:nbn:hr:166:901706

Skočibušić, Danijela. "Optimizacija upita korištenjem pogleda i materijaliziranih pogleda." Undergraduate thesis, University of Split, Faculty of Science, 2024. https://urn.nsk.hr/urn:nbn:hr:166:901706

Skočibušić, Danijela. "Optimizacija upita korištenjem pogleda i materijaliziranih pogleda." Undergraduate thesis, University of Split, Faculty of Science, 2024. https://urn.nsk.hr/urn:nbn:hr:166:901706

Skočibušić, D. (2024). 'Optimizacija upita korištenjem pogleda i materijaliziranih pogleda', Undergraduate thesis, University of Split, Faculty of Science, accessed 27 November 2024, https://urn.nsk.hr/urn:nbn:hr:166:901706

Skočibušić D. Optimizacija upita korištenjem pogleda i materijaliziranih pogleda [Undergraduate thesis]. Split: University of Split, Faculty of Science; 2024 [cited 2024 November 27] Available at: https://urn.nsk.hr/urn:nbn:hr:166:901706

D. Skočibušić, "Optimizacija upita korištenjem pogleda i materijaliziranih pogleda", Undergraduate thesis, University of Split, Faculty of Science, Split, 2024. Available at: https://urn.nsk.hr/urn:nbn:hr:166:901706

Metadata
TitleOptimizacija upita korištenjem pogleda i materijaliziranih pogleda
Title (english)Query optimization using views and materialized views
AuthorDanijela Skočibušić
MentorMonika Mladenović (mentor)
Committee memberMonika Mladenović (predsjednik povjerenstva)
Committee memberDivna Krpan (član povjerenstva)
Committee memberAntonela Prnjak (član povjerenstva)
GranterUniversity of Split
Faculty of Science
Split
Defense date and country2024-09-23, Croatia
Scientific / art field,
discipline and subdiscipline		TECHNICAL SCIENCES
Computing
Abstract
U ovom završnom radu, cilj je bio napraviti usporedbu korištenja pogleda i materijaliziranih pogleda te se osvrnuti na osnovne karakteristike korištenja pohranjenih procedura. U tu svrhu osmišljena je i realizirana relacijska baza podataka nazvana Dostava hrane koja sadrži sve informacije koje se vežu uz stvaranje jedne online narudžbe iz nekog restorana i koja bi se mogla učinkovito koristiti za aplikacije koje omogućavaju online narudžbe. Baza je kreirana uz pomoć Oracle alata. Za kreiranje logičkog i relacijskog modela korišten je Oracle SQL Data Modeler, dok je za izradu korisnika, pogleda, materijaliziranih pogleda i procedura korišten Oracle SQL Developer. Rad obuhvaća teorijski dio od same pojave baza podataka, razvoja relacijskih baza, osnove Oracle alata, postupak izrade baze podataka, pogleda, materijaliziranih pogleda i pohranjenih procedura.
Abstract (english)
In this final thesis, the goal was to make a comparison of the use of views and materialized views and to look at the basic characteristics of using stored procedures. For this purpose, a relational database called Food Delivery was designed and implemented, which contains all the information related to the creation of an online order from a restaurant and which could be effectively used for applications that enable online orders. The database was created with the help of Oracle tools. Oracle SQL Data Modeler was used to create the logical and relational model, while Oracle SQL Developer was used to create user, views, materialized views and procedures. The work includes the theoretical part from the very emergence of the database, the development of relational databases, the basics of Oracle tools, the process of creating a database, views, materialized views and stored procedures.
Keywords
Keywords (english)
Languagecroatian
URN:NBNurn:nbn:hr:166:901706
Study programmeTitle: Computer Science
Study programme type: university
Study level: undergraduate
Academic / professional title: sveučilišni/a prvostupnik/prvostupnica (baccalaureus/baccalaurea) informatike (sveučilišni/a prvostupnik/prvostupnica (baccalaureus/baccalaurea) informatike)
Type of resourceText
File originBorn digital
Access conditionsOpen access
Terms of useLicence In copyright icon
Created on2024-09-24 13:12:40