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 132
- Downloads 0
Model procesu pokonywania wielostrefowej ochrony obiektu stacjonarnego przez intruza
W artykule rozpatruje się model procesu pokonywania wielostrefowej ochrony obiektu stacjonarnego (zabudowania wraz z przyległym terenem) przez pasywnego intruza zdeterminowanego, co oznacza intruza nie oddziałującego czy...
Applicability analysis of selected standards to architecture modelling of information system for health service
The article presents results of standards’ analysis BPMN, GELLO, UML, OCL, XML and HL7 in context of their applicability to software system architecture modelling. Mentioned standards are assessed from software system mo...
Enterprise architecture management method
In this article manner of enterprise architecture management was described. This approach encompasses software development methodology, fashion of description and tools support. Rational Unified Process (RUP) software de...
Concept of interoperability of clinical carepaths and the electronic health record systems conditions implementation
In contents of paper a description of requirements to the manner of the implementation of the nonvisual interface to systems of the type EHR (electronic health record) was described. That all was carried out as part of...
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...