Processing

Please wait...

Settings

Settings

Goto Application

1. CN112000747 - Data multidimensional analysis method, device and system

Office
China
Application Number 202010653271.2
Application Date 08.07.2020
Publication Number 112000747
Publication Date 27.11.2020
Publication Kind A
IPC
G06F 16/28
GPHYSICS
06COMPUTING; CALCULATING OR COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
20of structured data, e.g. relational data
28Databases characterised by their database models, e.g. relational or object models
G06F 16/24
GPHYSICS
06COMPUTING; CALCULATING OR COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
20of structured data, e.g. relational data
24Querying
CPC
G06F 16/283
GPHYSICS
06COMPUTING; CALCULATING; COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
20of structured data, e.g. relational data
28Databases characterised by their database models, e.g. relational or object models
283Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
G06F 16/24
GPHYSICS
06COMPUTING; CALCULATING; COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
20of structured data, e.g. relational data
24Querying
Applicants SUNING CLOUD COMPUTING CO., LTD.
苏宁云计算有限公司
Inventors WANG JINZHONG
汪金忠
SUN QIAN
孙迁
Agents 北京市万慧达律师事务所 11111
Title
(EN) Data multidimensional analysis method, device and system
(ZH) 数据多维分析方法、装置及系统
Abstract
(EN) The embodiment of the invention discloses a data multidimensional analysis method, and the method comprises the steps: receiving a query request of a user, and extracting an analysis dimension combination in the query request; whether the analysis dimension combination is the same as any dimension combination calculated in a preset logic model or not is judged, and if yes, determining the dimension combination, the same as the analysis dimension combination, in the logic model as a target dimension combination; determining a target pre-summary table corresponding to the target dimension combination in a pre-summary table pre-calculated in the logic model according to a corresponding relationship between a preset dimension combination and the pre-summary table; and obtaining data information to be queried by the query request from a target pre-summary table and returning the data information to the user. Compared with the prior art, the data multidimensional analysis method has the advantages that query of non-additive indexes can be accelerated, and query performance is improved.
(ZH) 本申请实施例公开了一种数据多维分析方法,所述方法包括:接收用户的查询请求,提取查询请求中的分析维度组合;判断所述分析维度组合是否与预设逻辑模型中算得的任一维度组合相同,若是,将逻辑模型中与所述分析维度组合相同的维度组合确定为目标维度组合;根据预设的维度组合与预汇总表的对应关系,在逻辑模型中预先算得的预汇总表中确定目标维度组合对应的目标预汇总表;从目标预汇总表中获取所述查询请求所要查询的数据信息并返回给用户。相比现有技术,本申请能够加速对非可加性指标的查询,提高查询性能。
Related patent documents