Selection of OLAP Materialized Cube by Using a Fruit Fly Optimization (FFO) Approach: A Multidimensional Data Model

The Online Analytical Processing (OLAP) based multidimensional examination hassles for several stockpiling magnificence over huge data. For as much to recognize queries answering time companionable by OLAP framework users and understanding entire business perceive mandatory, OLAP data is structured as a data cube (a multidimensional model). The OLAP queries are responded in speedy and steady time by utilizing the cube materialization for assessments takers. But, this also involves unendurable expenses, regarding to stockpile memory and period, and as a data depot, OLAP has an average dimension and dimensionality which is to be significant on query processing. Consequently, cube assortment has got to be finished motivating to diminish inquiry management expenses, maintaining as a restraint the materializing gap. Several techniques and heuristics like deviationist and insatiable algorithms have been utilized to offer an estimated result. In this work, a Fruit Fly Optimization (FFO) approach is implemented in a lattice structure to obtain an optimal materialized data cube for reducing the query processing expenses. The results illustrate that FFO generates better performance than Particle Swarm Optimization (PSO) in terms of frequency and number of dimensions.