System and method for multi-dimensional statistical business data

Abstract

The invention provides a business data multidimensional statistics method and system. The method comprises the steps of displaying dimensions on a multidimensional statistics page according to dimension names configured in a background; writing information of all business data in a business data total table, extracting the data in the business data total table, and generating four simplified tables according to interfaces, the dimensions, servers and sites; from the business data total table, extracting aggregation information of dimension values of the dimensions of the business data according to different time granularities; according to clicking operation of a user, refreshing a list of the dimensions capable of executing drill-down operation in current operation dimensions; or, according to the clicking operation of the user, generating a time period statistical range, a dimension value statistical filtering condition and dimensions needed to be subjected to statistics. The multidimensional statistics configuration is simplified; different layers of drilling can be displayed on the same page at the same time; re-query is not required during drill-up; and the dimensional data statistics page displays a result quickly.

Description

technical field [0001] The present invention relates to the field of multi-dimensional statistics, in particular to a system and method for multi-dimensional statistical business data. Background technique [0002] In the field of business performance monitoring, business data is large in volume and has many characteristics, and it is necessary to use multi-dimensional analysis technology (MDA, Multi-dimensional Analysis) for statistical analysis of business data. Through the multi-dimensional analysis model, the characteristics of business data are abstracted into dimensions, and the data is counted and displayed in different dimensions, so that users can intuitively understand the information contained in a large amount of complex business data, and conduct correlation analysis between multiple dimensions . By aggregating, drilling, rotating, slicing, and dicing raw business data, it is possible to comprehensively analyze data information. [0003] Therefore, the multi-d...

AI Technical Summary

Problems solved by technology

[0007] (1) The dimension association description file restricts the drill-down and drill-up process to only perform data drill-down and drill-up in the order specified in the file, and cannot switch dimensions;

[0008] (2) When drilling down to a dimension, only the final query result can be displayed, and the data information of each dimension in the process of drilling down cannot be saved;

[0009] (3) The database must be queried again when drilling into the dimension, which brings additional overhead to the system and database;

[0010] (4) When querying the database, each piece of business data information in the database is queried, and the statistics are aggregated in minutes to count the business data that meets the multi-dimensional query conditions within a certain period of time, and the query performance is low

However, this patent document does not disclose how to reflect the statistical data of each level in the drill-down process

Images