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

Method and device for dimension query based on multidimensional expression language

A multi-dimensional expression and language query technology, applied in the field of dimension query method and device based on multi-dimensional expression language, can solve the problems of slow query speed and achieve the effect of commission query speed

Active Publication Date: 2018-02-02
BEIJING GRIDSUM TECH CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The main purpose of the present invention is to provide a multidimensional expression language-based dimension query method and device to solve the problem of slow query speed in the prior art when analyzing the dimension tables of databases based on multidimensional expression language query processing

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 dimension query based on multidimensional expression language
  • Method and device for dimension query based on multidimensional expression language
  • Method and device for dimension query based on multidimensional expression language

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The present invention will be described in detail below with reference to the accompanying drawings and examples.

[0023] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiment of the application will be clearly and completely described below in conjunction with the accompanying drawings in the embodiment of the application. Obviously, the described embodiment is only It is an embodiment of a part of the application, but not all of the embodiments. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without creative efforts shall fall within the scope of protection of this application.

[0024] It should be noted that the terms "first" and "second" in ...

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 multi-dimensional expression language based dimension query method and device. The multi-dimensional expression language based dimension query method comprises the steps of determining query conditions and analyzing indexes meeting the query conditions in a database and dimension tables to be queried; obtaining a first dimension table in the dimension tables to be queried, wherein the member value number of the first dimension table in the dimension tables to be queried is larger than a preset threshold value; determining first indexes from the indexes meeting the query conditions; filtering member values in the first dimension table according to the first indexes to obtain a member value set; receiving a multi-dimensional expression language query instruction, wherein the multi-dimensional expression language query instruction is a query instruction obtained based on the member value set; executing query processing on the member value set according to the multi-dimensional expression language query instruction. By means of the multi-dimensional expression language based dimension query method and device, the problem of low query speed during multi-dimensional expression language based query processing in the dimension tables of an analysis database is solved.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a dimension query method and device based on a multidimensional expression language. Background technique [0002] In the field of SSAS data analysis, the multi-dimensional expressions (MDX for short) language is used for query, and many large dimensions are often queried, such as Url. At the same time, it is also necessary to filter the member values ​​​​of large dimensions , such as the case where Url contains some keywords for filtering, but using MDX language to filter in the dimension table is slow and inefficient. [0003] Aiming at the problem of slow query speed when analyzing the dimension table of the database based on the multidimensional expression language in the prior art, no effective solution has been proposed yet. Contents of the invention [0004] The main purpose of the present invention is to provide a multidimensional expression language-based dimension quer...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
CPCG06F16/2264G06F16/2445
Inventor 洪超
Owner BEIJING GRIDSUM TECH 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