DocumentCode :
718691
Title :
Technology of separate formation of multidimensional data with lists of measure values
Author :
Zykin, Sergey ; Mosin, Sergey ; Poluyanov, Andrey
Author_Institution :
Sobolev Inst. of Math., Omsk, Russia
fYear :
2015
fDate :
21-23 May 2015
Firstpage :
1
Lastpage :
11
Abstract :
The aim of this paper is to study Hypercube building from relational database using separate specification of dimensions and measures. We don´t require any transformation of the initial Database schema, even to the hierarchical model; that allows us to apply this technology without modification of existing databases and their applications. Also we don´t force the dimensions to functionally determine measures. In this case, providing data integrity becomes more complicated, but in exchange we get the ability to use non-key attributes as dimensions. Furthermore, we can store a list of homogeneous values in a single cell. We present a formal definition of source and target data representation. The hypercube building algorithm is based on a sequence of intermodel mappings. Hypercube integrity is achieved by using an intermediate representation, called Table of Joins (TJ). This approach is the development of traditional OLAP technology.
Keywords :
data integrity; data mining; data structures; relational databases; OLAP technology; TJ; data integrity; database schema; hypercube building algorithm; hypercube integrity; intermodel mappings; measure values; nonkey attributes; relational database; separate multidimensional data formation; source data representation; table of joins; target data representation; Algorithm design and analysis; Buildings; Context; Data analysis; Data models; Databases; Hypercubes; OLAP; hypercube; relational database;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Control and Communications (SIBCON), 2015 International Siberian Conference on
Conference_Location :
Omsk
Print_ISBN :
978-1-4799-7102-2
Type :
conf
DOI :
10.1109/SIBCON.2015.7147176
Filename :
7147176
Link To Document :
بازگشت