Razlike v sintaksi stavkov SQL ob uporabi različnih sistemov za upravljanje podatkovnih baz

diplomsko delo

Zala Perovšek Tribušon (Author), Lili Nemec (Mentor)

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

sintaksa stavkov SQL;sistem MySQL;sistem MS SQL Server;sistem Oracle;sistem PostgreSQL;diplomske naloge;

Data

Language:	Slovenian
Year of publishing:	2022
Typology:	2.11 - Undergraduate Thesis
Organization:	UM FERI - Faculty of Electrical Engineering and Computer Science
Publisher:	[Z. Perovšek Tribušon]
UDC:	004.422.5:004.65(043.2)
COBISS:	134618627
Views:	83
Downloads:	17
Average score:	0 (0 votes)
Metadata:

Other data

Secondary language:	English
Secondary title:	Differences in the sql syntax statements using different database management systems
Secondary 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.
Secondary keywords:	SQL;MySQL;MS SQL Server;Oracle;PostgreSQL;
Type (COBISS):	Bachelor thesis/paper
Thesis comment:	Univ. v Mariboru, Fak. za elektrotehniko, računalništvo in informatiko, Informatika in tehnologije komuniciranja
Pages:	1 spletni vir (1 datoteka PDF (XII, 61 f.))
ID:	16272837