Index calculation engine implementation method based on multi-dimensional model

A technology of index calculation and implementation method, applied in the information field, can solve the problems of different data index calibers, long time-consuming running batch calculations, cross-dependency of running batches, etc., to improve computing efficiency, improve overall computing efficiency, and intensify computing results Effect

Active Publication Date: 2021-08-13
武汉众邦银行股份有限公司
View PDF5 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The purpose of the present invention is to build a bank-wide index library, provide data interface services and report processing data sources, support the daily demand of the whole bank for T+1, and solve the problem of diff

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Index calculation engine implementation method based on multi-dimensional model
  • Index calculation engine implementation method based on multi-dimensional model
  • Index calculation engine implementation method based on multi-dimensional model

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0067] The indicator market model includes two areas: the multidimensional model area and the index calculation area

[0068] Multi-dimensional model area: composed of multi-dimensional model tables and dimension tables, it is a multi-dimensional data model designed based on the data requirements of the whole bank's reports and indicators. It is the basis of indicator calculation and the main data source. The data requirements are driven by the enrichment and expansion of the model, and the principle of model design is to be compatible with the addition or change of subsequent applications.

[0069] Indicator calculation area: consists of indicator definition and engine calculation.

[0070] Index definition: unified standardized definition, unified standardized management, including the definition and full life cycle management of the index's business meaning, index coding, technical caliber, statistical frequency, common dimensions, effective date and other information by th...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention relates to the technical field of information, and provides an index calculation engine implementation method based on a multi-dimensional model. The method aims to solve the problems of different data index apertures, inaccurate data, data processing logic hard code stacking, repeated processing, batch running crossing dependence and long batch running operation time consumption. The main scheme comprises steps of constructing a multi-dimensional model table and a dimension table, and providing a data source for index calculation; according to the multi-dimensional model table, carrying out index calculation logic design, and obtaining a basic index engine configuration table, an addition and subtraction index engine configuration table and a multiplication and division index configuration table; calling the basic index engine configuration table, and calculating to obtain a basic index calculation result; calling an addition and subtraction index engine configuration table, and calculating to obtain an addition and subtraction index calculation result; and calling the multiplication and division index engine configuration table, and calculating the multiplication and division index engine configuration table to obtain a multiplication and division index calculation result; taking the obtained index calculation result as a data interface to provide services for the outside.

Description

technical field [0001] The invention relates to the field of information technology, and provides a method for realizing an index calculation engine based on a multidimensional model. Background technique [0002] At present, each application system of the banking system builds its own reports and processing indicators, or builds a data report application in a subject area based on a theme-based data mart, but it still cannot solve the problems of unified management, calculation, and usage of bank-level data. As a result, data indicators are not managed by a centralized department, data quality is difficult to locate and improve, indicator calculation efficiency is low, batch processing cross-dependence, and various systems repeatedly create wheels and repeat coding. Contents of the invention [0003] The purpose of the present invention is to build a bank-wide index library, provide data interface services and report processing data sources, support the daily demand of th...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F40/18G06F40/186G06Q10/06G06Q10/10G06Q40/02
CPCG06Q10/06393G06Q10/10G06Q40/02G06F40/18G06F40/186
Inventor 阮超李耀彭磊杨志文
Owner 武汉众邦银行股份有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products