论文部分内容阅读
通过对企业营销管理的需求进行调研,设计并完成了基于数据仓库的企业营销管理系统,分析了其与传统数据库的区别和联系;介绍了企业营销管理系统中数据仓库的设计及构建过程。结合需求分析情况,创建了雪花型模型的数据仓库,构建了销售主题、人力资源主题、广告促销主题和销售计划主题四个主题,然后通过数据抽取、转换等手段,将信息从原始数据库装载到数据仓库之中。
Through the research on the demand of enterprise marketing management, we designed and completed the enterprise marketing management system based on data warehouse, analyzed the difference and connection with traditional database, and introduced the design and construction process of data warehouse in enterprise marketing management system. According to the demand analysis, we created the data warehouse of snowflake model, constructed four themes of sales theme, human resources theme, advertising promotion theme and sales plan theme, and then loaded the information from the original database Among the data warehouse.