Data summarization device and method based on relational database

Abstract

The invention provides a data summarization device based on a relational database. The device comprises a definition unit, a receiving unit, a finding unit and a summarizing unit, wherein the definition unit defines the priority level of each dimension of business data; the receiving unit receives an alteration unit submitted by a user; the finding unit finds a superior data unit in the dimension on the highest priority level among superior data units in a plurality of dimensions of the alteration unit; and the summarizing unit performs data summarization from the alteration unit to the superior data unit in the dimension on the highest priority level. According to the technical scheme of the invention, data can be permitted to enter dimensions not on the lowest level, and the priority level of a summarizing path can be judged, so as to ensure that summarized data on higher levels is unambiguous. The invention also provides a data summarization method based on the relational database.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a relational database-based data summarization device and a relational database-based data summarization method. Background technique [0002] In a complex business system, many business data are hierarchical, and the upper-level data needs to automatically summarize the lower-level business data in real time. [0003] Automatic summary requires that the data of the last-level dimension members be summarized layer by layer to the upper-level members, and all the data of the upper-level members are calculated by summarizing the lower-level members. [0004] However, in some business scenarios, users may not directly enter data at the last level, but enter data in the upper-level dimension, and the data in the lower-level dimension is empty. In this case, the user still hopes to be able to continue the entered data to the upper level summary. In other words, we cannot d...

AI Technical Summary

Problems solved by technology

[0014] The reason for this confusion is that it has not been determined which are end-level data and which are non-end-level data, but this kind of business often occurs in business processes such as comprehensive budgeting of enterprises

When the data is only entered at the last level, no matter which path is followed, the result should be the same. However, when the data is allowed to be entered in the non-final dimension, the priority of the path is not judged. data will be problematic

Images