The design and application of data warehouse during modern enterprises environment
The design and application of data warehouse during modern enterprises environment
复制标题
DOI：
10.1117/12.660005
复制
发表时间：
2006-04
影响因子：
2
通讯作者：
Lijuan Zhou;Chi Liu;Chunying Wang
中科院分区：
文献类型：
--
作者：
Lijuan Zhou;Chi Liu;Chunying Wang
近年来，对数据分析的兴趣大大增加。为了分析数据，需要多种技术，即数据仓库、数据挖掘、联机分析处理（OLAP）等领域的技术。根据企业的信息需求和用户的实际需求，提出了现代企业环境下数据仓库的体系结构模型，分析了这种模型在实际应用中的效益，并给出了数据仓库模型的建立过程。同时提出了现代企业数据仓库的总体设计方案。我们在实际应用中建立的数据仓库可以提供：查询的高性能;数据的高效性;逻辑数据和物理数据的独立性。此外，数据仓库包含了大量的物化视图的数据提供的分布式异构数据库的目的，有效地实现决策支持，联机分析处理查询或数据挖掘。数据仓库设计中最重要的决策之一就是选择合适的物化视图。在本文中，我们还设计了在数据仓库中选择要物化的视图集的算法。然后我们用实验来证明我们的方法的力量。结果表明，该算法提供了一个最优的解决方案。最后，我们讨论了我们的方法和未来的工作的优点和不足。
The interest in analyzing data has grown tremendously in recent years. To analyze data, a multitude of technologies is need, namely technologies from the fields of Data Warehouse, Data Mining, On-line Analytical Processing (OLAP). This paper proposes the system structure model of the data warehouse during modern enterprises environment according to the information demand for enterprises and the actual demand of user's, and also analyses the benefit of this kind of model in practical application, and provides the setting-up course of the data warehouse model. At the same time it has proposes the total design plans of the data warehouses of modern enterprises. The data warehouse that we build in practical application can be offered: high performance of queries; efficiency of the data; independent characteristic of logical and physical data. In addition, A Data Warehouse contains lots of materialized views over the data provided by the distributed heterogeneous databases for the purpose of efficiently implementing decision-support, OLAP queries or data mining. One of the most important decisions in designing a data warehouse is selection of right views to be materialized. In this paper, we also have designed algorithms for selecting a set of views to be materialized in a data warehouse.First, we give the algorithms for selecting materialized views. Then we use experiments do demonstrate the power of our approach. The results show the proposed algorithm delivers an optimal solution. Finally, we discuss the advantage and shortcoming of our approach and future work.