A carregar...
Publicação
Hybrid Data Warehouses: A Cloud and On-Premises Approach
| Nome: | Descrição: | Tamanho: | Formato: | |
|---|---|---|---|---|
| 1.36 MB | Adobe PDF |
Resumo(s)
This project investigates the crucial role of data warehouses in the decision-making processes of business analysts, focusing on the transition from traditional to cloud-based environments in the face of Big Data challenges. The spotlight is on hybrid data warehouses, bridging on-premises and cloud-based solutions, aiming to understand their architectures, motivations, technical approaches, and associated benefits and drawbacks.
In order to achieve the goal of this project, a Hybrid Data Warehouse that orchestrates on-premises and cloud systems with dimension and fact tables available in both locations was conceptualized. In this project were used Microsoft Tools, such as SQL Server, Visual Studio and the Azure Cloud.
Additionally, the project delves into reasons for organizations adopting hybrid data warehouses, including supporting hybrid data architecture, enhancing data accessibility, agility, and cost reduction, always considering the limitations of the scope, regarding the comparability to similar solutions and applicability in real-life scenarios.
Despite the limitations, while serving as a starting point, the project positions itself as a foundation for future research and development. It anticipates inspiring further exploration, optimization, and advancements in hybrid data warehouse architectures, contributing to the evolving landscape of data management in the digital era.
Descrição
Dissertation presented as the partial requirement for obtaining a Master's degree in Information Management, specialization in Knowledge Management and Business Intelligence
Palavras-chave
Business intelligence Hybrid data warehouses On-premises Cloud architecture Dimension and fact tables ETL (Extract Transform Load) Replication SDG 9 - Industry, innovation and infrastructure