首页> 外文会议>Conference on Data Mining, Intrusion Detection, Information Assurance, and Data Networks Security >The design and application of data warehouse during modern enterprises environment
【24h】

The design and application of data warehouse during modern enterprises environment

机译:现代企业环境中数据仓库的设计与应用

获取原文

摘要

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.
机译:近年来,分析数据的兴趣非常大。为了分析数据,需要多种技术,即数据仓库,数据挖掘,在线分析处理(OLAP)领域的技术。本文提出了现代企业环境中数据仓库的系统结构模型,根据企业的信息需求和用户的实际需求,并在实际应用中分析了这种模型的益处,并提供了设置课程数据仓库模型。与此同时,它提出了现代企业数据仓库的总设计计划。我们在实际应用中构建的数据仓库可以提供:疑问表现很高;数据的效率;逻辑和物理数据的独立特征。此外,数据仓库包含由分布式异构数据库提供的数据提供的数据,以便有效地实现决策支持,OLAP查询或数据挖掘。设计数据仓库中最重要的决策是要实现的正确视图的选择。在本文中,我们还设计了用于在数据仓库中选择一组视图的设计算法。首先,我们提供了用于选择物化视图的算法。然后我们使用实验确实展示了我们方法的力量。结果显示所提出的算法提供最佳解决方案。最后,我们讨论了我们的方法和未来工作的优势和缺点。

著录项

相似文献

  • 外文文献
  • 中文文献
  • 专利
获取原文

客服邮箱:kefu@zhangqiaokeyan.com

京公网安备:11010802029741号 ICP备案号:京ICP备15016152号-6 六维联合信息科技 (北京) 有限公司©版权所有
  • 客服微信

  • 服务号