Topic
Data mart
About: Data mart is a research topic. Over the lifetime, 559 publications have been published within this topic receiving 8550 citations.
Papers published on a yearly basis
Papers
More filters
•
01 Jan 2002
TL;DR: In this article, the authors extend the MetaMIS approach to enable the specification of fact calculations in data mart environments, based on recent work on the so-called meta-mis approach.
Abstract: Based on recent work on the so called MetaMIS approach we show how fact calculations can be specified from a management point of view. The MetaMIS approach's intention is to specify management views on business processes. It comprises a language, a representation formalism and guidelines to define information required for management decisions. Information in general should have pragmatic meaning for the management user. Beyond the task of specifying information in this sense, fact calculations are required to manipulate information. Respective analyzing tasks typically deal with variances, growth rates and other relevant aspects of business processes. We extend the MetaMIS approach to enable the specification of fact calculations in data mart environments.
1 citations
•
05 Mar 2020
TL;DR: In this article, the authors present a method for the automated generation of software code for a corporate data warehouse, which includes obtaining metadata describing a setting for data transformation mechanisms for loading data to a detailed layer level and calculating the data marts of a warehouse; generating at least one template for updating the data of the detailed layer and a data mart of the data warehouse.
Abstract: This technical solution relates generally to the field of computer technology, and more particularly to systems and methods for the automated generation of software code for a corporate data warehouse. A method for the automated generation of software code for a corporate data warehouse includes obtaining metadata describing a setting for data transformation mechanisms for loading data to a detailed layer level and calculating the data marts of a warehouse; generating at least one template for updating the data of the detailed layer and a data mart of the data warehouse; generating software code for loading data to the detailed layer of the data warehouse and calculating data marts on the basis of the metadata obtained and the data update template generated; installing the software code generated in the previous step in the data warehouse environment for performing loading; reusing the detailed layer and data mart update metadata. The technical result is an increase in the stability of detailed layer and data mart algorithms and a decrease in the number of incidents in the data warehouse.
••
01 Jan 2010
TL;DR: The choosen architecture of a datawarehouse depends on the data type and volumes from the source data, and inflences the analysis, data mining and reports done upon the data from DWH.
Abstract: Architecture models and possible data flows for local and group datawarehouses are presented, together with some data processing models. The architecture models consists of several layers and the data flow between them. The choosen architecture of a datawarehouse depends on the data type and volumes from the source data, and inflences the analysis, data mining and reports done upon the data from DWH.
•
13 Feb 2014
TL;DR: In this article, a prediction value evaluation support system is proposed to enable a data analyzer to determine an optimal prediction value without the need of multiple management, including a data mart table generation, record generation, and record insertion.
Abstract: PROBLEM TO BE SOLVED: To provide a prediction value evaluation support system enabling a data analyzer to determine an optimal prediction value without the need of multiple managementSOLUTION: A prediction value evaluation support system includes: a data mart table generation part 15 for generating, on the basis of original data, a data mart table 20 including a data mart having a field of a prediction value status number indicating a prediction method; a prediction value record generation part 17 for generating a prediction value record by predicting on the basis of the prediction value status number indicating the prediction method and the data mart stored in the data mart table; a prediction value record insertion part 18 for inserting the prediction value record into the data mart table 20 and setting a prediction value status number relevant to the prediction method to the field of the prediction value status number of the prediction value record; an evaluating OLAP cube generation processing part 22 for generating an OLAP cube for each prediction method; and an actual-operating OLAP cube generation processing part 28 for determining an OLAP cube by using an optimal prediction method on the basis of the evaluating OLAP cube for each prediction method
•
06 May 2015
TL;DR: In this paper, a decision support system for a freezing method based shaft sinking project is presented, which comprises a source data layer mainly used for storing detected data before and during freezing construction, a data acquisition layer is responsible for extracting data from the source dataset, and a data management layer establishes a data mart to reduce data processing workload according to different themes.
Abstract: The invention discloses a freezing control decision support system for a freezing method based shaft sinking project. The system comprises a source data layer mainly used for storing detected data before and during freezing construction, a data acquisition layer is responsible for extracting data from the source data layer and then loading cleaned and converted data into a freezing project data warehouse, and a data management layer establishes a data mart to reduce data processing workload according to different themes. Multi-layered analyzing and digging of the data are realized through data digging and OLAP (on-line analytical processing) tools in a data analysis layer, acquired knowledge is put into a knowledge base, and auxiliary decisions for certain analysis are achieved through knowledge inference. Comprehensive decisions of multiple models are achieved by a model base. A data display layer provides analysis results for related decision-making personnel through a front-end display tool (graphic user interface). The system integrates various detection, analysis and control in the field of freezing control and provides powerful decision support for freezing construction personnel to control freezing.