Skoči na glavni sadržaj

Izvorni znanstveni članak

https://doi.org/10.2498/cit.2002.02.01

A Procedure of Conversion of Relational into Multidimensional Database Schema

Mladen Varga


Puni tekst: engleski pdf 754 Kb

str. 69-84

preuzimanja: 3.367

citiraj


Sažetak

It is universally recognized that operational information systems lean on the relational model and datawarehouses on the multidimensional model. The phrase On-Line Analytical Processing (OLAP) means summarizing, consolidating, viewing, and synthesizing data according to multiple dimensions. The process of modeling data warehouse may start from operational system’s database. It may be helpful to convert a relational database schema into a multidimensional database schema in order to discover dimensions that are hidden in a relational database. However, only a few efforts have been done investigating the conversion of relational into multidimensional database schema. This paper proposes the general procedure of such a conversion. The procedure can be partly automated because some decisions of attribute type must be made during conversion.

Ključne riječi

Hrčak ID:

44786

URI

https://hrcak.srce.hr/44786

Datum izdavanja:

30.6.2002.

Posjeta: 4.087 *