Multi-dimensional analysis method and system

A multi-dimensional analysis and dimensional technology, applied in the field of data query, can solve the problems of inability to switch data sources and complicated operations, and achieve the effect of fast switching and simple process

Active Publication Date: 2015-09-23
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF5 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] At present, a Schema multidimensional logical model can only connect to one data source, so the sub-database operation causes a new Schema to be generated for the data in the new storage device to correspond to the data in the new storage device when the query request is executed based on the existing technology, so that the user can use this Schema Enter a query expression, and then query in the corresponding storage device
Existing technologies cannot switch data sources from different perspectives such as query expressions and multiple dimension factors
[0008] Obviously, when adding a storage device corresponding to a data source, a Schema model must be added, which is very cumbersome.

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
  • Multi-dimensional analysis method and system
  • Multi-dimensional analysis method and system
  • Multi-dimensional analysis method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0039] refer to figure 1 As shown, it is a flow chart of a multi-dimensional analysis method provided by Embodiment 1 of the present invention. The technical solution of this embodiment is suitable for fast and automatic switching of data sources, and from at least one Inquiring data from a data source to respond to user requests, this method can be executed by a multi-dimensional analysis system (OLAP system), configured and applied in a computer.

[0040] A multidimensional analysis method provided by Embodiment 1 of the present invention includes:

[0041] Step 110, intercepting the access request sent by the user, and obtaining at least one request parameter of the query expression in the access request.

[0042] As mentioned above, the user sends an access request to the OLAP system through the corresponding schema multi-dimensional logical model according to his own needs, and the OLAP system receives the access request sent by the user through the schema multi-dimensio...

Embodiment 2

[0061] refer to figure 2 As shown, it is a schematic diagram of a multi-dimensional analysis system provided by Embodiment 2 of the present invention. The technical solution of this embodiment is suitable for fast and automatic switching of data sources, and from different data sources according to multiple request parameters in user requests In cases where data is queried in response to user requests, the system can be configured for use in computers.

[0062] A multi-dimensional analysis system provided by Embodiment 2 of the present invention includes: an intercepting user request module 210 , a matching data source module 220 and a query data module 230 .

[0063] Wherein, the intercepting user request module 210 is used for intercepting the access request sent by the user, and obtaining at least one request parameter of the query expression in the access request; the matching data source module 220 is used for each One of the request parameters matches the corresponding...

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 analysis method and a multi-dimensional analysis system. The method comprises the steps as follows: intercepting an access request transmitted by a user and obtaining at least one request parameter in a query expression in the access request; matching corresponding data source for each request parameter according to the request parameter and a configuration file, wherein the configuration file comprises an incidence relation of the preset parameter and the data source; performing data querying operation of the access request in the matched data source. The method and the system provided by the invention are simple in process for switching the data source, and can be used for automatically and fast switching the data source. The method and the system provided by the invention find the data source via a plurality of request parameters and solve the problem in prior art.

Description

technical field [0001] The invention relates to data query technology, in particular to a multidimensional analysis method and system. Background technique [0002] Online analytical processing (Online Analytical Processing, OLAP) system is a multi-dimensional analysis system, usually as the most important application of the database system, through the OLAP system, analysts can quickly and flexibly perform complex query processing of large amounts of data from multiple dimensions , and the OLAP system will provide the query results to analysts in an intuitive and easy-to-understand form. [0003] A large amount of data stored in the database often needs to be expanded from one storage device storing the database to multiple storage devices due to factors such as storage space and organizational management, that is, the database is distributed among multiple storage devices for storage. Each storage device is a data source and has an independent device address. The organiz...

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 Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/245G06F16/283
Inventor 李雪楠胡浩马斗常伟李涛尹家彬宋全旺王乐宋腾刘兴瑶
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap