| | SLO | ENG | Cookies and privacy

Bigger font | Smaller font

Show document Help

Title:Razlike v sintaksi stavkov sql ob uporabi različnih sistemov za upravljanje podatkovnih baz : diplomsko delo
Authors:ID Perovšek Tribušon, Zala (Author)
ID Nemec Zlatolas, Lili (Mentor) More about this mentor... New window
Files:.pdf VS_Perovsek_Tribuson_Zala_2022.pdf (1,62 MB)
MD5: 49B0C5EA7E056A797D81512013692B00
 
Language:Slovenian
Work type:Bachelor thesis/paper
Typology:2.11 - Undergraduate Thesis
Organization:FERI - Faculty of Electrical Engineering and Computer Science
Abstract:Namen diplomskega dela je bila primerjava sintakse stavkov SQL ob uporabi sistemov MySQL, MS SQL Server, Oracle in PostgreSQL. Primerjalo se je definiranje podatkovnih tipov in sintakso pogostih povpraševanj iz skupin DDL, DML, DCL in TCL. Razlike so prikazane v tabelah, iz katerih je razvidno, kateri SUPB podpira katere ukaze. V primeru sintaktične razlike, kjer določena funkcija ni na voljo za izbran SUPB, se je iskalo alternativo, ki ukaz simulira. Ugotavljalo se je vpliv sintaktičnih razlik na dobljeni rezultat.
Keywords:SQL, MySQL, MS SQL Server, Oracle, PostgreSQL
Place of publishing:Maribor
Place of performance:Maribor
Publisher:[Z. Perovšek Tribušon]
Year of publishing:2022
Number of pages:1 spletni vir (1 datoteka PDF (XII, 61 f.))
PID:20.500.12556/DKUM-82600 New window
UDC:004.422.5:004.65(043.2)
COBISS.SI-ID:134618627 New window
Publication date in DKUM:21.10.2022
Views:1105
Downloads:88
Metadata:XML 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:26.08.2022

Secondary language

Language:English
Title:Differences in the sql syntax statements using different database management systems
Abstract:The main objective of this thesis is to compare the syntax of SQL statements when using MySQL, MS SQL Server, Oracle and PostgreSQL systems. We compared datatypes and syntax of frequently used queries from the DDL, DML, DCL and TCL categories. We have shown the differences in tables from which we can see which DBMS supports which commands. In case of syntax differences where certain function is not available for selected DMBS we searched for alternative that simulates the behaviour of the command. We determined the influence of syntax differences on the obtained result.
Keywords:SQL, MySQL, MS SQL Server, Oracle, PostgreSQL


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