FIELD: information technology.
SUBSTANCE: invention relates to a method and system for automatic generating of a program code for an enterprise data warehouse. In the method, metadata are obtained that describe the configuration of data transformation mechanisms for loading them to the level of a detailed data storage layer and calculating data mart storefronts, data update template of the detailed data storage layer and data marts of the data storage are obtained, a program code for loading data into the detailed data storage layer is generated and for calculation the data marts based on the received metadata and the generated data update template, program code generated in the previous step is installed on the data storage medium to perform the downloads, metadata are reused to update the detailed data storage layer and data marts by making delta changes to the mentioned data update template in case of making changes to the problem statement or by switching data update templates in case of changing the relational database type to use the received data update template during the subsequent generation of the program code.
EFFECT: technical result is to manage the update of a data warehouse.
10 cl, 5 dwg, 1 tbl
| Title | Year | Author | Number |
|---|---|---|---|
| METHOD AND SYSTEM FOR AUTOMATED GENERATION AND FILLING OF DATA MARTS USING DECLARATION DESCRIPTION | 2022 |
|
RU2795902C1 |
| METHODS AND SYSTEMS FOR LOADING DATA INTO TEMPORAL DATA WAREHOUSE | 2012 |
|
RU2599538C2 |
| SYSTEM AND METHOD OF DETERMINING TRUST WHEN UPDATING LICENSED SOFTWARE | 2012 |
|
RU2495487C1 |
| METHOD AND SYSTEM FOR COMPLEX CONTROL OF BIG DATA | 2018 |
|
RU2690777C1 |
| ANTIVIRUS FOR STORAGE OF ELEMENTS | 2005 |
|
RU2393531C2 |
| SYSTEM AND METHOD OF MANAGING DATABASES (DBMS) | 2018 |
|
RU2704873C1 |
| SOFTWARE DEPLOYMENT AND MANAGEMENT SYSTEM AND METHOD FOR ITS WORK | 2020 |
|
RU2751215C1 |
| INFORMATION EXCHANGE METHOD BETWEEN DATABASES OF INFORMATION SYSTEMS AND SYSTEM TO THIS END | 2007 |
|
RU2351010C1 |
| METHOD OF INPUTTING DATA INTO DATABASE AND DEVICE THEREFOR | 2013 |
|
RU2569565C2 |
| METHOD FOR INFORMATION EXCHANGE BETWEEN DATABASESS OF INFO SYSTEMS AND SYSTEM FOR ITS IMPLEMENTATION | 2011 |
|
RU2447495C1 |
