prikaz prve stranice dokumenta Usporedba SQL server i Oracle sustava za upravljanje relacijskim bazama podataka
  Download
PDF 1.19 MB
undergraduate thesis
Usporedba SQL server i Oracle sustava za upravljanje relacijskim bazama podataka
2022. urn:nbn:hr:166:766508
Varešković, Dražena
University of Split
Faculty of Science
Department of Informatics

Cite this document

Varešković, D. (2022). Usporedba SQL server i Oracle sustava za upravljanje relacijskim bazama podataka (Undergraduate thesis). Split: University of Split, Faculty of Science. Retrieved from https://urn.nsk.hr/urn:nbn:hr:166:766508

Varešković, Dražena. "Usporedba SQL server i Oracle sustava za upravljanje relacijskim bazama podataka." Undergraduate thesis, University of Split, Faculty of Science, 2022. https://urn.nsk.hr/urn:nbn:hr:166:766508

Varešković, Dražena. "Usporedba SQL server i Oracle sustava za upravljanje relacijskim bazama podataka." Undergraduate thesis, University of Split, Faculty of Science, 2022. https://urn.nsk.hr/urn:nbn:hr:166:766508

Varešković, D. (2022). 'Usporedba SQL server i Oracle sustava za upravljanje relacijskim bazama podataka', Undergraduate thesis, University of Split, Faculty of Science, accessed 02 May 2024, https://urn.nsk.hr/urn:nbn:hr:166:766508

Varešković D. Usporedba SQL server i Oracle sustava za upravljanje relacijskim bazama podataka [Undergraduate thesis]. Split: University of Split, Faculty of Science; 2022 [cited 2024 May 02] Available at: https://urn.nsk.hr/urn:nbn:hr:166:766508

D. Varešković, "Usporedba SQL server i Oracle sustava za upravljanje relacijskim bazama podataka", Undergraduate thesis, University of Split, Faculty of Science, Split, 2022. Available at: https://urn.nsk.hr/urn:nbn:hr:166:766508

Please login to the repository to save this object to your list.
Metadata
TitleUsporedba SQL server i Oracle sustava za upravljanje relacijskim bazama podataka
Title (english)Comparison of SQL Server and Oracle Relational database management systems
AuthorDražena Varešković
MentorMonika Mladenović (mentor)
Committee memberMonika Mladenović (predsjednik povjerenstva)
Committee memberDivna Krpan (član povjerenstva)
Committee memberGoran Zaharija (član povjerenstva)
GranterUniversity of Split
Faculty of Science
(Department of Informatics)
Split
Defense date and country2022-09-08, Croatia
Scientific / art field,
discipline and subdiscipline		TECHNICAL SCIENCES
Computing
Abstract
Cilj završnog rada bio je napraviti usporedbu dva najkorištenija sustava za relacijske baze podataka, SQL Server i Oracle. Usporedba je osmišljena na način da se korisnik može lakše odlučiti za vrstu sustava pri izradi vlastite baze podataka. Mnogo je temeljnih razlika između Oracle i SQL Servera, a jedna od razlika je jezik koji koriste. Ovim radom bit će prikazane usporedbe SQL Servera i Oracle SQL Developera vezano za modeliranje i implementaciju baze podatka. Nakon što smo se upoznali s osnovnom teorijom vezanom uz područje relacijskih baza podataka prikladno je da ju pretočimo u praktični dio. Za potrebe ovog projekta osmišljena je i realizirana baza podataka koja može učinkovito poslužiti za potrebe srednje škole. Nakon kreiranja logičkog i relacijskog modela baze podataka potrebno je izraditi DDL kojeg ćemo izvršiti u Oracle SQL Developeru kako bismo relacijski model baze podataka pretočili u relacijsku bazu podataka. Nakon što smo u Data Modeleru kreirali DDL, slijedi nekoliko usporedba vezanih za SQL Server i Oracle kao što su spajanje na bazu, usporedba tipova podataka, razlike u transakcijskom dijelu, usporedba strukture pohrane te razlike u cijeni.
Abstract (english)
The goal of the final work was to make a comparison of the two most used systems for relational databases, SQL Server and Oracle. The comparison is designed in such a way that the user can more easily decide on the type of system when creating his own database. There are many fundamental differences between Oracle and SQL Server, and one of the differences is the language they use. This paper will present comparisons between SQL Server and Oracle SQL Developer related to database modeling and implementation. After we have familiarized ourselves with the basic theory related to the field of relational databases, it is appropriate to translate it into a practical part. For the purposes of this project, a database was designed and implemented that can effectively serve the needs of the high school. After creating the logical and relational database model, it is necessary to create DDL, which we will execute in Oracle SQL Developer in order to convert the relational database model into a relational database. After we have created the DDL in Data Modeler, there are several comparisons related to SQL Server and Oracle, such as connection to the database, comparison of data types, differences in the transactional part, comparison of the storage structure, and price differences.
Keywords
Keywords (english)
Languagecroatian
URN:NBNurn:nbn:hr:166:766508
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 on2022-09-09 10:56:23