ePrints.FRI - University of Ljubljana, Faculty of Computer and Information Science

Optimizing performance of OLAP systems built with MS Analysis Services 2005

Matevž Grbec (2010) Optimizing performance of OLAP systems built with MS Analysis Services 2005. EngD thesis.

[img] PDF
Download (3136Kb)


    This work covers optimization of OLAP systems. In the beginning we define terms of business intelligence and OLAP systems which purpose is to support making effective decisions in organizations. The core of this work is a description of possible methods for improvement of processing and querying times in OLAP systems built with the product SQL Server Analysis Services 2005. There are many different optimization methods and we arranged them into the following fields: data warehouse, design of the data cube, querying performance, processing performance, special designs, server settings and hardware. The goal of this work is to test and assess individual optimization methods. For each method we are interested in the amount of possible performance improvement. Finally we would like to find out which methods are the most effective. We tested our optimization methods on the real data from a Slovenian company. After each optimization step we measured processing time and time required to get results from the test queries. At the end we analyze the results and give final findings and recommendations.

    Item Type: Thesis (EngD thesis)
    Keywords: optimization, OLAP system, Microsoft SQL Analysis Services 2005, MDX query
    Number of Pages: 98
    Language of Content: Slovenian
    Mentor / Comentors:
    Name and SurnameIDFunction
    izr. prof. dr. Marko Bajec245Mentor
    Link to COBISS: http://www.cobiss.si/scripts/cobiss?command=search&base=50070&select=(ID=8028244)
    Institution: University of Ljubljana
    Department: Faculty of Computer and Information Science
    Item ID: 1213
    Date Deposited: 28 Oct 2010 12:38
    Last Modified: 13 Aug 2011 00:38
    URI: http://eprints.fri.uni-lj.si/id/eprint/1213

    Actions (login required)

    View Item