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

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

Active Publication Date: 2010-05-19
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF4 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The programming language of the Microsoft platform needs to be compiled, which brings a lot of trouble to the developer's application, resulting in low efficiency in the development process of the entire OLAP system
Hyperion Essbase is the most famous OLAP server in the world. It can support MDX language, but it does not support the use of custom functions in MDX. The custom functions need to be further implemented by the MaxL scripting language, which also brings great benefits to developers. A lot of trouble, resulting in low efficiency in the development process of the entire OLAP system

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 and device for analyzing multi-dimensional query sentence in online analysis processing server
  • Method and device for analyzing multi-dimensional query sentence in online analysis processing server
  • Method and device for analyzing multi-dimensional query sentence in online analysis processing server

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] In order to make the above objects, features and advantages of the present invention more comprehensible, the embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings.

[0023] The invention is applicable to numerous general purpose or special purpose computing device environments or configurations. For example: personal computer, server computer, handheld or portable device, tablet type device, multiprocessor device, distributed computing environment including any of the above devices or devices, etc.

[0024] The invention may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform particular tasks or implement particular abstract data types. The invention may also be practiced in distributed computing environments where tasks a...

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 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.

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

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F9/44G06F9/45
Inventor 林志贤
Owner KINGDEE SOFTWARE(CHINA) 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