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

Treating method and system for MDX multidimensional data search statement

A technology of multi-dimensional data query and processing method, which is applied to the processing and system field of MDX multi-dimensional data query statement, can solve the problems of query optimization and processing not seen, and achieves the effect of being beneficial to processing and improving query efficiency

Inactive Publication Date: 2005-03-02
陈红 +5
View PDF0 Cites 37 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

There is no way to directly optimize and process queries on MDX

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
  • Treating method and system for MDX multidimensional data search statement
  • Treating method and system for MDX multidimensional data search statement
  • Treating method and system for MDX multidimensional data search statement

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] Such as figure 1 As shown, the present invention includes an input module, an MDX query task analysis and optimization module, a data warehouse server, and an output module. The data warehouse server includes a data warehouse and a storage management mechanism of the data warehouse, and the data stored in the data warehouse is a cubic structure and a relational data structure. After the query task is input through the input module, the MDX query statement analysis and optimization module analyzes and optimizes it accordingly, divides the query task into multiple sub-queries, and inputs them to the data warehouse server in units of sub-queries, and the data warehouse server executes the sub-query Query to generate corresponding sub-query results, and the results of each sub-query are summarized and output by the output module.

[0029] In the present invention, because an MDX query often involves multiple layers of a dimension, such as involving two layers of month and ...

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 present invention discloses the method and system of processing MDX multi-dimensional data inquiry statement. The present invention includes for the user to send MDX multi-dimensional inquiry task to the inquiry treatment subsystem; for the inquiry treatment subsystem to read the MDX multi-dimensional inquiry task, to analyze directly, to optimize serially and parallelly and to decompose the MDX multi-dimensional inquiry task into several son inquiry tasks; for the inquiry treatment subsystem to send the son inquiry plan to corresponding data warehouse servers; for the data warehouse servers to execute corresponding inquiry plan and to return the inquiry result to the inquiry treatment subsystem; and for the inquiry treatment subsystem to synthesize the inquiry results and to return to the user. The present invention realizes the direct analysis and treatment of MDX language, has high inquiry efficiency, and is especially suitable for multi-dimensional data inquiry.

Description

technical field [0001] The invention relates to a method and system for processing query sentences of MDX multidimensional data. Background technique [0002] Currently, the commonly used database query language SQL is mainly used to query two-dimensional relational table data. [0003] However, SQL has weak query support for multidimensional data. In recent years, the emergence of MDX, which has similar functions to SQL, has solved the problem of multidimensional data query, and its development momentum is quite rapid. [0004] MDX is a set of statements defined in the OLE DB for OLAP interface specification (proposed by Microsoft Corporation) for querying multidimensional data, similar to standard SQL statements in relational databases. The main purpose of creating MDX is to facilitate users' access to multidimensional data. [0005] MDX, as a semantically rich statement for querying multidimensional data, has gradually become the de facto standard in the industry since...

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
Inventor 陈红王珊李翠平肖震刘昱杜小勇
Owner 陈红
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