CN103744989A - Method for querying hierarchical node data - Google Patents
Method for querying hierarchical node data Download PDFInfo
- Publication number
- CN103744989A CN103744989A CN201410026511.0A CN201410026511A CN103744989A CN 103744989 A CN103744989 A CN 103744989A CN 201410026511 A CN201410026511 A CN 201410026511A CN 103744989 A CN103744989 A CN 103744989A
- Authority
- CN
- China
- Prior art keywords
- data
- node
- function
- parameter
- mdx
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Stored Programmes (AREA)
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
The invention belongs to power domain, the querying method of a kind of level node data of specifically inquiring about for the big data quantity of level node.
Background technology
SAP ERP system is a set of business management software of German SAP company exploitation, and this system has each application of perfect enterprise's daily management, by configuration, can realize the seamless integrated of data between each application.Business data display platform often need to extract corresponding data and carry out routine analysis from SAP ERP system, prior art is directly by RFC function, to third party, to provide data, main shortcoming is slow to big data quantity transmission speed, process complex logic more difficult, a lot of query analysis have to abandon because user can not get the effective response time, to the informatization of enterprise, are no small strikes.It is mainly slow when the recursive call of level node affecting the link that data read, restricted obtaining of data, but in hierarchical structure, peeking, is again inevitably to the level interpretation of each node, needs a kind of better implementation method to process this problem.
Summary of the invention
The problem existing in order to overcome prior art, the querying method that the object of this invention is to provide a kind of level node data, the method merges MDX statement, BW ETL data pick-up in one on the basis of the RFC of inheriting tradition function, by operation BW(Business Datawarehouse Data Warehouse for Enterprises) form carrys out the data of securing layer minor node, and efficiency is high; In whole query script, by the optimization of peek link, shorten the overall time of querying node; With MDX(Multi-Dimensional Expressions Multidimensional Expressions language) the statement Real-time Obtaining form result moving is out to interior table, as the conditional parameter of inquiry, uses; BW ETL instrument is realized and ERP(Enterprises Resources Planning Enterprise Resources Plan) seamless link of system, data are uploaded more stable.
The object of the invention is to be achieved through the following technical solutions:
A querying method for level node data, is characterized in that: the method merges MDX statement, BW ETL data pick-up and RFC remote function calls in one, the inquiry of implementation level node data, and concrete steps are as follows:
1) level node input, the node of input inquiry on data retrieval platform (can input the node of any level);
2) scope check, does the verification of authority to the personnel of the node of input and use;
3) parameter transmission, if verification is passed through, Transfer Parameters, to function, carries out concrete peek operation;
4) XM form, after function receives parameter, according to parameter call BW QUERY node form; If form moves out, there is no data, return to searching platform, this inquires about countless certificates;
5) call MDX statement, input node is had to data, call MDX statement, the result of form operation is delivered in the interior table of function, as the parameter of inquiry, retain;
6) return results, according to the restrictive condition of node parameter and function reading out data from DSO model, return results to data retrieval platform, obtain level node data.
Step 2 of the present invention), in, according to the input at data search platform interface, call RFC function (remote function calls) parameter is delivered to BW system.In step 5), if there is child node, call MDX statement, the result that form is moved out is saved in the interior table of function, as the parameter reservation of inquiry.
The present invention can process complicated logic, versatility is good, is not limited to certain concrete inquiry, so long as relate to the inquiry of level node in SAP system, can use, by third party's extracted data, in the process of transmission data, do not affect the use of operation system.
This method is on traditional RFC (Remote Function Call) remote function calls basis, introduce MDX (Multi-Dimensional Expressions) Multidimensional Expressions language technology, utilize MDX technology can obtain dynamically the data of SAP BW (Business Datawarehouse) form, form has great advantage with respect to ABAP program in the multi-level node data of inquiry.By use efficient inquiry processing method in the process of querying node, optimized peek flow process, the load balancing of server and the balance of function call response speed have been accomplished, particularly tackle the inquiry of the level node data of big data quantity, average query responding time can shorten more than at least 2 times.
The present invention incorporates MDX technology in traditional RFC function application, traditional MDX technology and RFC function peek technology are all to use separately, the present invention peeks technology in the enforcement that combines by MDX technology and RFC function, has simplified the flow process of exploitation, has improved data acquisition efficiency.In whole query script, by the optimization of peek link, shorten the overall time of querying node; BW ETL instrument is realized the seamless link with ERP system, and data are uploaded more stable.
Accompanying drawing explanation
Fig. 1 is process flow diagram of the present invention.
Embodiment
This method merges MDX statement, BW ETL data pick-up and RFC remote function calls in one.Will inquire about now certain organizational structure node serial number is all personnel's information below 13000001.Detailed step is as follows:
The first step: inquiring user data search platform on input need personnel's node of inquiry, in this example, input 13000001 nodes;
Second step: according to the input at data search platform interface, call RFC(remote function calls) function is delivered to BW(Data Warehouse for Enterprises parameter) system;
The 3rd step: BW is according to the corresponding parameter call retrieval function of 13000001 node receiving;
The 4th step: personnel's node form that retrieval function is called QUERY DESIGNER exploitation, moves out of all child nodes under this node;
The 5th step: if show that node, without child node, directly returns results countless certificates; If there is child node, call MDX statement, the result that form is moved out is saved in the interior table of function, as the parameter reservation of inquiry.In inquiry, introduce first the technology of MDX statement; Traditional method is directly to read by function, does not use MDX technology.
The 6th step: the DSO(Data Storage Object data storage object according to the restrictive condition of child node parameter and function from BW) reading out data in model, returns to personal information below 13000001 nodes to data search platform.
This implementation method is verified.From concerning the time of reading of node, if the order of magnitude is at the node of about 2w, the time that operation form reads level node needs just can go out result about 5,6 seconds, but a kind of OO program development language of developing by ABAP(SAP company) program recurrence reading out data, need at least spend more than 30 seconds.In improved RFC function, merged the correlation technique of MDX statement, by MDX, obtain the real time data of form operation, guaranteeing under the correct prerequisite of data, reduced the complicacy of function peek logic, saved a large amount of working times, reduced the redundance that data read simultaneously, made the operation of data and transmit more quick, really accomplish to shorten the response time of system queries, improved client's satisfaction.
Claims (3)
1. a querying method for level node data, is characterized in that: the method merges MDX statement, BW ETL data pick-up and RFC remote function calls in one, the inquiry of implementation level node data, and concrete steps are as follows:
1) level node input, the node of input inquiry on data retrieval platform;
2) scope check, does the verification of authority to the personnel of the node of input and use;
3) parameter transmission, if verification is passed through, Transfer Parameters, to function, carries out concrete peek operation;
4) XM form, after function receives parameter, according to parameter call BW QUERY node form; If form moves out, there is no data, return to searching platform, this inquires about countless certificates;
5) call MDX statement, input node is had to data, call MDX statement, the result of form operation is delivered in the interior table of function, as the parameter of inquiry, retain;
6) return results, according to the restrictive condition of node parameter and function reading out data from DSO model, return results to data retrieval platform, obtain level node data.
2. the querying method of level node data according to claim 1, is characterized in that: step 2) in, according to the input at data search platform interface, call RFC function parameter is delivered to BW system.
3. the querying method of level node data according to claim 1, is characterized in that: in step 5), if there is child node, call MDX statement, the result that form is moved out is saved in the interior table of function, as the parameter reservation of inquiry.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410026511.0A CN103744989B (en) | 2014-01-21 | 2014-01-21 | Method for querying hierarchical node data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410026511.0A CN103744989B (en) | 2014-01-21 | 2014-01-21 | Method for querying hierarchical node data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103744989A true CN103744989A (en) | 2014-04-23 |
| CN103744989B CN103744989B (en) | 2017-01-25 |
Family
ID=50502007
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410026511.0A Active CN103744989B (en) | 2014-01-21 | 2014-01-21 | Method for querying hierarchical node data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103744989B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105787080A (en) * | 2016-03-02 | 2016-07-20 | 深圳市元征科技股份有限公司 | Node data processing method and device |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1588358A (en) * | 2004-08-26 | 2005-03-02 | 陈红 | Treating method and system for MDX multidimensional data search statement |
| US8285752B1 (en) * | 2006-03-20 | 2012-10-09 | Symantec Operating Corporation | System and method for maintaining a plurality of summary levels in a single table |
| CN101556602B (en) * | 2009-04-08 | 2013-07-03 | 王珊 | Memory OLAP What-if analytical method based on a difference table |
| CN103106197B (en) * | 2011-11-09 | 2016-05-04 | 深圳市金蝶中间件有限公司 | The methods of exhibiting of hierarchical data and system |
| CN103064923B (en) * | 2012-12-17 | 2016-08-17 | 浙江鸿程计算机系统有限公司 | A kind of OLAP query spacing computational methods based on dimension hierarchy feature |
-
2014
- 2014-01-21 CN CN201410026511.0A patent/CN103744989B/en active Active
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105787080A (en) * | 2016-03-02 | 2016-07-20 | 深圳市元征科技股份有限公司 | Node data processing method and device |
| CN105787080B (en) * | 2016-03-02 | 2019-04-19 | 深圳市元征科技股份有限公司 | Node data processing method and processing device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103744989B (en) | 2017-01-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11216302B2 (en) | Modifying task dependencies at worker nodes using precompiled libraries | |
| US8712972B2 (en) | Query optimization with awareness of limited resource usage | |
| Holzschuher et al. | Performance of graph query languages: comparison of cypher, gremlin and native access in Neo4j | |
| CN106446153A (en) | Distributed newSQL database system and method | |
| Aboutorabiª et al. | Performance evaluation of SQL and MongoDB databases for big e-commerce data | |
| CN104750681B (en) | A kind of processing method and processing device of mass data | |
| CN109656963B (en) | Metadata acquisition method, apparatus, device and computer readable storage medium | |
| CN110908641B (en) | Visualization-based stream computing platform, method, device and storage medium | |
| US9201700B2 (en) | Provisioning computer resources on a network | |
| CN104239572A (en) | System and method for achieving metadata analysis based on distributed cache | |
| CN102841889A (en) | Method and device for achieving efficient database access based on ORM (object relational mapping) architecture | |
| CN101216840A (en) | Data enquiry method and data enquiry system | |
| US9886477B2 (en) | Generating imperative-language query code from declarative-language query code | |
| US10599654B2 (en) | Method and system for determining unique events from a stream of events | |
| CN110134705A (en) | A kind of data query method, cache server and terminal | |
| US9930113B2 (en) | Data retrieval via a telecommunication network | |
| US20130166472A1 (en) | Rule-based determination and validation in business object processing | |
| US20140101097A1 (en) | Template based database analyzer | |
| US8965879B2 (en) | Unique join data caching method | |
| US11182386B2 (en) | Offloading statistics collection | |
| CN103248511A (en) | Analyses method, device and system for single-point service performance | |
| US8832653B2 (en) | Centralized, object-level change tracking | |
| CN111984660A (en) | Data synchronization method, device, equipment and storage medium | |
| KR20180077830A (en) | Processing method for a relational query in distributed stream processing engine based on shared-nothing architecture, recording medium and device for performing the method | |
| CN103744989B (en) | Method for querying hierarchical node data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20171113 Address after: 100031 Xicheng District West Chang'an Avenue, No. 86, Beijing Co-patentee after: Jiangsu Electric Power Company Patentee after: State Grid Corporation of China Co-patentee after: Jiangsu Electric Power Information Technology Co., Ltd. Co-patentee after: INFORMATION COMMUNICATION BRANCH, STATE GRID JIANGSU ELECTRIC POWER COMPANY Address before: 100031 Xicheng District West Chang'an Avenue, No. 86, Beijing Co-patentee before: Jiangsu Electric Power Company Patentee before: State Grid Corporation of China Co-patentee before: Jiangsu Electric Power Information Technology Co., Ltd. |