ERM 数据仓库模式探讨

辽宁石油化工大学学报 ›› 2006, Vol. 26 ›› Issue (2): 66-70.

ERM 数据仓库模式探讨

刘　暘¹ , 何　川¹, 李　欣² , 龚晓艳³

1.辽宁石油化工大学计算机与通信工程学院, 辽宁抚顺113001;
2.中国石油抚顺石化分公司信息中心, 辽宁抚顺113006 ;
3 .抚顺市顺城职业技术中学, 辽宁抚顺113006

收稿日期:2006-03-13 出版日期:2006-02-25 发布日期:2006-02-25
作者简介:刘暘(1965 -), 男, 辽宁抚顺市, 副教授。

Discussion on the Schemata of ERM Data Warehouse

1 .School of Computer and Communication Engineering , Liaoning University of Petroleum & Chemical Technology , FushunLiaoning 113001, P .R .China ;
2 .In formation Center of PetroChina Fushun Branch , Fushun Liaoning 113006, P .R .China ;
3 .Shuncheng Technological Middle School of Fushun City , Fushun Liaoning 113006, P .R .China

Received:2006-03-13 Published:2006-02-25 Online:2006-02-25

摘要/Abstract

摘要： 　如果一个企业不是垄断经营, 市场上的大多数成员就不是它的客户。为了争取潜在的客户, 企业必须花费大量的时间和精力去了解和分析用户的行为。在传统的商务中, 这项工作更多的是凭直觉而非事实, 因为他们无法跟踪非客户的行为。但是, 在面向电子商务的数据仓库系统中, 可以利用点击流数据去了解和分析用户的行为, 通过聚合方法将用户活动连贯成为完整的用户访问历史, 并据此争取更多的客户, 更好地满足市场的需求。通过比较B2C 电子商务环境下CRM 和ERM 系统的不同, 探讨了ERM 数据仓库的模式, 其中包括可以记载所有用户活动的用户行为事实表、可能的基本数据维表和聚合数据维表, 同时探讨了在不同电子商务环境中ERM 数据仓库模式的改进方法。

关键词: 电子关系管理, 　客户关系管理, 　电子商务, 　数据仓库模式, 　点击流

Abstract:

　 If an enterprise does not monopolize the market , most members o n the market are not its customers.In order to attract the potential customers, enterprises must spend a large amount of time and energy on understanding and analyzing user' s behaviors. Among the traditional commercial affairs , it possibly depends on intuition but no t on facts, because they cannot trace the non -customer' s behavior .But in the ERM data warehouse systems of oriented e -commerce , user' s behaviors can be understood and analyzed through click -stream data .User' s activities can be linked to make a complete access history by using clustering methods. Depending on it , more customers are attracted and market requirements are satisfied better .Through comparing the difference between CRM system and ERM system in B2C environment , the schema of ERM data warehouse was discussed .The schema contains the user -behavior -fact table to record all activities of different users, the basic data dimensional tables and clustering data dimensional tables .An improved method of the schema of ERM data warehouse under the different E-commerce environments was also discussed.

Key words: 　ERM , 　C RM , 　E-commerce , 　Data warehouse schema , 　Click -stream

刘　暘, 何　川, 李　欣, 龚晓艳. ERM 数据仓库模式探讨[J]. 辽宁石油化工大学学报, 2006, 26(2): 66-70.

LIU Yang,HE Chuan,LI Xin,GONG Xiao -yan. Discussion on the Schemata of ERM Data Warehouse[J]. Journal of Liaoning Petrochemical University, 2006, 26(2): 66-70.