Method and device for analyzing multi-dimensional query sentence in online analysis processing server

An online analytical processing and multi-dimensional query technology, applied in the field of data processing, can solve the problems of not supporting custom functions, troublesome application of developers, low work efficiency of OLAP system, etc., to achieve the effect of improving work efficiency
CN101710273AActive Publication Date: 2010-05-19KINGDEE SOFTWARE(CHINA) CO LTD
4 Cites 10 Cited by

Patent Information

Authority / Receiving Office
CN ¡ China
Current Assignee / Owner
KINGDEE SOFTWARE(CHINA) CO LTD
Publication Date
2010-05-19

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The embodiment of the invention discloses a method and a device for analyzing a multi-dimensional query sentence in an online analysis processing server. The method comprises the following steps of: analyzing a multi-dimensional query sentence and generating a syntactic tree according to an analyzed result, wherein a node of the syntactic tree comprises a horizontal axis object, a longitudinal axis object, a slicing axis object, a calculating member object, a calculating unit object and a custom function CDF object; when a multi-dimensional query expression of various objects on the syntactictree is executed, if a function needs to be called, judging whether the function is a custom function or not according to a function definition of the custom function, if so, entering the executing process of the custom function; otherwise, judging whether the function is a standard function or not according to the function definition of a standard function; and if so, entering the executing process of a marking function. By the embodiment of the invention, the working efficiency of a developer in the development process of the whole OLAP system can be improved.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The present invention relates to the technical field of data processing, in particular to a method and device for parsing multidimensional query statements in an online analysis and processing system Background technique

[0002] Generally, an enterprise resource planning (ERP, Enterprise Recourse Planning) system brings a new data management method to an enterprise. Through the ERP system, enterprises can use and manage various resources of the enterprise more efficiently. A large amount of data is stored in the ERP database, and data processing generally requires multi-table operations and long running time, so it needs to be combined with an Online Analytic Processing (OLAP, Online Analytic Processing) system. The OLAP system mainly includes a multidimensional online analytical processing system (MOLAP, Multi Dimensional OLAP) and a relational online analytical processing system (ROLAP, RelationalOLAP). The OLAP system queries the multidimensional...

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