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

Data analysis self-help data fetching method and system based on indexes

A data analysis and index data technology, applied in the field of data analysis, can solve problems such as inconsistent statistical data results, bloated systems, and increased data comparison system maintenance costs

Inactive Publication Date: 2017-05-31
CHINACCS INFORMATION IND
View PDF4 Cites 44 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, different periods, different positions, and different personnel have different requirements for business analysis content. Users always hope that the system can obtain the results they want in the system. Business analysis to meet the needs of users, which increases the cost of development and maintenance, and makes the system increasingly bloated and difficult to use
[0004] In addition, if the various statistical indicators in the system do not have a unified data caliber constraint, statistical data results will be inconsistent to a large extent, which will seriously affect the accuracy of data quality and increase the system maintenance caused by data comparison. cost

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 analysis self-help data fetching method and system based on indexes
  • Data analysis self-help data fetching method and system based on indexes
  • Data analysis self-help data fetching method and system based on indexes

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0054] see Figure 1 to Figure 4 , The present invention provides an index-based data analysis self-retrieving method and system.

[0055] The principle of the present invention abstracts the constituent elements of the analysis data into indicators and dimensions. By constructing the indicators and dimension system, the data statistics caliber and the analysis metadata structure are standardized, and the indicators and query dimensions are opened to users for free combination to realize the user's data analysis. Flexible and autonomous customization of analysis.

[0056] An indicator-based data analysis self-retrieving method, including:

[0057] Step 1. According to the indicator information selected by the user, lock the indicator data table used in the query through the indicator configuration mapping.

[0058] Step 2. According to the dimension information selected by the user, reduce the same dimension in each index data table to the same dimension column, and merge to...

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 the technical field of data analysis, and in particular relates to a data analysis self-help data fetching method and system based on indexes. The data analysis self-help data fetching method comprises the following steps: firstly, defining a business index, needing to be used for analyzing and inquiring, through a standard index defining method, and generating index result data; forming a basic data source of self-help data fetching by an index data result; providing various types of defined indexes and dimension information capable of being used for analyzing the indexes on a user data fetching interface; after freely selecting and configuring the needed indexes and inquiring dimension by a user, constructing a data inquiring sentence by the system through an SQL (Structured Query Language) configuration device according to an index and dimension selecting condition of the user; operating and generating a final data result and displaying to the user. The data analysis self-help data fetching method and system based on the indexes have the beneficial effects that free combination of data content and a displaying structure is realized, and a more convenient and flexible data multi-dimensional analysis means is provided for data analysis of the user.

Description

technical field [0001] The invention relates to the technical field of data analysis, in particular to an index-based data analysis self-retrieving method and system. Background technique [0002] With the continuous development of enterprise informatization, data analysis has occupied an important position in various enterprises. The analysis of various production, operation, asset and other data in the enterprise can help users observe the state of the enterprise from multiple dimensions. Understand the changes of the enterprise and guide the business decision-making of the enterprise. [0003] Most enterprises will conduct business data analysis and data acquisition by establishing various business analysis systems. Generally speaking, the system provides users with prefabricated business analysis results through presentation forms such as reports or charts. However, different periods, different positions, and different personnel have different requirements for business...

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
IPC IPC(8): G06F17/30
CPCG06F16/2282G06F16/24524
Inventor 王秀英陈军产国平魏晟坤
Owner CHINACCS INFORMATION IND
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