企业营销管理系统中数据仓库的设计与构建

The Design and the Construction of Data Warehouse in the Enterprise Marketing Management System

通过对企业营销管理的需求进行调研,设计并完成了基于数据仓库的企业营销管理系统,分析了其与传统数据库的区别和联系;介绍了企业营销管理系统中数据仓库的设计及构建过程。结合需求分析情况,创建了雪花型模型的数据仓库,构建了销售主题、人力资源主题、广告促销主题和销售计划主题四个主题,然后通过数据抽取、转换等手段,将信息从原始数据库装载到数据仓库之中。

Through the research about the need for enterprise marketing management,this paper designs the enterprise marketing management system based on data warehouse,analyzes its difference and similarity with traditional database,and introduced the design and building process of data warehouse in enterprise marketing management system. Combined with the demand analysis,it creates a snowflake model of data warehouse,builds four themes of marketing theme,human resources theme,advertising sales promotion theme,sales planning theme. And then through the data extraction,the information from the original database was loaded into the data warehouse.