基于数据仓库的库存分析应用架构

在数据仓库项目实际开发时,由于要分析的历史性数据量非常庞大,如何有效提高系统性能是关注的焦点,其中着重要解决数据增量更新与预计算之间的矛盾,此外,一般数据分析系统只能对历史性数据分析和预测,而在实际需求中可能需要对实时数据进行分析。本文以广东某集团公司信息系统建设为研究背景,以钢材库存分析为主题,提出一种高性能数据仓库架构,有效解决以上矛盾,具有较好应用价值。

The Application Architecture of Inventory Analysis Based on Data Warehouse

Due to the vast historical data to analyze,how to effectively improve the system performance of the data warehouse is on the focus in actual project development,which should solve the contradiction between the data incremental update and the data pre-computed.Furthermore,only historical data is analyzed and forecasted in the typical data analysis system,the real-time data may be required to analyze in actual demand,the high-performance data warehouse architecture taking steel inventory as subject,regarding the building of some Guangdong Corporation information systems as the research background,is proposed in this paper to effectively address above contradictions,which owns better application value.