高级检索

    OLAP性能测试方法研究与实现

    Study and Implementation of OLAP Performance Benchmark

    • 摘要: 随着商业智能市场的逐步扩大,联机分析处理(OLAP)系统的使用质量评估已经成为数据库应用的研究热点.作为效用特性的OLAP系统性能评估需要一个性能基准.以OLAP委员会推出的APB-1性能基准为基础,首先设计了面向多维数据库的立方体(Cube)模型以及相应的多维表达式(MDX)查询模板,在Cube模型设计的过程中修改了APB-1基准ROLAP星型模型的不足之处;接着在测试数据一致和测试参数一致的前提下,通过对设计的MOLAP模型查询结果与ROLAP模型查询结果进行对比分析,证明了MOLAP模型及MDX查询模板设计的正确性;然后给出了OLAP性能测试流程,描述了支持ROLAP和MOLAP性能测试的工具框架及其主要模块.最后使用该测试框架在商业数据库管理系统上对ROLAP和MOLAP进行并发查询实践,验证了框架的有效性.提出的方法及技术实现为未来OLAP产品性能的测试和评价提供多维数据模型、业务模型和工具的支持.

       

      Abstract: With the expansion of business intelligence (BI) market, usability evaluation of on-line analytical processing (OLAP) systems has become a hot issue in database industries. How to measure the performance of OLAP systems is an important efficiency aspect that needs to be resolved with an OLAP performance benchmark. This paper presents a unified testing approach for efficiency evaluation of both ROLAP and MOLAP implementation systems based on the APB-1 benchmark introduced by OLAP committee. Firstly, an adequate cube model for MOLAP systems and the corresponding MDX query templates for APB-1 benchmark have been proposed, in which the shortcomings of APB-1 benchmark and their ROLAP star model are discussed during the cube model designing process. Then, experimental results come from new MOLAP model and ROLAP model implementation are compared under the same testing dataset and parameters in order to validate the accuracy of MOLAP model and the design correctness of MDX query templates. At last, according to the purpose of performance comparisons of OLAP systems, the OLAP performance testing procedure and its testing implementation framework for ROLAPMOLAP systems are proposed, in which various modules are explained, and a set of parallel queries has been tested on commercial DBMSs to verify the effectiveness of this framework. The achievement of this study will provide the technical and implemental supports for the performance testing of ROLAPMOLAP products.

       

    /

    返回文章
    返回