| | SLO | ENG | Cookies and privacy

Bigger font | Smaller font

Show document Help

Title:COMPARISON OF MYSQL, NEO4J AND APACHE HIVE DATABASE MANAGEMENT SYSTEMS
Authors:ID Moser, Matjaž (Author)
ID Rajkovič, Uroš (Mentor) More about this mentor... New window
ID Kaya, Kamer (Comentor)
Files:.pdf MAG_Moser_Matjaz_2016.pdf (1,02 MB)
MD5: 434A305A5EF76BF93EA5CC007E9E344C
 
Language:English
Work type:Master's thesis/paper
Organization:FOV - Faculty of Organizational Sciences in Kranj
Abstract:In this work a comparison of three different database management systems (DBMS) is presented. In general a relational data model with a graph data model is compared. The three systems used are MySQL, Neo4j and Apache Hive. Neo4j is a member of the NoSQL database family and is a well-known graph database. The relational databases used in this work are MySQL and Apache Hive. The latter is not a classic relational model but since it is modelled as such it can be considered relational. MySQL is a well-known solution that has been on the market for several years now and is a standard solution for many data problems. Within this work a detailed comparison of all three systems from different aspects of usage is made, both from our own experience as well as from preliminary research from other authors and sources. Additionally some practical information from our dataset with some simple mining techniques is extracted and the result of our work is visualised in an interactive web side using modern approaches to data visualisation.
Keywords:Neo4j, MySQL, Apache Hadoop/Hive, database comparison, data visualisation
Place of publishing:Maribor
Year of publishing:2016
PID:20.500.12556/DKUM-57729 New window
COBISS.SI-ID:7575827 New window
NUK URN:URN:SI:UM:DK:E7XBO8UK
Publication date in DKUM:13.05.2016
Views:2688
Downloads:222
Metadata:XML DC-XML DC-RDF
Categories:FOV
:
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.

Secondary language

Language:Slovenian
Title:PRIMERJAVA SISTEMOV ZA UPRAVLJANJE BAZ PODATKOV MYSQL, NEO4J IN APACHE HIVE
Abstract:Jedro tega dela predstavlja primerjava časov izvedbe poizvedb na vseh treh sistemih. Poizvedbe so zasnovane z namenom preizkusa čim bolj širokega nabora aktivnosti (računanje, združevanje več tabel, iskanje po vrednosti, iskanje po razponu vrednosti ipd.. ). Na podlagi časov teh poizvedb smo prišli, do zaključka, da je v danih razmerah in v primeru relativno majhne količine podatkov MySQL najboljša izbira, sledi mu Neo4j in na zadnje Apache Hive. Glede ostalih vidikov primerjave bi bilo težko soditi saj so podvrženi posameznikovi presoji in znanju. Izračunali smo oddaljenost na podlagi skupnih sestavin v receptih kuhinj za vse pare med kuhinjami. Za potrebe teh izračunov smo ustvarili skripto z jezikom Python. Rezultate izračunov smo prikazali kot interaktivno spletno aplikacijo. Spletna stran prikazuje zemljevid sveta in na podlagi uporabnikovega klika na zemljevidu prikaže oddaljenost različnih kuhinj od izbrane, pri čemer uporablja za prikaz barvno lestvico. Za vizualizacijo rezultatov sta bila uporabljena knjižnica D3.js in JavaScript. Spletna stran v obliki besedila nudi tudi razlage za anomalije v rezultatih izračunov. Aplikacija svoje podatke pridobiva iz baze Neo4j v oblaku, pri čemer smo uporabili brezplačno gostovanje manjših grafovnih baz GrapheneDB. Aplikacija deluje na platformi Heroku, ki omogoča brezplačno gostovanje manjših aplikacij v oblaku (ang. PaaS – platform as a service).
Keywords:Neo4j, MySQL, Apache Hadoop/Hive, primerjava sistemov za upravljanje podatkovih baz, vizualizacija podatkov


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