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 129
- Downloads 0
The system dynamics approach to combat modeling
Profile Cloning Detection in Online Social Networks
Due to the emergence of online social networks, the importance of privacy on the Internet has vitally increased. Thus, it is important to develop mechanisms that will prevent our hidden personal data from unauthorized ac...
Data Warehouse In Knowledge Management System
In this study has been characterized as the use of data warehouse in knowledge management systems. In the first part those systems are characterized. In details are characterized: evident and implicit knowledge, manner o...
Thing about some assuring interoperability of information and information technology systems conditions
In this article, starting from some popular descriptions of interoperability, was presented short discussion of this term according to proprieties of information and information technology systems. In the next step was d...
Symulator rozprzestrzeniania się złośliwego oprogramowania w sieciach komputerowych
Wyraźny wzrost zainteresowania systemami dających się modelować z wykorzystaniem teorii grafów i sieci jest spowodowany rosnącym znaczeniem rzeczywistych sieci wielkiej skali. Badania niezawodności i odporności tych syst...