Unlock instant, AI-driven research and patent intelligence for your innovation.

Method and system for data extraction of group enterprise report

A technology for report data and extraction methods, applied in database models, multidimensional databases, electrical digital data processing, etc., can solve the problems of difficult maintenance of reports, strong intrusion of original reports, inability to solve cell data association operations, etc., and achieve permanent availability Flexible and scalable effects

Inactive Publication Date: 2018-05-08
STATE GRID SHANDONG ELECTRIC POWER +1
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] Since the report is a semi-structured document, the existing report data extraction method mainly uses the technical means of characterizing the report cell data to realize the identification and extraction of the report data, but this method is highly intrusive to the original report. It is difficult to maintain the report after it is changed, and at the same time, the mark cannot solve the relationship between cell data such as association operations and meet the needs of users for dynamic expansion

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
  • Method and system for data extraction of group enterprise report
  • Method and system for data extraction of group enterprise report
  • Method and system for data extraction of group enterprise report

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0075] The present invention will be further described below in conjunction with the accompanying drawings and embodiments.

[0076] A method for extracting report data of a group enterprise, comprising the following steps:

[0077] Step (1): Disassemble the report of the group enterprise into report items;

[0078] Structurally disassemble the single-column report and matrix report in the enterprise report to form report items;

[0079] Structural dismantling of a single-column report refers to taking all column headers of the single-column report as report items;

[0080] Structural dismantling of the matrix report refers to splitting the matrix report into a combination of all row headers of the matrix report and all column headers of the matrix report;

[0081] Step (2): Deduplicate the report items according to logic;

[0082] Since there are duplicate indicators among various types of reports, such as accounting reports and budget reports, deduplication is required to...

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 conglomerate report data extracting method and system. The method includes the steps that a single-column report and a matrix report in an enterprise are structurally disassembled, the single-column report exhausts all items of the report, and the matrix report exhausts effective combinations of all rows and all columns of the report to form report items; content recombination is carried out on the report items obtained after disassembling through automatic analyzing and clearing of a system to eliminate repeated data from different reports, the report items are converted into indexes and dimensionality, and the key index system of the enterprise is set up; the concept of originating, general and derived value types is introduced, the index formula and the relation are clarified, and through layer-by-layer definition of the formula, a hierarchical calculation and netlike relation system composed of calculation, fetching and other modes is set up; quantized index data are obtained from the report through system ETL, and a key index information resource pond of a dimensionality table and a fact table is set up to achieve the purposes of extracting, converting, correlating, expanding and applying enterprise report data.

Description

technical field [0001] The invention relates to a method and system for extracting report data of a group enterprise. Background technique [0002] Since the report is a semi-structured document, the existing report data extraction method mainly uses the technical means of characterizing the report cell data to realize the identification and extraction of the report data, but this method is highly intrusive to the original report. After the report is changed, it is difficult to maintain, and at the same time, the mark cannot solve the relationship such as the association operation between the cell data and meet the needs of users for dynamic expansion. Contents of the invention [0003] The purpose of the present invention is to provide a method and system for extracting report data of a group enterprise in order to realize the identification, extraction and association of report item data without transforming the original report system. Establish group enterprise index s...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
CPCG06F16/254G06F16/283G06F16/86
Inventor 武健薛亮路军王志国邢国辉张敏金哲李长青陈煜陈世宾张忠栋解来甲
Owner STATE GRID SHANDONG ELECTRIC POWER
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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