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 条

[21] Architecture and Capabilities of a Data Warehouse for ATM Research
Eshow, Michelle
Lui, Max
Ranjan, Shubha
[J]. 2014 IEEE/AIAA 33RD DIGITAL AVIONICS SYSTEMS CONFERENCE (DASC), 2014,
[22] A Data warehouse within a Federated database architecture
Anand, VJ
[J]. ASSOCIATION FOR INFORMATION SYSTEMS PROCEEDING OF THE AMERICAS CONFERENCE ON INFORMATION SYSTEMS, 1997, : 458 - 460
[23] OPTIMAL DISTRIBUTED DATA WAREHOUSE SYSTEM ARCHITECTURE
Kashfi, Mehdi
Hajmoosaei, Abdolreza
[J]. 2014 IEEE FOURTH INTERNATIONAL CONFERENCE ON BIG DATA AND CLOUD COMPUTING (BDCLOUD), 2014, : 110 - 115
[24] Data warehouse integration using best fit matching
Holmes, D
Maxwell, D
[J]. IKE'03: PROCEEDINGS OF THE INTERNATIONAL CONFERENCE ON INFORMATION AND KNOWLEDGE ENGINEERING, VOLS 1 AND 2, 2003, : 177 - 181
[25] Classifying Numbers from EEG Data - Which Neural Network Architecture Performs Best?
Selvasingham, Sugeelan
Denecke, Kerstin
[J]. HEALTHCARE OF THE FUTURE 2022, 2022, 292 : 103 - 106
[26] Fast matching of astronomical data within data warehouse architecture
Zhang, Hailong
Wang, Na
Chen, Wu
Nie, Jun
[J]. ICIC Express Letters, 2014, 8 (10): : 2805 - 2811
[27] A Data Warehouse architecture for integrating field-based data
Salguero, Alberto
Araque, Francisco
Carrasco, Ramon
[J]. ICEIS 2007: PROCEEDINGS OF THE NINTH INTERNATIONAL CONFERENCE ON ENTERPRISE INFORMATION SYSTEMS: DATABASES AND INFORMATION SYSTEMS INTEGRATION, 2007, : 577 - 580
[28] Architecture of Urban Ecosystem Assessment based on Data Warehouse
Hu Fu-xiang
[J]. ENVIRONMENT MATERIALS AND ENVIRONMENT MANAGEMENT PTS 1-3, 2010, 113-116 : 593 - 597
[29] Key organizational factors in data warehouse architecture selection
Ariyachandra, Thilini
Watson, Hugh
[J]. DECISION SUPPORT SYSTEMS, 2010, 49 (02) : 200 - 212
[30] Integrated Architecture of Data Warehouse with Business Intelligence Technologies
ul Hassan, Ch Anwar
Irfan, Rizwana
Shah, Munam Ali
[J]. 2018 24TH IEEE INTERNATIONAL CONFERENCE ON AUTOMATION AND COMPUTING (ICAC' 18), 2018, : 259 - 264

← 1 2 3 4 5 →