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

Drill-down method and system for data dimension and electronic equipment

A data dimension and dimension technology, applied in the field of data processing, can solve the problems of poor real-time performance, long computing time, and high resource consumption, achieve the effect of high real-time performance and improve real-time drilling efficiency

Active Publication Date: 2019-08-27
ADVANCED NEW TECH CO LTD
View PDF3 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The embodiment of this specification provides a method, system and electronic equipment for drilling down the data dimension, so as to solve the problem of high resource consumption and calculation time when drilling down the data dimension in the prior art Long, poor real-time problems

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
  • Drill-down method and system for data dimension and electronic equipment
  • Drill-down method and system for data dimension and electronic equipment
  • Drill-down method and system for data dimension and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

example 1

[0038] Example 1, assuming the following personnel information exists, as shown in Table 1:

[0039] Table 1

[0040] Name gender age Deposit amount Zhang San male 50 1000000 Li Si male 60 110 billion Wang Yang Female 55 100 million Wang Yang male 49 1000000 Sun Mei Female 60 110 billion Wang Yuan male 60 110 billion

[0041] If index dimension O is name, index dimension A is gender, index dimension C is age, and aggregation dimension H is deposit amount, the following drill-down data source table can be formed:

[0042] Based on the index dimensions O, A and aggregation dimension H, the name and gender deposit amount data table is formed, as shown in Table 2.

[0043] Table 2

[0044] Name gender Deposit amount Zhang San male 1000000 Li Si male 110 billion Wang Yang Female 100 million Wang Yang male 1000000 Sun Mei Female 110 billion ...

example 2

[0051] Example 2, assuming that there is Beijing information, as shown in Table 5:

[0052] table 5

[0053] city area Area (square kilometers) Population (10,000) Beijing Chaoyang District 0.047 million 100 Beijing Haidian District 430.8 200 Beijing Changping District 1352 300 Beijing Dongcheng Area 0.0041 million 150

[0054] If the index dimension D is the city, the index dimension F is the area, the aggregation dimension I is the area, and the aggregation dimension J is the population, then the following drill-down data source table can be formed:

[0055]Based on the index dimensions D, F and aggregation dimension J, the regional population data table of Beijing is formed, as shown in Table 6:

[0056] Table 6

[0057] city area Population (10,000) Beijing Chaoyang District 100 Beijing Haidian District 200 Beijing Changping District 300 Beijing Dongcheng Area 150 ...

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 embodiment of the invention provides a drill-down method and system for data dimension and electronic equipment and the method comprises the steps: carrying out the aggregation of a business datatable based on a plurality of index dimensions and at least one aggregation dimension of business data, so as to form a drilling data source table; drilling the data source table layer by layer basedon the index dimensions to generate an aggregation result set, wherein the aggregation result set comprises drilling results of the multiple combination dimensions of the index dimensions in the at least one aggregation dimension; responding to a drilling operation of a user for at least one target index dimension and at least one target aggregation dimension, and obtaining the at least one target index dimension and a drilling result corresponding to the at least one target aggregation dimension from the aggregation result set, with the at least one target index dimension belonging to the plurality of index dimensions, and the at least one target aggregation dimension belonging to the at least one aggregation dimension.

Description

technical field [0001] The embodiments of this specification relate to the technical field of data processing, and in particular to a method, system and electronic device for drilling down on data dimensions. Background technique [0002] With the rapid development of the information age, multiple businesses have been added to each enterprise. In order to facilitate effective business statistics and keep abreast of the company's operating status, it is necessary to conduct monthly settlement of the company's financial funds. [0003] At present, there is a method of drilling down to the data dimension. By analyzing the data dimension, the data of each data dimension is drilled layer by layer. However, when the data dimension is very large, it will consume a lot of computing resources and computing time. Real-time Sex is poor. Contents of the invention [0004] The embodiments of this specification provide a method, system, and electronic device for drilling down data dime...

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 Applications(China)
IPC IPC(8): G06F16/242G06F16/22G06F16/28G06Q40/00
CPCG06F16/244G06F16/2282G06F16/283G06Q40/125
Inventor 赵孝松
Owner ADVANCED NEW TECH CO LTD
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

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

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