| | SLO | ENG | Cookies and privacy

Bigger font | Smaller font
First page > Show document

Show document Help

Title:Primerjava poizvedb med različnimi sistemi za upravljanje podatkovnih baz : diplomsko delo
Authors:ID Rozman, Gašper (Author)
ID Nemec Zlatolas, Lili (Mentor) More about this mentor... New window
ID Hrgarek, Luka (Comentor)
Files:.pdf VS_Rozman_Gasper_2021.pdf (1,97 MB)
MD5: 7269B098FFC3A470524AD8C779E3FB95
PID: 20.500.12556/dkum/1383fb44-74ae-41cf-9269-3dae580395ca
 
Language:Slovenian
Work type:Bachelor thesis/paper
Typology:2.11 - Undergraduate Thesis
Organization:FERI - Faculty of Electrical Engineering and Computer Science
Abstract:Glavni namen diplomske naloge je primerjava delovanja SQLite, MariaDB, MySQL, PostgreSQL in Microsoft SQL sistemov za upravljanje podatkovnih baz (SUPB). Ugotovitve so namenjene lažjemu odločanju, kateri SUPB je primernejši za uporabo za določene potrebe. Analizirali smo hitrost poizvedb na tisoč, 10 tisoč, 100 tisoč, milijon in 10 milijonih podatkih iz realnega sveta. Iskali smo numerični ID, vrednosti večje od števila, ključne besede treh različnih dolžin v kratkem in dolgem besedilu in iskali vsebino med datumoma. Vsak test smo izvedli 10-krat in izračunali povprečni čas izvajanja. Zgornja meja testa je bila 60 sekund. V poizvedbah z iskanjem numeričnih vrednosti se je najbolje brez indeksa in z njim odrezal Microsoft SQL, pri poizvedbah z besedilom pa PostgreSQL.
Keywords:SQLite, MariaDB, MySQL, PostgreSQL, Microsoft SQL
Place of publishing:Maribor
Place of performance:Maribor
Publisher:[G. Rozman]
Year of publishing:2021
Number of pages:VIII, 59 str.
PID:20.500.12556/DKUM-79815 New window
UDC:004.422.639(043.2)
COBISS.SI-ID:87867139 New window
Publication date in DKUM:18.10.2021
Views:1044
Downloads:129
Metadata:XML DC-XML DC-RDF
Categories:KTFMB - FERI
:
ROZMAN, Gašper, 2021, Primerjava poizvedb med različnimi sistemi za upravljanje podatkovnih baz : diplomsko delo [online]. Bachelor’s thesis. Maribor : G. Rozman. [Accessed 17 April 2025]. Retrieved from: https://dk.um.si/IzpisGradiva.php?lang=eng&id=79815
Copy citation
  
Average score:
0.5
1
1.5
2
2.5
3
3.5
4
4.5
5
(0 votes)
Your score:Voting is allowed only for logged in users.
Share:Bookmark and Share


Searching for similar works...Please wait....
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 4.0, Creative Commons Attribution 4.0 International
Link:http://creativecommons.org/licenses/by/4.0/
Description:This is the standard Creative Commons license that gives others maximum freedom to do what they want with the work as long as they credit the author.
Licensing start date:18.08.2021

Secondary language

Language:English
Title:Query comparison between different database management systems
Abstract:Main objective of this thesis is benchmarking of relational database management systems, such as SQLite, MariaDB, MySQL, PostgreSQL and Microsoft SQL. Results are meant to be used to easier determined which RDBMS is better for specific needs. Our analyses were done on thousand, 10 thousand, 100 thousand, 1 million and 10 million data. Performed tests were: searching for numerical ID, values greater than some number, key words of three different lengths in short and long text and searching between two dates. Every test has been done and measured 10 times and average time has been used. Upper limit was 60 seconds. For query with numerical values, Microsoft SQL was the fastest with index and without it, for text values PostgreSQL was performing the fastest.
Keywords:SQLite, MariaDB, MySQL, PostgreSQL, Microsoft SQL


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