摘要
以某企业的成本分析系统为依托,针对成本系统的数据特点,研究了企业业务数据的实际问题和需求,完成了源数据库中数据的ETL过程,并且根据业务要求创建了新的数据仓库,用开源的工具实现了联机分析处理模块,并且利用前端技术进行了数据的展现。
On the basis of the cost analysis system of a certain enterprise, the practical problems and demands of the enter- prise＇s business data are studied according to the data characteristics of the cost system. The data ETL process in the source da- tabase was accomplished, and a new data warehouse was established according to the business requirements. The on-line analysis processing module was realized with the open source tool, and the data was showed with the front-end technology.
出处
《现代电子技术》
北大核心
2016年第19期111-115,共5页
Modern Electronics Technique
基金
科技部2015年度国家星火计划项目:基于无线传感网络技术的农田信息采集系统(2015GA610011)
关键词
商业智能
数据仓库
OLAP
回归分析
成本分析
business intelligence
data warehouse
OLAP
regression analysis
cost analysis
