Automated data warehousing for rule-based CRM systems

Authors:
Han-joon Kim;TaeHee Lee;Sang-goo Lee;Jonghun Chun
Affiliations:
School of Computer Science and Engineering, Seoul National University, San 56-1 Shillim-Dong Kwanak-ku, Seoul, 151-742 Korea;School of Computer Science and Engineering, Seoul National University, San 56-1 Shillim-Dong Kwanak-ku, Seoul, 151-742 Korea;School of Computer Science and Engineering, Seoul National University, San 56-1 Shillim-Dong Kwanak-ku, Seoul, 151-742 Korea;School of Computer Science and Engineering, Seoul National University, San 56-1 Shillim-Dong Kwanak-ku, Seoul, 151-742 Korea
Venue:
ADC '03 Proceedings of the 14th Australasian database conference - Volume 17
Year:
2003

Citing 5
Cited 6

Materialized Views Selection in a Multidimensional Database

VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Materialized View Selection for Multidimensional Datasets

VLDB '98 Proceedings of the 24rd International Conference on Very Large Data Bases
Automated Selection of Materialized Views and Indexes in SQL Databases

VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
A Formal Perspective on the View Selection Problem

Proceedings of the 27th International Conference on Very Large Data Bases
Data Warehouse Configuration

VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases

A grain preservation translation algorithm: From ER diagram to multidimensional model

Information Sciences: an International Journal
A user-driven data warehouse evolution approach for concurrent personalized analysis needs

Integrated Computer-Aided Engineering
From conceptual models to schemata: An object-process-based data warehouse construction method

Information Systems
The effects of data mining in ERP-CRM model: a case study of MADAR

WSEAS Transactions on Computers
A Knowledge-driven Data Warehouse Model for Analysis Evolution

Proceedings of the 2006 conference on Leading the Web in Concurrent Engineering: Next Generation Concurrent Engineering
A rule-based data warehouse model

BNCOD'06 Proceedings of the 23rd British National Conference on Databases, conference on Flexible and Efficient Information Handling

Quantified Score

Hi-index	0.00

Visualization

Abstract

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-WHEN 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 proposed 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.