Conceptual design of DVR from graph model Paisarn Trakulsuk, Vichit Avatchanakorn.

Abstract EN

The Multidimensional cube for OLAP (On-line Analytical Processing) is composed of dimensions, data value or Variable, and relative dimensions (DVR), the basic components of a Mltidimensional Data Model (MDD).

The model shows how to provide data support intelligence through multidimensional data analysis when there are huge amounts of online data.

This paper presents a conceptual design of data analysis from a data warehouse into DVR.

The design is a graph model of data catalogs that generate the DVR forms of a multidimensional cube.

The graph structure’s center node represents the fastest varying dimension, several branch nodes representing associate dimension attributes, and rectangles representing indexing of data values and measurements.

These may also be represented on fact schemes that integrate relative and external sources, as well as extends the algorithms to build DVR pattens in standard SQL form.

This model show's how workload is reduced and expresses the input-output design phase of MDD.-