Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data warehouse based financial data integration method

A financial data and data warehouse technology, applied in the field of data warehouses, can solve problems such as slow information flow, inconsistent basic financial management software, and low integration of financial-related systems, achieving the effect of convenient development and use, and consistent data

Inactive Publication Date: 2016-07-20
SICHUAN CHANGHONG ELECTRIC CO LTD
View PDF5 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, there are also the following problems: the basic financial management software is not unified, such as SAP, OracleERP, UFIDA NC, Jindie KIS, etc.; the degree of integration of financial related systems is not high, resulting in a slow flow of information in various systems; lack of financial management Unified accounting policies, data standards and business processing rules make it difficult to integrate financial data and business data
[0003] In the face of massive and irregular business data, traditional database technology cannot fully integrate and utilize it

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
  • Data warehouse based financial data integration method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] All features disclosed in this specification, or steps in all methods or processes disclosed, may be combined in any manner, except for mutually exclusive features and / or steps.

[0025] Any feature disclosed in this specification (including any appended claims, abstract and drawings), unless expressly stated otherwise, may be replaced by alternative features which are equivalent or serve a similar purpose. That is, unless expressly stated otherwise, each feature is one example only of a series of equivalent or similar features.

[0026] The specific implementation manners of the present invention will be described in detail below in conjunction with the drawings and embodiments.

[0027] Such as figure 1 As shown, according to an embodiment of the present invention, this embodiment discloses a financial data integration method based on a data warehouse. The system of this embodiment consists of an intermediate database, a data source, data extraction, data mapping, an...

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 discloses a data warehouse based financial data integration method. The data warehouse based financial data integration method includes the following steps that step one, a data warehouse data model is designed, data segmentation and data granularity and theme confirmation are performed, and a concept model, a logical model and a physical model are designed; step two, data integration is performed, namely data extraction, data cleaning, data conversion and data loading are performed; step three, data analysis is performed, a used fact table and dimension are selected and analyzed according to a created data source view, and a multi-dimensional dataset is created. The data warehouse based financial data integration method is a group enterprise financial data integration method which adopts an independent architecture, is quick and convenient to develop and use and capable of making data consistent and extendible and is based on a data warehouse and aims at establishing an analysis system oriented to the characteristics of a group enterprise and meeting the specific demands for financial and economic information analysis and management decision making of the group enterprise.

Description

technical field [0001] The invention relates to the technical field of data warehouses, in particular to a financial data integration method based on data warehouses. Background technique [0002] In recent years, the financial information construction of group enterprises has made remarkable achievements, and accumulated a large amount of business data at the same time. However, there are also the following problems: the basic financial management software is not unified, such as SAP, OracleERP, UFIDA NC, Jindie KIS, etc.; the degree of integration of financial related systems is not high, resulting in a slow flow of information in various systems; lack of financial management Unified accounting policies, data standards and business processing rules make it difficult to integrate financial data and business data. In order to further improve capabilities, it is urgent to integrate these data, make deep use of them, and convert data into knowledge to improve the scientific n...

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): G06F17/30
CPCG06F16/215G06F16/211
Inventor 唐军居邦许岩龙
Owner SICHUAN CHANGHONG ELECTRIC CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com