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

Method for querying hierarchical node data

A technology of node data and query method, applied in the field of electric power, can solve the problems of slow transmission of large data volume, lack of response time for users, and attack on enterprise informatization construction, so as to shorten the overall time, improve the efficiency of data acquisition and query. The effect of reduced response time

Active Publication Date: 2014-04-23
STATE GRID CORP OF CHINA +3
View PDF7 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Enterprise data display platforms often need to extract corresponding data from the SAP ERP system for daily analysis. The existing technology provides data to third parties directly through RFC functions. The main disadvantage is that the transmission speed of large data volumes is relatively slow, and the processing of complex logic comparisons Difficult, many queries and analyzes have to be given up because users cannot get effective response time, which is a big blow to the informatization construction of enterprises
The link that affects data reading is mainly because the recursive call of hierarchical nodes is relatively slow, which restricts the acquisition of data. However, it is inevitable to read data on the hierarchical structure and interpret the level of each node. A better method is needed. The implementation method to deal with this kind of problem

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
  • Method for querying hierarchical node data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018] This method integrates MDX statement, BW ETL data extraction and RFC remote function call into one. Now it is necessary to query all personnel information under the node number 13000001 of an organization structure. The detailed steps are as follows:

[0019] Step 1: Query The user enters the personnel node to be queried on the data search platform. In this example, enter 13000001 node;

[0020] Step 2: Call the RFC (Remote Function Call) function to pass the parameters to the BW (Enterprise Data Warehouse) system according to the input of the data search platform interface;

[0021] Step 3: BW calls the access function according to the corresponding parameters of the received 13000001 node;

[0022] Step 4: The access function calls the personnel node report developed by QUERY DESIGNER, and runs all child nodes under the node;

[0023] Step 5: If the display node has no child nodes, the result will be returned directly without data; if there are child nodes, the MDX...

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 discloses a method for querying hierarchical node data. By using the method, MDX (multidimensional expressions) statements, BWETL (band width extract transform and load) data extracting and RFC (request for comment) remote functions are invoked integrally, the hierarchical node data are queried, hierarchical nodes are inputted, and queried nodes are inputted on a data retrieval platform. The method for querying hierarchical node data comprises the following steps of examination on authorization: verifying authorization of inputted nodes and personnel using the method; parameter transmitting: transmitting parameters to a function if verification passes and performing specific data extracting operation; executing on a node report: invoking a BWQUERY node report according to the parameters after the parameters are received by the function; invoking of the MDX statements: invoking the MDX statements if data of the inputted nodes exist, transmitting the running result of the report to an inner table of the function and maintaining the running result as a queried parameter; and returning of the result: reading data from a DSO (digital storage oscilloscope) model according to the node parameters and limiting conditions of the function, and returning the result to the data retrieval platform to obtain the hierarchical node data. By using the method, the data acquisition efficiency is improved, and data uploading is stable.

Description

technical field [0001] The invention belongs to the field of electric power, and in particular relates to a method for querying hierarchical node data aimed at the large amount of data query of hierarchical nodes. Background technique [0002] SAP ERP system is a set of enterprise management software developed by Germany's SAP company. The system has complete applications for daily management of enterprises. Through configuration, seamless data integration between applications can be realized. Enterprise data display platforms often need to extract corresponding data from the SAP ERP system for daily analysis. The existing technology provides data to third parties directly through RFC functions. The main disadvantage is that the transmission speed of large data volumes is relatively slow, and the processing of complex logic comparisons Difficulties, many query analysis had to be given up because users could not get effective response time, which was a big blow to the enterpr...

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/903
Inventor 方泉陈武曾锃
Owner STATE GRID CORP OF CHINA
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