Vrednovanje baze podataka Apache Cassandra

master's thesis

• Title (english): Apache Cassandra Database Evaluation
• Author: Mateo Glavičić
• Mentor: Krešimir Fertalj (mentor)
• Committee member: Krešimir Fertalj (predsjednik povjerenstva)
• Committee member: Zdravko Galić (član povjerenstva)
• Committee member: Igor Mekterović (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2018-07-02, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Computing

Abstract

U radu su opisane mogućnosti i ograničenja distribuiranog sustava za upravljanje bazama podataka Apache Cassandra. Prikazani su različiti načini ugradnje sheme podataka, te su kao rezultat rada nastala dva reprezentativna projekta u kojima je na dva različita načina ostvarena društvena mreža. Jedan se projekt temelji na klijentskim spajanjima i normaliziranim podatcima, dok se drugi temelji na denormalizaciji podataka i pravilom „tablica po upitu“. Uz projekte društvene mreže, kreirana je i komandno-linijska aplikacija za mjerenje performansi različitih načina pristupa podatcima unutar jedne particije. Uspoređivane su performanse upita nad materijaliziranim pogledima, podatcima nad kojim su kreirani sekundarni i SASI indeksi te neindeksiranim podatcima uporabom opcije allow filtering.

Abstract (english)

This thesis describes features and limits of Apache Cassandra distributed database management system. It presents various principles of schema design, and as a result two representative projects were made. In these projects a social network is realized in two distinct ways. The first one relies on client-side joins and data normalization, and the second one on data denormalization and „table per query“ rule. Along the social network projects a command-line application for performance measurement was also created. The application measures performance of queries with various access patterns on one partition and compares query speed on materialized views, data with secondary and SASI indexes, and non-indexed data using „allow filtering“ option.

• Keywords: Apache Cassandra; NoSQL; distribuirana baza podataka; ugradnja sheme; klijentska spajanja; denormalizacija podataka; materijalizirani pogledi; sekundarni indeksi; SASI indeksi
• Keywords (english): Apache Cassandra; NoSQL; distributed database; schema design; client-side joins; data denormalization; materialized views; secondary index; SASI index
• Language: croatian
• URN:NBN: urn:nbn:hr:168:027657
• Study programme: Title: Computing; Study programme type: university; Study level: graduate; Academic / professional title: magistar/magistra inženjer/inženjerka računarstva (magistar/magistra inženjer/inženjerka računarstva)
• Type of resource: Text
• File origin: Born digital
• Access conditions: Closed access
• Created on: 2019-03-13 20:27:53