Reference Hub13
Data Warehouse Design to Support Customer Relationship Management Analysis

Data Warehouse Design to Support Customer Relationship Management Analysis

Colleen Cunningham, Il-Yeol Song, Peter P. Chen
Copyright: © 2006 |Volume: 17 |Issue: 2 |Pages: 23
ISSN: 1063-8016|EISSN: 1533-8010|ISSN: 1063-8016|EISBN13: 9781615200504|EISSN: 1533-8010|DOI: 10.4018/jdm.2006040104
Cite Article Cite Article

MLA

Cunningham, Colleen, et al. "Data Warehouse Design to Support Customer Relationship Management Analysis." JDM vol.17, no.2 2006: pp.62-84. http://doi.org/10.4018/jdm.2006040104

APA

Cunningham, C., Song, I., & Chen, P. P. (2006). Data Warehouse Design to Support Customer Relationship Management Analysis. Journal of Database Management (JDM), 17(2), 62-84. http://doi.org/10.4018/jdm.2006040104

Chicago

Cunningham, Colleen, Il-Yeol Song, and Peter P. Chen. "Data Warehouse Design to Support Customer Relationship Management Analysis," Journal of Database Management (JDM) 17, no.2: 62-84. http://doi.org/10.4018/jdm.2006040104

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

CRM is a strategy that integrates concepts of knowledge management, data mining, and data warehousing in order to support an organization’s decision-making process to retain long-term and profitable relationships with its customers. This research is part of a long-term study to examine systematically CRM factors that affect design decisions for CRM data warehouses in order to build a taxonomy of CRM analyses and to determine the impact of those analyses on CRM data warehousing design decisions. This article presents the design implications that CRM poses to data warehousing and then proposes a robust multidimensional starter model that supports CRM analyses. Additional research contributions include the introduction of two new measures, percent success ratio and CRM suitability ratio by which CRM models can be evaluated, the identification of and classification of CRM queries, and a preliminary heuristic for designing data warehouses to support CRM analyses.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.