Data warehouse design to support customer relationship management analyses

Journal of Database Management

Volumn 17, Issue 2, 2006, Pages 62-84

  Cunningham, Colleen ^a   Song, Il Yeol ^a   Chen, Peter P ^b,c,d,e,f,g  

^a DREXEL UNIVERSITY   (United States)

^b LOUISIANA STATE UNIVERSITY   (United States)

^c Louisiana State University   (United States)

^d ACM

^e IEEE

^f AAA   (United States)

^g NSF Computer and Information Science and Engineering Directorate

Author keywords

Customer relationship management; Data architecture; Data modeling; Data models; Data schema; Data warehouse; Data warehousing; Database design; Database schema

Indexed keywords

CUSTOMER SATISFACTION; DATA MINING; DATA REDUCTION; DATA STRUCTURES; DECISION MAKING; HEURISTIC PROGRAMMING; PRODUCT DESIGN;

CUSTOMER RELATIONSHIP MANAGEMENT; DATA ARCHITECTURE; DATA MODELING; DATABASE DESIGN; DATABASE SCHEMA;

DATA WAREHOUSES;

EID: 33745621643     PISSN: 10638016     EISSN: 10638016     Source Type: Journal    
DOI: 10.4018/jdm.2006040104     Document Type: Conference Paper

References (23)

1. Allen, G. N., & March, S. T. (2003). Modeling temporal dynamics for business systems. Journal of Database Management, 14(3), 21-36.
2. Boon, O., Corbitt, B., & Parker, C. (2002, December 2-3). Conceptualising the requirements of CRM from an organizational perspective: A review of the literature. In Proceedings of 7th Australian Workshop on Requirements Engineering (AWRE2002), Melbourne, Australia.
3. Bose, R. (2002). Customer relationship management: Key components for IT success. Industrial Management & Data Systems, 102(2), 89-97.
4. Buttle, F. (1999). The S.C.O.P.E. of customer relationship management. International Journal of Customer Relationship Management, 1(4), 327-337.
5. Cunningham, C., Song, I-Y, Jung, J. T, & Chen, P. (2003, May 18-21). Design and research implications of customer relationship management on data warehousing and CRM decisions. In M. Khosrow-Pour (Ed.), Information Technology & Organizations: Trends, Issues, Challenges & Solutions, 2003 Information Resources Management Association International Conference (IRMA 2003) (pp. 82-85), Philadelphia, Pennsylvania, USA. Hershey, PA: Idea Group Publishing.
6. Dasu, T., Vesonder, G. T., & Wright, J. R. (2003, August 24-27). Data quality through knowledge engineering. In Proceedings of SIGKDD '03, Washington, DC.
7. Hawkes, V. A. (2000). The heart of the matter: The challenge of customer lifetime value. CRM Forum Resources, 13, 1-10.
8. Hwang, H., Jung, T., & Suh, E. (2004). An LTV model and customer segmentation based on customer value: A case study on the wireless telecommunication industry. Expert Systems with Applications, 26, 181-188.
9. Jain, D., & Singh, S. (2002). Customer lifetime value research in marketing: A review and future direction. Journal of Interactive Marketing, 16(2), 34-46.
10. Kale, S. H. (2004, September/October). CRM failure and the seven deadly sins. Marketing Management, 13(5), 42-46.
11. Kellen, V. (2002, March). CRM measurement frameworks. Retrieved July 1, 2002, from http://www.kellen.net/crmmeas.htm
12. Kim, W., Choi, B., Kim, S., & Lee, D. (2003). A taxonomy of dirty data. Data Mining and Knowledge Discovery, 7, 81-99.
13. Kimball, R., & Ross, M. (2002). The data warehouse toolkit (2nd ed.). New York: Wiley Computer Publishing.
14. Lee, Y. W., Pipino, L., Strong, D. M., & Wang, R. Y. (2004). Process-embedded data integrity. Journal of Database Management, 15(1), 87-103.
15. Massey, A. P., Montoya-Weiss, M. M., & Holcom, K. (2001). Re-engineering the customer relationship: Leveraging knowledge assets at IBM. Decision Support Systems, 32(2), 155-170.
16. Myron, D., & Ganeshram, R. (2002, July). The truth about CRM success & failure. CRM Magazine, 6(7). Retrieved July 1, 2002, from http://www.destinationcrm.com/articles/default.asp?ArticleID=2370
17. Panker, J. (2002, June). Are reports of CRM failure greatly exaggerated? SearchCRM.com. Retrieved July 1, 2002, from http://searchcrm.techtarget.com/ originalContent/0,289142,sid11_gci834332,00.html
18. Rosset, S., Neumann, E., Eick, U., & Vatnik, N. (2003). Customer lifetime value models for decision support. Data Mining and Knowledge Discovery, 7, 321-339.
19. Rust, R. T., Lemon, K. N., & Zeithaml, V. A. (2004). Return on marketing: Using customer equity to focus marketing strategy. Journal of Marketing, 68(1), 109-139.
20. Shankaranarayan, G., Ziad, M., & Wang, R. Y. (2003). Managing data quality in dynamic decision environments: An information product approach. Journal of Database Management, 14(4), 14-32.
21. Todman, C. (2001). Designing a data warehouse. Upper Saddle River, NJ: Prentice Hall.
22. Verhoef,P. C., & Donkers, B. (2001). Predicting customer potential value: An application in the insurance industry. Decision Support Systems, 32(2), 189-199.
23. Winer, R. S. (2001). A framework for customer relationship management. California Management Review, 43(4), 89-108.