Conferences in Research and Practice in Information Technology
  

Online Version - Last Updated - 20 Jan 2012

 

 
Home
 

 
Procedures and Resources for Authors

 
Information and Resources for Volume Editors
 

 
Orders and Subscriptions
 

 
Published Articles

 
Upcoming Volumes
 

 
Contact Us
 

 
Useful External Links
 

 
CRPIT Site Search
 
    

We wish you a happy and safe holiday season and all the best for 2025


Automated Data Warehousing for Rule-based CRM Systems

Kim, H.-j., Lee, T., Lee, S.-g. and Chun, J.

    This paper proposes a novel way of automatically developing data warehouse configuration in rule-based CRM systems. Rule-based CRM systems assume that marketing activities are represented as a set of IF-THEN rules. Currently, to provide good quality CRM functionalities, CRM systems seek to combine conventional CRM methodologies with data warehousing technology. A data warehouse can be abstractly seen as a set of materialized views. Selecting views for materialization in a data warehouse is one of the important decision-making tasks in its design. However, there are few facilities in CRM systems with respect to data warehouse design that alleviate the problems associated with data schema maintenance. Given a set of campaign rules expressing marketing strategies, the pro- posed method generates data warehouse configuration (including database schema and indexing constraint) that can satisfy all the input rules. Our method begins on the premise that data warehouse configuration can be reversibly extracted from marketing campaign rules. This method includes algorithms for database schema generation, indexing constraint generation, schema normalization for removing data redundancies, and OLAP (On-Line Analytic Processing) query generation.
Cite as: Kim, H.-j., Lee, T., Lee, S.-g. and Chun, J. (2003). Automated Data Warehousing for Rule-based CRM Systems. In Proc. Fourteenth Australasian Database Conference (ADC2003), Adelaide, Australia. CRPIT, 17. Schewe, K.-D. and Zhou, X., Eds. ACS. 67-73.
pdf (from crpit.com) pdf (local if available) BibTeX EndNote GS
 

 

ACS Logo© Copyright Australian Computer Society Inc. 2001-2014.
Comments should be sent to the webmaster at crpit@scem.uws.edu.au.
This page last updated 16 Nov 2007