izpis_h1_title_alt

Primerjava in analiza učinkovitosti podatkovnih baz DB2 in MySQL
ID HUSAKOVIĆ, NEDIM (Author), ID Zrnec, Aljaž (Mentor) More about this mentor... This link opens in a new window

.pdfPDF - Presentation file, Download (499,78 KB)
MD5: F2B0B2F379E5F549548E586CF6EC8094
PID: 20.500.12556/rul/593fc1ce-2836-4259-9c48-099eac45bfb2

Abstract
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 This link opens in a new window
Publication date in RUL:11.12.2017
Views:1385
Downloads:408
Metadata:XML RDF-CHPDL DC-XML DC-RDF
:
Copy citation
Share:Bookmark and Share

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

Similar documents

Similar works from RUL:
Similar works from other Slovenian collections:

Back