Which Data Warehouse Architecture is Best?

被引：6
|
作者：
Ariyachandra, Thilini [1 ]
Watson, Hugh J. [2 ]
机构：
[1] Xavier Univ, Williams Coll Business, MIS, Cincinnati, OH 45207 USA
[2] Univ Georgia, Terry Coll Business, MIS, Athens, GA 30602 USA
来源：
COMMUNICATIONS OF THE ACM | 2008年 / 51卷 / 10期
关键词：
(Edited Abstract);
D O I：
10.1145/1400181.1400213
中图分类号：
TP3 [计算技术、计算机技术];
学科分类号：
0812 ;
摘要：
Some of the significant factors that need to be considered before choosing data warehouse architecture, are discussed. The independent data marts provide a repository of decision support data for a specific application or business unit. The bus architecture has data marts to support orders, deliveries, or customer call for any business process. The hub and spoke architecture provide enterprise-level analysis of data requirement to create maintainable infrastructure. This architecture maintains atomic level data in the warehouse in normal form and create dependent data marts. The centralized architecture is similar to hub and spoke without any dependent data marts and contains atomic level data, summarized data, and logical dimensional views of the data. The federated architecture can be used for fragmented decision support data environment.
引用
收藏
页码：146 / 147
页数：2
相关论文
共 50 条
  • [31] Privacy-aware Big Data Warehouse Architecture
    Navuluri, Karthik
    Mukkamala, Ravi
    Ahmad, Aftab
    2016 IEEE INTERNATIONAL CONGRESS ON BIG DATA - BIGDATA CONGRESS 2016, 2016, : 341 - 344
  • [32] Proposal of a New Data Warehouse Architecture Reference Model
    Dymek, Dariusz
    Komnata, Wojciech
    Szwed, Piotr
    BEYOND DATABASES, ARCHITECTURES AND STRUCTURES, BDAS 2015, 2015, 521 : 210 - 221
  • [33] The Architecture and Design Strategy for Data Warehouse of Highway Management
    Zhou Qian
    Sun Li-jun
    ICICTA: 2009 SECOND INTERNATIONAL CONFERENCE ON INTELLIGENT COMPUTATION TECHNOLOGY AND AUTOMATION, VOL IV, PROCEEDINGS, 2009, : 459 - 462
  • [34] Toward XML-based data warehouse architecture
    Rifaieh, R
    Benkat, NA
    INFORMATION TECHNOLOGY AND ORGANIZATIONS: TRENDS, ISSUES, CHALLENGES AND SOLUTIONS, VOLS 1 AND 2, 2003, : 552 - 555
  • [35] Model-driven Architecture Approach for Data Warehouse
    Fernandes, Lucia Abrunhosa
    Helena Neto, Beatriz
    Fagundes, Vladimir
    Zimbrao, Geraldo
    de Souza, Jano Moreira
    Salvador, Rodrigo
    SIXTH INTERNATIONAL CONFERENCE ON AUTONOMIC AND AUTONOMOUS SYSTEMS: ICAS 2010, PROCEEDINGS, 2010, : 156 - 161
  • [36] A hilbert space compression architecture for data warehouse environments
    Eavis, Todd
    Cueva, David
    DATA WAREHOUSING AND KNOWLEDGE DISCOVERY, PROCEEDINGS, 2007, 4654 : 1 - +
  • [37] A Generic Data Warehouse Architecture for Analyzing Workflow Logs
    Koncilia, Christian
    Pichler, Horst
    Wrembel, Robert
    ADVANCES IN DATABASES AND INFORMATION SYSTEMS, ADBIS 2015, 2015, 9282 : 106 - 119
  • [38] DWARM: An Ontology of Data Warehouse Architecture Reference Model
    Szwed, Piotr
    Komnata, Wojciech
    Dymek, Dariusz
    BEYOND DATABASES, ARCHITECTURES AND STRUCTURES, BDAS 2015, 2015, 521 : 222 - 232
  • [39] Which is the Best Test for my Data?
    Berger, Uwe
    PSYCHOTHERAPIE PSYCHOSOMATIK MEDIZINISCHE PSYCHOLOGIE, 2010, 60 (11) : 457 - 458
  • [40] Migrating from a Centralized Data Warehouse to a Decentralized Data Platform Architecture
    Loukiala, Antti
    Joutsenlahti, Juha-Pekka
    Raatikainen, Mikko
    Mikkonen, Tommi
    Lehtonen, Timo
    PRODUCT-FOCUSED SOFTWARE PROCESS IMPROVEMENT (PROFES 2021), 2021, 13126 : 36 - 48
12345