Denormalization strategies for data retrieval from data warehouses

Denormalization strategies for data retrieval from data warehouses

0.00 Avg rating0 Votes
Article ID: iaor20072231
Country: Netherlands
Volume: 42
Issue: 1
Start Page Number: 267
End Page Number: 282
Publication Date: Oct 2006
Journal: Decision Support Systems
Authors: ,
Keywords: internet, datamining
Abstract:

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.

Reviews

Required fields are marked *. Your email address will not be published.