Modelling and implementing big data warehouses for decision support

作     者：Maribel Yasmina Santos Bruno Martinho Carlos Costa 

作者机构：ALGORITMI Research CentreUniversity of MinhoGuimarãesPortugal 

出 版 物：《Journal of Management Analytics》 (管理分析学报（英文）)

年 卷 期：2017年第4卷第2期

页      面：111-129页

学科分类：08[工学] 0812[工学-计算机科学与技术（可授工学、理学学位）] 

基　　金：This work has been supported by COMPETE:POCI-01-0145-FEDER-007043 and FCT(Fundação para a Ciência e Tecnologia)within the Project Scope:UID/CEC/00319/2013 This work has been funded by the SusCity project(MITP-TB/CS/0026/2013) by Portugal Incentive System for Research and Technological Development,Project in co-promotion no 002814/2015(iFACTORY 2015-2018) 

主　　题：big data data model data warehouse hive NoSQL 

摘      要：In the era of Big Data,many NoSQL databases emerged for the storage and later processing of vast volumes of data,using data structures that can follow columnar,key-value,document or graph *** analytical contexts,requiring a Big Data Warehouse,Hive is used as the driving force,allowing the analysis of vast amounts of *** models in Hive are usually defined taking into consideration the queries that need to be *** this work,a set of rules is presented for the transformation of multidimensional data models into Hive tables,making available data at different levels of *** several levels are suited for answering different queries,depending on the analytical *** the identification of the Hive tables,this paper summarizes a demonstration case in which the implementation of a specific Big Data architecture shows how the evolution from a traditional Data Warehouse to a Big Data Warehouse is possible.