Denormalization strategies for data retrieval from data warehouses

被引：27
|
作者：
Shin, Seung Kyoon
Sanders, G. Lawrence
机构：
[1] Univ Rhode Isl, Coll Business Adm, Kingston, RI 02881 USA
[2] SUNY Buffalo, Sch Management, Dept Management Syst & Sci, Buffalo, NY 14260 USA
来源：
DECISION SUPPORT SYSTEMS | 2006年 / 42卷 / 01期
关键词：
database design; denormalization; decision support systems; data warehouse; data mining;
D O I：
10.1016/j.dss.2004.12.004
中图分类号：
TP18 [人工智能理论];
学科分类号：
081104 ; 0812 ; 0835 ; 1405 ;
摘要：
In this study, the effects of denormalization on relational database system performance are discussed in the context of using denormalization strategies as a database design methodology for data warehouses. Four prevalent denormalization strategies have been identified and examined under various scenarios to illustrate the conditions where they are most effective. The relational algebra, query trees, and join cost function are used to examine the effect on the performance of relational systems. The guidelines and analysis provided are sufficiently general and they can be applicable to a variety of databases, in particular to data warehouse implementations, for decision support systems. (c) 2004 Elsevier B.V All rights reserved.
引用
收藏
页码：267 / 282
页数：16
相关论文
共 50 条
  • [1] Private Cell Retrieval From Data Warehouses
    Yi, Xun
    Paulet, Russell
    Bertino, Elisa
    Xu, Guandong
    [J]. IEEE TRANSACTIONS ON INFORMATION FORENSICS AND SECURITY, 2016, 11 (06) : 1346 - 1361
  • [2] Spatial big data architecture: From Data Warehouses and Data Lakes to the LakeHouse
    Errami, Soukaina Ait
    Hajji, Hicham
    Kadi, Kenza Ait El
    Badir, Hassan
    [J]. JOURNAL OF PARALLEL AND DISTRIBUTED COMPUTING, 2023, 176 (70-79) : 70 - 79
  • [3] Assessing the quality of data in data warehouses
    不详
    [J]. HAZARDOUS WASTE CONSULTANT, 2002, 20 (03) : A13 - A15
  • [4] Augmenting Data Warehouses with Big Data
    Jukic, Nenad
    Sharma, Abhishek
    Nestorov, Svetlozar
    Jukic, Boris
    [J]. INFORMATION SYSTEMS MANAGEMENT, 2015, 32 (03) : 200 - 209
  • [5] Identifying data sources for data warehouses
    Koncilia, C
    Pozewaunig, H
    [J]. INTELLIGENT DATA ENGINEERING AND AUTOMATED LEARNING - IDEAL 2002, 2002, 2412 : 213 - 218
  • [6] Populating Data Warehouses with Semantic Data
    Nebot, V.
    Berlanga, R.
    [J]. IEEE LATIN AMERICA TRANSACTIONS, 2010, 8 (02) : 150 - 157
  • [7] Querying Compressed Data in Data Warehouses
    Anindya Datta
    Helen Thomas
    [J]. Information Technology and Management, 2002, 3 (4) : 353 - 386
  • [8] A FRAMEWORK FOR DATA CLEANING IN DATA WAREHOUSES
    Peng, Taoxin
    [J]. ICEIS 2008: PROCEEDINGS OF THE TENTH INTERNATIONAL CONFERENCE ON ENTERPRISE INFORMATION SYSTEMS, VOL DISI: DATABASES AND INFORMATION SYSTEMS INTEGRATION, 2008, : 473 - 478
  • [9] Designing data marts for data warehouses
    Bonifati, A
    Cattaneo, F
    Ceri, S
    Fuggetta, A
    Paraboschi, S
    [J]. ACM TRANSACTIONS ON SOFTWARE ENGINEERING AND METHODOLOGY, 2001, 10 (04) : 452 - 483
  • [10] Data mining and data warehouses - An overview
    Gray, P
    [J]. ASSOCIATION FOR INFORMATION SYSTEMS PROCEEDING OF THE AMERICAS CONFERENCE ON INFORMATION SYSTEMS, 1997, : 857 - 859
12345