Högskolan i Skövde

his.sePublications
Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • apa-cv
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf
Consequences of converting a data warehouse based on a STAR-schema to a column-oriented-NoSQL-database
University of Skövde, School of Informatics.
2018 (English)Independent thesis Advanced level (degree of Master (One Year)), 10 credits / 15 HE creditsStudent thesis
Abstract [en]

Data warehouses based on the relational model has been a popular technology for many years, because they are very reliable due to their ACID-properties (Atomicity, Consistency, Isolation, and Durability). However, the new demands on databases today due to increasing amounts of data and data structures changing do mean that the relational model might not always be the optimal choice. NoSQL is the name of a group of databases that are less bound by schemas and are therefore more scalable and easier to make changes in. They are also adapted for massive parallel processing and are therefore suited for handling large amounts of data. Out of all of the NoSQL databases column-databases are the most like the relational model since it also consists of tables. This study has therefore converted a relational data warehouse based on a STAR-schema to a column-oriented-NoSQL-database and evaluated the implementation by comparing query-times between the relational data warehouse and the column-oriented-NoSQL-database. Scrambled economical data from a business in Sweden has been used to do the conversion and test it by asking a few usual queries. The results show that the mapping works but the query-time in the NoSQL-database is simnifically longer. 

Place, publisher, year, edition, pages
2018. , p. 38
Keywords [en]
column-database, datawarehouse, nosql, apache, hbase, sql
National Category
Computer Sciences
Identifiers
URN: urn:nbn:se:his:diva-15794OAI: oai:DiVA.org:his-15794DiVA, id: diva2:1222829
Subject / course
Informationsteknologi
Educational program
Data Science - Master’s Programme
Supervisors
Examiners
Available from: 2018-06-25 Created: 2018-06-23 Last updated: 2018-06-25Bibliographically approved

Open Access in DiVA

fulltext(1275 kB)1198 downloads
File information
File name FULLTEXT01.pdfFile size 1275 kBChecksum SHA-512
fdff65092100869ce6a2aa8b8d2d8a9824db8ae0800eaf455446bb51d4f59cb89128644599bd3514627088f64e2a91d3b2f46f4339194204ea3ba5fd4cb62e64
Type fulltextMimetype application/pdf

Search in DiVA

By author/editor
Bodegård Gustafsson, Rebecca
By organisation
School of Informatics
Computer Sciences

Search outside of DiVA

GoogleGoogle Scholar
Total: 1198 downloads
The number of downloads is the sum of all downloads of full texts. It may include eg previous versions that are now no longer available

urn-nbn

Altmetric score

urn-nbn
Total: 973 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • apa-cv
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf