Multi-objective optimization of multidimensional aggregates schema
Journal Title: Computer Science and Mathematical Modelling - Year 2009, Vol 0, Issue 4
Abstract
The most popular technology used to increase performance of large data warehouses is multidimensional aggregates computed from high-resolution data. Query-rewriting techniques allows significantly shorter user query response time, when comparing query evaluation on base tables in data warehouse and smaller in size aggregates. There are three key parameters of multidimensional schema - query response time, time needed to refresh data in the schema and disk space required for storage of multidimensional structures. In paper multicriteria optimization problem was formulated, in which data refresh time is a constraint, and the remaining two measures are objectives. As a result of multi-run single-objective task computations, Pareto-optimal set of points is shown. The satisfactory solution might be found based on a distance to ideal point.
Authors and Affiliations
Marcin Mazurek
Keywords
Related Articles
- EP ID EP63107
- DOI -
- Views 119
- Downloads 0
A multifaceted model for software reliability prediction during testing
Analysis of software reliability plays an important role in quality assurance plan realization during software development. By monitoring changes of evaluated reliability in relation to quality objectives it is possible...
Ensemble Methods for Improving Classification of Data Produced by Latent Dirichlet Allocation
Topic models are very popular methods of text analysis. The most popular algorithm for topic modelling is LDA (Latent Dirichlet Allocation). Recently, many new methods were proposed, that enable the usage of this model...
Zastosowanie metod wyznaczania przepływu w sieciach do planowania manewru wojsk
W artykule przedstawiono opis sposobu wykorzystania metod wyznaczania przepływu w sieciach do rozwiązania specyficznego problemu planowania manewru wojsk. Zdefiniowano model sieci formalnej, bazującej na danych z cyfrowe...
Obiektowe bazy danych – wybrane kierunki rozwoju
Systemy bazodanowe stanowią jedną z kluczowych gałęzi rozwoju współczesnych systemów informatycznych. Są one jednym z podstawowych elementów architektury i mają krytyczny wpływ na funkcjonowanie całości rozwiązań informa...
Evolutionary algorithms for Map of Attributes optimization