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

A method of eliminating and summarizing specific data layer by layer

A data-specific, layer-by-layer technology, applied in special data processing applications, database models, database indexes, etc., to achieve good performance

Active Publication Date: 2019-04-26
YGSOFT INC
View PDF8 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] In view of the above analysis, the present invention aims to provide a method for eliminating and summarizing specific data layer by layer, so as to solve the problems of performance and timeliness existing in the existing system

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
  • A method of eliminating and summarizing specific data layer by layer
  • A method of eliminating and summarizing specific data layer by layer
  • A method of eliminating and summarizing specific data layer by layer

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0046] Preferred embodiments of the present invention will be specifically described below in conjunction with the accompanying drawings, wherein the accompanying drawings constitute a part of the application and are used together with the embodiments of the present invention to explain the principle of the present invention.

[0047] like figure 1 As shown, the superior-subordinate relationship among organizations forms a multi-level tree. The actual business happens on the leaf nodes (bottom units) of the tree, that is, the system only stores the data of the bottom units.

[0048] Based on the unit and account relationship obtained by the tiling algorithm of the unit and account relationship, according to the elimination rules, mark the data that needs to be eliminated, and then complete the elimination and aggregation based on this data. How to achieve elimination according to rules during the layer-by-layer aggregation of data.

[0049] The invention discloses a method f...

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 a method for rejecting and summarizing specific data layer by layer simultaneously. The method comprises the following steps: establishing a relationship table between servers; determining data needing to participate in summarization by each layer of server; rejecting some pieces of data in accordance with a preset rejection rule by each layer of server so as to participate in summarization, and storing a result in a data table. The method can be applied to multi-dimensional and multi-layer layer-by-layer data summarization of a transactional system without depending on the change of detailed data, pre-processing can be performed, and the processing process does not need to be associated with the detailed data, so that good performance is ensured; in the method, a multi-layer data relationship and the rejection rule are stored separately, so that in a white-box testing process, step-by-step testing is easily realized, and it is easier to find and solve the problem in a production environment.

Description

technical field [0001] The invention relates to the technical field of data processing in the field of enterprise information management system (ERP), in particular to a method for eliminating and summarizing specific data layer by layer. Background technique [0002] Transactional systems often only store the most granular data, and often need to aggregate data to multiple levels by one dimension. In the layer-by-layer aggregation process, it is necessary to identify and eliminate some data according to specific rules and then add them together. The rules are variable; the rules for each level and specific data are different. If the amount of data is large and involves many levels, real-time aggregation will encounter performance and timeliness problems. [0003] For example, the current mode of the company's fund monitoring system is that the servers of each branch company and the financial institution server directly connect the bank to the enterprise, obtain fund data ...

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): G06F16/22G06F16/28
CPCG06F16/22G06F16/283
Inventor 朱宝俊
Owner YGSOFT INC
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