...
  • 主题
高级搜索  >
历史搜索 清空历史
首页> 外文期刊>WSEAS Transactions on Computers >The Design of Multidimensional Data Model Using Principles of the Anchor Data Modeling: An Assessment of Experimental Approach Based on Query Execution Performance
【24h】

The Design of Multidimensional Data Model Using Principles of the Anchor Data Modeling: An Assessment of Experimental Approach Based on Query Execution Performance

机译：利用锚定数据建模原理设计多维数据模型：基于查询执行性能的实验方法评估

获取原文
获取原文并翻译 | 示例
           
页面导航
  • 摘要
  • 著录项
  • 相似文献
  • 相关主题

摘要

The decision making processes need to reflect changes in the business world in a multidimensional way. This includes also similar way of viewing the data for carrying out key decisions that ensure competitiveness of the business. In this paper we focus on the Business Intelligence system as a main toolset that helps in carrying out complex decisions and which requires multidimensional view of data for this purpose. We propose a novel experimental approach to the design a multidimensional data model that uses principles of the anchor modeling technique. The proposed approach is expected to bring several benefits like better query execution performance, better support for temporal querying and several others. We provide assessment of this approach mainly from the query execution performance perspective in this paper. The emphasis is placed on the assessment of this technique as a potential innovative approach for the field of the data warehousing with some implicit principles that could make the process of the design, implementation and maintenance of the data warehouse more effective. The query performance testing was performed in the row-oriented database environment using a sample of 10 star queries executed in the environment of 10 sample multidimensional data models. The results show comparison of differences between results of query execution in the environment of the experimental "Anchor" schema and the traditional "Star" schema using statistical methods. The results show possible indications towards expected benefits of the proposed approach that embraces high level of normalization of the resulting database schema in contrast with the traditional approach that results mostly to the creation of a non-normalized database schema.
机译：决策过程需要以多维方式反映业务领域中的变化。这还包括查看数据的类似方法，以执行可确保业务竞争力的关键决策。在本文中，我们将商业智能系统作为主要工具集进行关注，该工具集有助于执行复杂的决策，并且为此需要多维数据视图。我们提出了一种新颖的实验方法来设计使用锚建模技术原理的多维数据模型。预期所提出的方法将带来一些好处，例如更好的查询执行性能，对时间查询的更好支持以及其他一些好处。我们主要从查询执行性能的角度对这种方法进行评估。重点放在对这种技术的评估上，该技术是数据仓库领域的一种潜在创新方法，具有一些隐含的原则，可以使数据仓库的设计，实施和维护过程更加有效。使用在10个示例多维数据模型的环境中执行的10个星形查询的示例，在面向行的数据库环境中执行了查询性能测试。结果显示使用统计方法比较实验“锚”模式和传统“星”模式环境中查询执行结果之间的差异。结果表明，与主要导致创建非标准化数据库模式的传统方法相比，该方法包含了对所得数据库模式进行高度标准化的拟议方法的预期收益的可能迹象。

著录项

相似文献

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

客服邮箱：kefu@zhangqiaokeyan.com

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

  • 客服微信

  • 服务号