Data table summarizing device and data table summarizing method

A data table and index table technology, applied in the computer field, can solve problems such as the lack of flexibility of summary objects and reduce the overall efficiency of summary, so as to meet the needs of personalized summary and improve the overall efficiency

Active Publication Date: 2013-12-25
YONYOU NETWORK TECH CO LTD
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Although this method can get rid of the problem of manually summarizing data from different data tables, the selection of summary objects is still inflexible. You can only query items with the same ID based on the item ID pre-set on the data table. Sub-data table item segments are summarized; and only one set of data tables can be selected for one query. If different summary methods are selected, multiple database connections will be performed, which reduces the overall efficiency of the summary

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 table summarizing device and data table summarizing method
  • Data table summarizing device and data table summarizing method
  • Data table summarizing device and data table summarizing method

Examples

Experimental program
Comparison scheme
Effect test

specific Embodiment

[0062] A specific embodiment according to the above technical solution is as follows:

[0063] The specific application scenarios are described in combination with the application scenarios proposed in the technical background. That is, a certain group needs to report 3,000 reports from 3,000 subordinate subsidiaries, for example, to extract attributes by industry and region for hierarchical summary (not limited to two levels, you can choose to extract multiple attributes according to the needs of the parent group) , that is, extract the report data tables of all regional subsidiaries under X industry and all regional subsidiaries under Y industry at one time, and can also separately summarize the report data tables of certain regional subsidiaries under X industry.

[0064] Step 1: Create an aspect index table. Extract commonly used attributes such as regions, industries, and unit types in organizational entities, and add them to the established aspect index table. The prima...

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 provides a data table summarizing device and a data table summarizing method. The data table summarizing device comprises a section indexing module which is used for extracting one or more attributes from a summarized object data table and other related data tables and an attribute value of each attribute, a section hierarchical module which is used for acquiring all attribute value combinations of the one or more attributes and an identification set of the data tables with each attribute value combination, and a data table summarizing module which is used for inquiring a first identification set corresponding to a first attribute value combination from all the identification sets according to the first identification set which consists of the selected attribute values and acquiring a second identification set of the summarized object data table corresponding to the first identification set so as to realize summarization. By utilizing the device and the method, different sections are formed according to the different attribute values, and route (identification) information of the data table corresponding to each section is established at one time, therefore, a user can conveniently summarize the data tables extracted according to any section.

Description

technical field [0001] The invention relates to the field of computer technology, and in particular, to a data table aggregation device and a data table aggregation method. Background technique [0002] The summary source data sheet is a common filling-in sub-data sheet reported by the subsidiary company of the parent company. The purpose of the summary is to merge the data sheet reported by the subsidiary company or unit. Higher-level companies may face tens of thousands of reports reported by lower-level companies. Therefore, solving the problem of intelligent extraction of summary source data tables has become an urgent problem to be solved in the field of summary. [0003] At present, the technical solution of the summary data table in the field of data summary of enterprise reports, in most cases, adopts a flat fixed query structure, that is, a project segment identification is set for each sub-data table, and a group of summary is obtained according to a group of ident...

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
Inventor 贾爱华
Owner YONYOU NETWORK TECH CO LTD
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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap