Essays about: "star schema"

Showing result 1 - 5 of 7 essays containing the words star schema.

  1. 1. Using Work Domain Analysis to Evaluate the Design of a Data Warehouse System

    University essay from Uppsala universitet/Avdelningen för visuell information och interaktion

    Author : Axel Iveroth; [2019]
    Keywords : data warehouse; work domain analysis; cognitive work analysis; abstraction hierarchy; star schema; accumulating snapshot fact table; evaluation; issue management system; waterfall model;

    Abstract : Being able to perform good data analysis is a fundamental part of running any business or organization. One way of enabling data analysis is with a data warehouse system, a type of database that gathers and transforms data from multiple sources and structures it in the goal of simplifying analysis. READ MORE

  2. 2. Database Performance for GIS : A Comparison of Database Schemas for Measurements with Spatial Attributes

    University essay from KTH/Skolan för elektroteknik och datavetenskap (EECS)

    Author : Gabriel Ingemarsson ; [2019]
    Keywords : ;

    Abstract : Spatial databases are becoming more and more important. One type of spatial database is a database of measurements, which combine positions with alphanumerical attributes. While these databases are important, little research has been done on them. There is therefore need for research on how to store this type of data most effectively. READ MORE

  3. 3. Hive, Spark, Presto for Interactive Queries on Big Data

    University essay from KTH/Skolan för elektroteknik och datavetenskap (EECS)

    Author : Nikita Gureev; [2018]
    Keywords : Hadoop; SQL; interactive analysis; Hive; Spark; Spark SQL; Presto; Big Data;

    Abstract : Traditional relational database systems can not be efficiently used to analyze data with large volume and different formats, i.e. big data. Apache Hadoop is one of the first open-source tools that provides a distributed data storage system and resource manager. READ MORE

  4. 4. Consequences of converting a data warehouse based on a STAR-schema to a column-oriented-NoSQL-database

    University essay from Högskolan i Skövde/Institutionen för informationsteknologi

    Author : Rebecca Bodegård Gustafsson; [2018]
    Keywords : column-database; datawarehouse; nosql; apache; hbase; sql;

    Abstract : 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. READ MORE

  5. 5. Techniques for semi-automatic generation of data cubes from star-schemas

    University essay from Umeå universitet/Institutionen för datavetenskap

    Author : Mattias Hinnerson; [2017]
    Keywords : ;

    Abstract : 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. READ MORE