企业数据仓库多维数据模型的建立

数据仓库是一种新的数据管理技术,能将企业内分散的原始操作型数据和来自外部的数据汇集和整理,为企业提供完整、及时和准确的决策信息。构建数据仓库系统的核心问题是如何建立复杂的企业数据模型。商务数据的本质是多维的,传统的ER模型已无法满足要求,而多维数据建模技术从维度、层次建模的角度有效地弥补了传统数据模型的不足。文章以多维数据建模技术为中心通过实例讨论了数据仓库中数据模型的一般建立方法,为解决构建企业信息系统提供了一种切实可行的方案。

Build Multi- dimensional Data Modeling on Enterprise Data Warehouse

Data warehouse is one kind of new datum administrative skill, will gather and clear up the scattered primitive operation type data and data come from the external in enterprises, offer the intact, prompt, accurate and obvious decision information for enterprise. The upgrading which made use of data warehouse technology to realize enterprise's information system has already become the tendency of the day. The key question of structuring the data warehouse system is how to set up complicated enterprise data model. The essence of the commercial data is multidimensional and the traditional ER model has been already unable to meet the demands, so the effective deficiency of remedying the traditional data model is in terms of linking degree, level modeling of modeling technology of the multidimensional data. The article has regarded modeling technology of the multidimensional data as the centre and discussed the general setting-up method of the data model in the data warehouse through the instance, moreover, have offered a kind of practical possible scheme for solving and structuring enterprise's information system.