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

Method and device for multidimensional analysis of relational database

A multi-dimensional analysis and multi-dimensional analysis model technology, applied in relational databases, multi-dimensional databases, database models, etc., can solve problems such as low efficiency of multi-dimensional analysis, long-term troubleshooting, etc., to facilitate the work of tuning and improve efficiency.

Active Publication Date: 2018-05-04
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In multi-dimensional analysis based on relational databases, since one MDX statement will translate multiple SQL statements for execution, once a performance problem occurs, it is difficult for developers to accurately determine what the performance bottleneck is, which takes a long time to complete. Troubleshooting, resulting in low efficiency of multidimensional analysis

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 multidimensional analysis of relational database
  • Method and device for multidimensional analysis of relational database
  • Method and device for multidimensional analysis of relational database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0050] figure 1 It is a flowchart of a method for multidimensional analysis of a relational database provided in Embodiment 1 of the present invention. This embodiment is applicable to optimize the multidimensional analysis of a relational database in the prior art, and the method can be executed by a computer , including the following steps:

[0051] Step 110, building a fact table and a dimension table in the relational database, and building a multidimensional analysis model.

[0052] Organize the data stored in the relational database, and build the data that records business indicators and other facts (such as sales data) and the data of dimension foreign keys into a multi-dimensional analysis fact table. Associated with the dimension table, it represents the referenced dimensions and facts; the data recording dimension information (such as time dimension, region dimension, etc.) is built as a multidimensional analysis dimension table. For example, if the fact table rec...

Embodiment 2

[0063] figure 2 It is a flowchart of a method for multidimensional analysis of a relational database provided in Embodiment 2 of the present invention, specifically including the following steps:

[0064] Step 210, building a fact table and a dimension table in the relational database, and building a multidimensional analysis model.

[0065] Step 220, verify the structure between the fact table and the dimension table and the index relationship in the multidimensional analysis model, and output the verification result.

[0066] After receiving the verification instruction from the user, the structure (such as data type) and the index relationship between the fact table and the dimension table in the multidimensional analysis model are verified, and the specific relationship between the fact table and the dimension table can be verified. Whether the primary and foreign keys are reasonable, including whether the index is established, whether the data types are consistent, whet...

Embodiment 3

[0090] Figure 4 It is a schematic diagram of a device for multidimensional analysis of a relational database provided in Embodiment 3 of the present invention, such as Figure 4 As shown, the device for multidimensional analysis of a relational database provided in this embodiment includes: a multidimensional analysis model building module 410 , a sentence translation module 420 , an output display module 430 and a query module 440 .

[0091] Wherein, the multidimensional analysis model building module 410 is used to build fact tables and dimension tables in relational databases, and build multidimensional analysis models;

[0092] The statement translation module 420 is used to translate the MDX statement in the multidimensional analysis model into an SQL statement;

[0093] The output display module 430 is used to compile the SQL statement to determine the SQL execution steps, and output and display the MDX statement, the SQL statement and the corresponding SQL execution s...

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 method and a device for multidimensional analysis of a relational database. The method includes: creating a fact table and a dimension table in the relational database, and establishing a multidimensional analysis model; translating MDX (multidimensional expressions) statements in the multidimensional analysis model to SQL (structured query language) statements; compiling the SQL statements so as to determine an SQL execution step, and outputting and displaying the MDX statements, the SQL statements and the corresponding SQL execution step; adopting the SQL statements to execute SQL inquiry on the fact table and the dimension table, and returning inquiry results. By output and display of the MDX statements in the multidimensional analysis model, the SQL statements translated from the MDX statements and the SQL execution step, developers can discover possible performance problems in time beneficially, efficiency of multidimensional analysis is improved, convenience is brought to developers to monitor generation of the MDX statements into the SQL statements, and operation of multidirectional analysis and optimization is facilitated.

Description

technical field [0001] Embodiments of the present invention relate to database query technology, in particular to a method and device for multidimensional analysis of relational databases. Background technique [0002] Multidimensional analysis is a core concept of Business Intelligence (BI), which is widely used in data analysis, decision support and other systems. The core of multidimensional analysis is the multidimensional analysis model, which defines elements such as "dimension", "level", "level", and "indicator", as well as the relationship between the fact table of "indicator" and the dimension table of "dimension". According to the multidimensional analysis model, the multidimensional analysis query is carried out to obtain the multidimensional analysis results. The multidimensional analysis report is a form of displaying the results of multidimensional analysis. It consists of "dimensions" (influencing factors) and "indicators" (measurement factors), which can be ...

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/283G06F16/284
Inventor 尹家彬胡浩马斗常伟李涛宋全旺李雪楠王乐宋腾刘兴瑶
Owner BEIJING JINGDONG SHANGKE INFORMATION 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