Umeå University's logo

umu.sePublications
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • 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
Techniques for semi-automatic generation of data cubes from star-schemas
Umeå University, Faculty of Science and Technology, Department of Computing Science.
2017 (English)Independent thesis Advanced level (degree of Master (Two Years)), 20 credits / 30 HE creditsStudent thesis
Abstract [en]

The aim of this thesis is to investigate techniques to better automate the process of generating data cubes from star- or snowflake schemas. The company Trimma builds cubes manually today, but we will investigate doing this more efficiently. We will select two basic approaches and implement them in Prototype A and Prototype B. Prototype A is a direct method that communicates directly with a database server. Prototype B is an indirect method that creates configuration files that can, later on, get loaded onto a database server. We evaluate the two prototypes over a star schema and a snowflake schema case provided by Trimma. The evaluation criteria include completeness, usability, documentation and support, maintainability, license costs, and development speed. Our evaluation indicates that Prototype A is generally outperforming Prototype B and that prototype A is arguably performing better than the manual method current employed by Trimma.

Place, publisher, year, edition, pages
2017. , p. 68
Series
UMNAD ; 1090
National Category
Engineering and Technology
Identifiers
URN: urn:nbn:se:umu:diva-130648OAI: oai:DiVA.org:umu-130648DiVA, id: diva2:1069087
External cooperation
Trimma AB
Educational program
Master of Science Programme in Computing Science and Engineering
Supervisors
Examiners
Available from: 2017-01-27 Created: 2017-01-27Bibliographically approved

Open Access in DiVA

fulltext(662 kB)875 downloads
File information
File name FULLTEXT01.pdfFile size 662 kBChecksum SHA-512
d2c402611fd99577f15cdb3357fb97b31866a86acc82462f69d59f5c09edf673535a3038412136d49a203275fa0fdec004cac5bafbcdeb3819fab1fee0c45438
Type fulltextMimetype application/pdf

By organisation
Department of Computing Science
Engineering and Technology

Search outside of DiVA

GoogleGoogle Scholar
Total: 875 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: 680 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • 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