The Use of Column-Based DBMSS to Form Multidimensional Data Structures
The work is devoted to the analysis of the method of designing information systems using the “Data vault” modeling technology. The described approach can be used when building a data warehouse within a multidimensional information system based on the classical approach of data warehouse design – a 3...
Saved in:
| Main Authors: | , |
|---|---|
| Format: | Article |
| Language: | Russian |
| Published: |
The Fund for Promotion of Internet media, IT education, human development «League Internet Media»
2023-10-01
|
| Series: | Современные информационные технологии и IT-образование |
| Subjects: | |
| Online Access: | http://sitito.cs.msu.ru/index.php/SITITO/article/view/995 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1849770314287808512 |
|---|---|
| author | Dmitry Kunitsky Maxim Fomin |
| author_facet | Dmitry Kunitsky Maxim Fomin |
| author_sort | Dmitry Kunitsky |
| collection | DOAJ |
| description | The work is devoted to the analysis of the method of designing information systems using the “Data vault” modeling technology. The described approach can be used when building a data warehouse within a multidimensional information system based on the classical approach of data warehouse design – a 3-level data representation architecture, which includes data preparation area, or operational data warehouse, data warehouse, and thematic data marts. This approach allows you to organize data storage within a data warehouse using a metadata repository based on the multidimensional approach. The metadata repository is responsible for the process of collecting data, storing data, and presenting data for analysis. The “Data vault” approach allows you to design the data warehouse of an information system based on a metamodel that is semantically related to the domain of the system and is easily rebuilt it in the event of changes in the business model of the domain. When describing a metamodel, the first-order predicate calculus language is used, which makes it possible to control the metamodel using a declarative programming style – the “Prolog” language. The key point in the structure of the information system is the way of transition from the “Data vault” model to a multidimensional model of data representation based on associative rules of dependence between information objects. |
| format | Article |
| id | doaj-art-de341c7f414a4d459eaf725508b3f55d |
| institution | DOAJ |
| issn | 2411-1473 |
| language | Russian |
| publishDate | 2023-10-01 |
| publisher | The Fund for Promotion of Internet media, IT education, human development «League Internet Media» |
| record_format | Article |
| series | Современные информационные технологии и IT-образование |
| spelling | doaj-art-de341c7f414a4d459eaf725508b3f55d2025-08-20T03:03:04ZrusThe Fund for Promotion of Internet media, IT education, human development «League Internet Media»Современные информационные технологии и IT-образование2411-14732023-10-0119360761310.25559/SITITO.019.202303.607-613The Use of Column-Based DBMSS to Form Multidimensional Data StructuresDmitry Kunitsky0https://orcid.org/0009-0005-8899-3055Maxim Fomin1https://orcid.org/0000-0002-7924-9743Peoples’ Friendship University of Russia named after Patrice Lumumba, Moscow, RussiaPeoples’ Friendship University of Russia named after Patrice Lumumba, Moscow, RussiaThe work is devoted to the analysis of the method of designing information systems using the “Data vault” modeling technology. The described approach can be used when building a data warehouse within a multidimensional information system based on the classical approach of data warehouse design – a 3-level data representation architecture, which includes data preparation area, or operational data warehouse, data warehouse, and thematic data marts. This approach allows you to organize data storage within a data warehouse using a metadata repository based on the multidimensional approach. The metadata repository is responsible for the process of collecting data, storing data, and presenting data for analysis. The “Data vault” approach allows you to design the data warehouse of an information system based on a metamodel that is semantically related to the domain of the system and is easily rebuilt it in the event of changes in the business model of the domain. When describing a metamodel, the first-order predicate calculus language is used, which makes it possible to control the metamodel using a declarative programming style – the “Prolog” language. The key point in the structure of the information system is the way of transition from the “Data vault” model to a multidimensional model of data representation based on associative rules of dependence between information objects.http://sitito.cs.msu.ru/index.php/SITITO/article/view/995data warehousemultidimensional data modeldata martolapcolumn-based dbms |
| spellingShingle | Dmitry Kunitsky Maxim Fomin The Use of Column-Based DBMSS to Form Multidimensional Data Structures Современные информационные технологии и IT-образование data warehouse multidimensional data model data mart olap column-based dbms |
| title | The Use of Column-Based DBMSS to Form Multidimensional Data Structures |
| title_full | The Use of Column-Based DBMSS to Form Multidimensional Data Structures |
| title_fullStr | The Use of Column-Based DBMSS to Form Multidimensional Data Structures |
| title_full_unstemmed | The Use of Column-Based DBMSS to Form Multidimensional Data Structures |
| title_short | The Use of Column-Based DBMSS to Form Multidimensional Data Structures |
| title_sort | use of column based dbmss to form multidimensional data structures |
| topic | data warehouse multidimensional data model data mart olap column-based dbms |
| url | http://sitito.cs.msu.ru/index.php/SITITO/article/view/995 |
| work_keys_str_mv | AT dmitrykunitsky theuseofcolumnbaseddbmsstoformmultidimensionaldatastructures AT maximfomin theuseofcolumnbaseddbmsstoformmultidimensionaldatastructures AT dmitrykunitsky useofcolumnbaseddbmsstoformmultidimensionaldatastructures AT maximfomin useofcolumnbaseddbmsstoformmultidimensionaldatastructures |