Primerjava in analiza učinkovitosti podatkovnih baz DB2 in MySQL

HUSAKOVIĆ, NEDIM (author), Zrnec, Aljaž (mentor)

Kljub temu, da obstaja veliko drugih različic podatkovnih baz, ki ne uporabljajo relacijskega podatkovnega modela, pa je le-ta trenutno najbolj uporabljen na svetu. Relacijske podatkovne baze uporabljajo strukturirani poizvedovalni jezik SQL in zagotavljajo ACID lastnosti transakcij. Cilj diplomske naloge je predstaviti relacijski podatkovni model in analizirati dve relacijski podatkovni bazi, in sicer DB2 ter MySQL, ki sta zaradi svoje varnosti in fleksibilnosti med najbolj uporabljenimi podatkovnimi bazami na svetu. Podatkovni bazi predstavimo tako s teoretičnega, kot s praktičnega vidika. V okviru teoretičnega dela na osnovi znanstvene literature predstavimo pojem podatkovne baze in opišemo njene značilnosti, zgodovino ter lastnosti. Glavni namen je predstaviti prednosti ter pomanjkljivosti relacijskih podatkovnih baz. Poleg opisa sistema je podana tudi primerjava med dvema popularnima podatkovnima bazama MySQL in DB2. V okviru praktičnega dela pa na osnovi testnih scenarijev predstavimo performančni analizi MySQL in DB2 na klasičnem ter na SSD disku. Na koncu, v zaključku sledijo sklepne ugotovitve in usmeritve glede izbora najprimernejše relacijske podatkovne baze za določen problem.

• Language: Slovenian
• Keywords: relacijska podatkovna baza, ACID, SQL, MySQL, DB2
• Work type: Bachelor thesis/paper
• Organization: FRI - Faculty of Computer and Information Science
• Year: 2017
• PID: 20.500.12556/RUL-98908
• Publication date in RUL: 11.12.2017

Secondary language

• Language: English
• Title: Comparison and performance analysis of DB2 and MySQL databases

Abstract

Despite the fact that there are a lot of other versions of databases that do not use relation data model, this one is the most used around the world. Relation databases use SQL, a structured query language, and provide ACID transaction properties. The goal of this diploma thesis is to present the relation database model and analyse two relation databases, DB2 and MySQL that are due to their security and flexibility among the most used in the world. The databases are presented from both theoretical and practical aspect. In the theoretical part, the term database, which is based on scientific literature and its features, history and properties are presented. The main goal is to present the advantages and disadvantages of relation databases. In addition to the description of the system, is a comparison between two popular databases, MySQL and DB2. In the practical portion, the performance of MySQL and DB2 is compared based on test scenarios on a HDD and SSD drives. The conclusion includes the findings and guides to choose the most suitable relation database for a specific problem.

• Keywords: relational database, ACID, SQL, MySQL, DB2