Home // ICSEA 2017, The Twelfth International Conference on Software Engineering Advances // View article

A Benchmarking Criteria for the Evaluation of OLAP Tools

Authors:
Fiaz Majeed

Keywords: OLAP tool; evaluation criteria; parameters; benchmark; standardize

Abstract:
Generating queries on Online Analytical Processing (OLAP) tools for complex analysis is a difficult assignment for the novice users. To compose accurate OLAP queries for fulfilling demand, technical knowledge about schema and the data is required. This deficiency can be covered by providing an easy design for OLAP tool for the purpose of querying. In this paper, a scheme is proposed for comparison of the OLAP tools to identify easy and standardized aspects. For this purpose, seven parameters have been used which are interface, query, drill-down options, roll-up options, aggregation function support, data access and performance. For experimental analysis, two tools SQL Server and MicroStrategy Express have been evaluated based on the proposed parameters. The benefits and drawbacks of the standardization of tools for non-technical users have been identified.

Pages: 167 to 171

Copyright: Copyright (c) IARIA, 2017

Publication date: October 8, 2017

Published in: conference

ISSN: 2308-4235

ISBN: 978-1-61208-590-6

Location: Athens, Greece

Dates: from October 8, 2017 to October 12, 2017