Presentation av examensarbete Kandidat / Civilingenjör Informationsteknik (CINTE)
- Titel:
A comparative study of schemaless storage on SQL Databases
- A comparison on performance
- Respondent: DANIEL LINDFORS och MARTIN LIND OROS
- Datum och Tid: Fredag 9 februari 2018 kl 14-15
- Plats: Konferensrum Alonzo hiss A, plan 4
- Opponent: -
- Aktiva lyssnare: Sam Junttila, Gustaf Björckén, Dejan Ristic
- Examinator: Thomas Sjöland
- Handledare: Edward Tjörnhammar.
- Språk: Engelska (evt sker presentationen på svenska)
- Anmälan: Behövs ej
Abstract
There are many reasons to store data in a schemaless manner. Custom database
fields and non-uniform data types are both good reasons to use a schemaless approach.
The most common databases which attain schemaless properties are the non-relational,
i.e. NoSQL databases. However, there still exists motives to rely on a relational
database, rather than using a non-relational database, due to its ability to achieve
both performance and consistency. In this study we investigate the possibilities to
deploy a schemaless model within the relational database MySQL with purpose to
achieve flexibility and still keep the benefits of ACID transactions. These techniques
are then compared to each other with regard to performance. The industry standard
Yahoo Cloud Serving Benchmark has been used to gather the results from the performance
measurements. The methods, on the other hand, used to achieve schemaless
abilities has been gathered through literature studies and reasoning. The performance
measurements could only show that there was a significant difference between methods
for the READ operation.
Keywords: schemaless, database, SQL, comparison, performance, YCSB, benchmark