Multi-dimensional database system based on financial data analysis and implementation method

A technology of financial data and multi-dimensional data, applied in the field of financial analysis, can solve problems such as unfavorable multi-dimensional query and analysis, error-prone data, and difficulty in predicting and analyzing, so as to improve the access rate, overcome the insufficiency of meeting demand, and facilitate data query and access. Effect

CN107958048AInactive Publication Date: 2018-04-24安徽经邦软件技术有限公司
5 Cites 10 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Publication Date
2018-04-24
Estimated Expiration
Not applicable · inactive patent

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
Patent Text Reader

Abstract

The invention discloses a multi-dimensional database system based on financial data analysis. The system comprises a data acquisition terminal, a data ETL processing server, a data warehouse server and a multi-dimensional data analysis server; the data acquisition terminal is connected with the data ETL processing server, and the data ETL processing server is connected with the data warehouse server; the data warehouse server is connected with the multi-dimensional data analysis server. The data ETL processing server converts original financial data into a specific format, then integration isconducted in the data warehouse server, the integrated data in a data warehouse is used for constructing a multi-dimensional data model in the multi-dimensional data analysis server and forming a plurality of data marts, and then comprehensive analysis is carried out, so that data query and access are facilitated, and then the access rate is increased.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The invention belongs to the field of financial analysis, and relates to a multidimensional database system based on financial data analysis and a realization method. Background technique

[0002] Under the environment of rapid economic development in our country, group enterprises are also rapidly expanding and developing at a high speed. After long-term operation, the business and financial systems of the group companies have accumulated a large amount of data, but these large amounts of data are only existing and relevant. In each financial information system, the data has not been fully utilized, and the value of the data has not been reflected. The status quo of enterprise data application is mainly reflected in the following aspects: (1) enterprises have accumulated a large amount of data; (2) data is scattered and stored, and it is difficult to implement comprehensive analysis and application; (3) there are many types of reports, it is difficult...

Examples

Embodiment Construction

[0024] A multidimensional database system based on financial data analysis, such as figure 1 As shown, it includes a data acquisition terminal, a data ETL processing server, a data warehouse server and a multidimensional data analysis server; the data acquisition terminal is connected to the data ETL processing server, the data ETL processing server is connected to the data warehouse server, and the data warehouse server is connected to the multidimensional data analysis server;

[0025] The data acquisition terminal is to collect the original financial data of the enterprise, and the original financial data is in the form of an Excel spreadsheet;

[0026] Such as figure 2 As shown, the data ETL processing server includes a data extraction module, a data cleaning module, a data conversion module, and a data loading module. The data extraction module extracts the financial data in the financial system through an interface, and the data cleaning module is for non-compliant Cle...