面向商业OLAP的并行数据抽取接口设计

Frame of Parallel Data Extraction Interface for Commercial OLAP

商业竞争日趋激烈的今天,单纯的联机事务处理系统已经不能满足管理者的决策支持要求,联机分析处理(OLAP)技术的出现具有重要意义。研究了目前联机分析处理的关键技术,数据仓库的经典解决方案,数据预处理的相关方法,提出了一种面向商业OLAP的并行数据抽取接口设计方案,并对设计过程中的数据清理、数据集成和变换、数据归约等数据预处理技术作了重点介绍和应用研究。最后结合实际应用阐明了提出的数据抽取方案对于实现商业OLAP功能的有效性和实用性。

The OLTP system can not afford the demand of decision support due to the drastic commerce competition, so the appearance of OLAP technology is importanct. The key technical of OLAP, the classical resolvent of data warehouse and the methods of data preprocessing are studied. A frame of parallel data extraction interface for commercial OLAP is proposed. Data preprocessing technology (data cleaning, data integration and transform, data reduction) connected with the frame is practically studied and applied. The eficiency and the practicality of the frame are illustrated by practical application.