Denormalization strategies for data retrieval from data warehouses

Authors:
Seung Kyoon Shin;G. Lawrence Sanders
Affiliations:
College of Business Administration, University of Rhode Island, Kingston, RI;Department of Management Science and Systems, School of Management, State University of New York at Buffalo, Buffalo, NY
Venue:
Decision Support Systems
Year:
2006

Citing 30
Cited 5

Vertical partitioning algorithms for database design

ACM Transactions on Database Systems (TODS)
Objects and events

Datamation
Physical database design for relational databases

ACM Transactions on Database Systems (TODS)
Misconceptions About Real-Time Computing: A Serious Problem for Next-Generation Systems

Computer
Information engineering for the practitioner: putting theory into practice

Information engineering for the practitioner: putting theory into practice
Sensitivity of the physical database design to changes in underlying factors

Information and Management
Vertical partitioning for database design: a graphical algorithm

SIGMOD '89 Proceedings of the 1989 ACM SIGMOD international conference on Management of data
Integrating a knowledge-based component into a physical database design system

Information and Management
Conceptual schema and relational database design: a fact oriented approach

Conceptual schema and relational database design: a fact oriented approach
Economic incentives for database normalization

Information Processing and Management: an International Journal
Breaking all the rules: an insider's guide to practical normalization

Data Based Advisor
Pre-physical data base design heuristics

Information and Management
Justifying database normalization: a cost/benefit model

Information Processing and Management: an International Journal
Building a data warehouse for decision support

Building a data warehouse for decision support
Building the data warehouse (2nd ed.)

Building the data warehouse (2nd ed.)
Data clustering for effective mapping of object models to relational models

Journal of Database Management
Secure statistical databases with random sample queries

ACM Transactions on Database Systems (TODS)
Security of statistical databases: multidimensional transformation

ACM Transactions on Database Systems (TODS)
Techniques for Structuring Database Records

ACM Computing Surveys (CSUR)
A relational model of data for large shared data banks

Communications of the ACM
Data Modeling

Data Modeling
Planning and Designing the Data Warehouse

Planning and Designing the Data Warehouse
Fundamentals of Database Systems

Fundamentals of Database Systems
Modern Database Management

Modern Database Management
Temporal Data Management

IEEE Transactions on Knowledge and Data Engineering
Spatial Join Indices

Proceedings of the Seventh International Conference on Data Engineering
Modifications of Uncertain Data: A Bayesian Framework for Belief Revision

Information Systems Research
A Conceptual Model and Algebra for On-Line Analytical Processing in Decision Support Databases

Information Systems Research
An Evaluation of Self-Organizing Map Networks as a Robust Alternative to Factor Analysis in Data Mining Applications

Information Systems Research
Introduction to Database Systems

Introduction to Database Systems

Service-oriented data denormalization for scalable web applications

Proceedings of the 17th international conference on World Wide Web
Optimizing the data warehouse design by hierarchical denormalizing

ACS'08 Proceedings of the 8th conference on Applied computer scince
Data warehouse design on the basis of Hierarchical Degenerate Snowflake (HDS)

International Journal of Business Intelligence and Data Mining
Constructing a data accessing layer for in-memory data grid

Proceedings of the Fourth Asia-Pacific Symposium on Internetware
Detecting summarizability in OLAP

Data & Knowledge Engineering

Quantified Score

Hi-index	0.00

Visualization

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.