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 121
- Downloads 0
Data Visualization While Determining Similarities of Medical Patterns
The article presents the concept of using the theory of similarity in the recognition of medical patterns. The aim of the work is to construct a graphical model of disease entity pattern and the state of the patient's he...
Model sterowania procesem ubywania
Rank thresholds in classifier ensembles in medical diagnosis
Classification methods have multiple applications, with medical diagnosis being one of the most common. A powerful way to improve classification quality is to combine single classifiers into an ensemble. One of the appro...
Presorting as a method of acceleration of algorithms in multi-objective optimization problems
The paper presents a method of algorithms acceleration for determining Pareto-optimal solutions (Pareto Front) multi-criteria optimization tasks, consisting of pre-ordering (presorting) set of feasible solutions. It is p...
Metoda analizy ruchu drogowego na podstawie zachowania użytkowników sieci telefonii komórkowej
Artykuł ten poświęcony jest możliwości wykorzystania informacji o przemieszczaniu się użytkowników sieci telefonii komórkowej do analizy sytuacji na drogach objętych zasięgiem tej sieci.W pracy przedstawiony został forma...