CASPIAN JOURNAL
MANAGEMENT AND HIGH TECHNOLOGIES
EXAMPLE OF THE TRANSFORMATION ALGORITHM OF DATA CUBE USING TRANSFORMATION MATRIX
 |
Read | Spanderashvili Dmitry V. EXAMPLE OF THE TRANSFORMATION ALGORITHM OF DATA CUBE USING TRANSFORMATION MATRIX // Caspian journal : management and high technologies. — 2011. — №3. — pp. 30-39. |
Spanderashvili Dmitry V. - Ph.D., Astrakhan State University, 20a Tatishchev str., Astrakhan, 414056, Russia, spanderashvili@gmail.com.
Over time, the multi-dimensional data structures can be changed. For a reliable analysis of the data it is necessary to track all changes in the structure and elements of the measurement. The article briefly gives a formal description of the mechanism of transformation of the data cube from one structure version to another one, in order to hold the analysis of data from the data cube that has undergone structural changes. The first part of the article describes the mechanism of transformation matrix to align the data cube to a given structural version, while the second part is an example of the transformation algorithm on test data. A formal description of temporal data warehousing mechanism is given shortly in the article. The premises of spatial-temporal data warehouse application are formulated, a formal description of spatial-temporal data warehouse is introduced, the mechanism of structural versions mapping formation is determined, the transformation matrices usage mechanism is described. As an example of the algorithm of transformation of the data cube from one version to another structure is considered a test case: you want to compare the data from data cube in a one structural version with the data from data cube structure of another version. Transformations are carried out the by the proposed method due to which such a comparison is possible.
Key words: multi-dimensional data structures,changes,data analysis,measurement,transformation,data cube,structure version,transformation matrix,transformation algorithm,spatial-temporal data.