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 条
  • [1] Data Warehouse Architecture Classification
    Blazic, G.
    Poscic, P.
    Jaksic, D.
    2017 40TH INTERNATIONAL CONVENTION ON INFORMATION AND COMMUNICATION TECHNOLOGY, ELECTRONICS AND MICROELECTRONICS (MIPRO), 2017, : 1491 - 1495
  • [2] Data warehouse architecture and design
    Rifaie, Mohammad
    Kianmehr, Keivan
    Alhajj, Reda
    Ridleya, Mick J.
    PROCEEDINGS OF THE 2008 IEEE INTERNATIONAL CONFERENCE ON INFORMATION REUSE AND INTEGRATION, 2008, : 58 - +
  • [3] A survey: Data warehouse architecture
    Arif, Muhammad
    Mujtaba, Ghulam
    International Journal of Hybrid Information Technology, 2015, 8 (05): : 349 - 356
  • [4] Architecture for virtualization in data warehouse
    Nasir, J. A.
    Shahzad, M. Khurram
    INNOVATIONS AND ADVANCED TECHNIQUES IN COMPUTER AND INFORMATION SCIENCES AND ENGINEERING, 2007, : 243 - 248
  • [5] The IBM - Data warehouse architecture
    Bontempo, C
    Zagelow, G
    COMMUNICATIONS OF THE ACM, 1998, 41 (09) : 38 - 48
  • [6] A data warehouse architecture for clinical data warehousing
    Faculty of Information Technology, Queensland University of Technology, PO Box 2434, Brisbane 4001, QLD, Australia
    Conf. Res. Pract. Inf. Technol. Ser., 2007, (227-232):
  • [7] Architecture of a gene expression data warehouse
    Gangopadhyay, A
    INFORMATION TECHNOLOGY AND ORGANIZATIONS: TRENDS, ISSUES, CHALLENGES AND SOLUTIONS, VOLS 1 AND 2, 2003, : 331 - 331
  • [8] A new architecture for large data warehouse
    Li, Gang
    Qian, Xingsan
    Ye, Chunming
    RECENT TRENDS IN MATERIALS AND MECHANICAL ENGINEERING MATERIALS, MECHATRONICS AND AUTOMATION, PTS 1-3, 2011, 55-57 : 87 - 90
  • [9] BEST WAREHOUSE IS NO WAREHOUSE
    FOWLER, J
    BREWERS DIGEST, 1979, 54 (05): : 17 - 17
  • [10] Which bus architecture is best for you?
    Chesney, C
    EE-EVALUATION ENGINEERING, 1998, 37 (09): : 12 - +
12345