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

Partition query method, system and terminal equipment of a data cube

A technology of data cube and query method, applied in the field of data warehouse, can solve the problems of low query efficiency and excessive data volume, and achieve the effect of improving response speed and analysis performance

Active Publication Date: 2021-07-23
SWIFTPASS TECH CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In view of this, the embodiment of the present invention provides a data cube partition query method, system and terminal equipment to solve the problem in the prior art that the query efficiency is reduced due to excessive data volume

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
  • Partition query method, system and terminal equipment of a data cube
  • Partition query method, system and terminal equipment of a data cube
  • Partition query method, system and terminal equipment of a data cube

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0028] figure 1 It shows the implementation process of a data cube partition query method provided by an embodiment of the present invention. The process execution subject of this embodiment may be a terminal device, and the process is described in detail as follows:

[0029] In step S101, the original data cube is partitioned according to preset partition rules to obtain multiple sub-cubes.

[0030] In one embodiment, the preset partition rule includes preset dimension member information.

[0031] The original data cube is partitioned according to preset dimension member information to obtain multiple sub-cubes.

[0032] In this embodiment, dimension member information refers to dimension member variable information, which is used to identify a certain dimension member. The preset dimension member information is preset dimension member information.

[0033] In one embodiment, the multiple sub-cubes are respectively stored in different storage media.

[0034] In one embodi...

Embodiment 2

[0095] Such as Figure 5 As shown, the data cube partition query system 100 provided by an embodiment of the present invention is used to execute figure 1 The method step in the corresponding embodiment, it comprises:

[0096] The cube partition module 110 is configured to partition the original data cube according to preset partition rules to obtain multiple sub-cubes.

[0097] The sub-cube positioning module 120 is configured to obtain the query condition selected by the user, and locate the corresponding target sub-cube according to the query condition, wherein the query condition conforms to the preset partition rule.

[0098] A sub-cube query module 130, configured to search for target data from the target sub-cube.

[0099] Such as Figure 6 As shown, in one embodiment of the present invention, the sub-cube query module 130 includes:

[0100] The first query statement generation unit 131 is configured to use a multi-dimensional analysis engine to generate a query sta...

Embodiment 3

[0117] Figure 7 It is a schematic diagram of a terminal device 7 provided by an embodiment of the present invention. Such as Figure 7 As shown, the terminal device 7 of this embodiment includes: a processor 71 , a memory 72 and a computer program 73 stored in the memory 72 and operable on the processor 71 . When the processor 71 executes the computer program 73, it realizes the steps in each embodiment as described in Embodiment 1, for example figure 1 Steps S101 to S103 are shown. Alternatively, when the processor 71 executes the computer program 73, it realizes the functions of each module / unit in each system embodiment as described in Embodiment 2, for example Figure 5 The functions of modules 110 to 130 are shown.

[0118] The terminal device 7 refers to a terminal with data processing capabilities, including but not limited to computers, workstations, servers, and even smart phones with excellent performance, palmtop computers, tablet computers, personal digital as...

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 provides a data cube partition query method, system and terminal equipment, wherein the method includes: performing partition processing on the original data cube according to preset partition rules to obtain multiple sub-cubes; obtaining query conditions selected by the user, and according to the The query condition locates the corresponding target sub-cube, wherein the query condition conforms to the preset partition rule; and the target data is searched from the target sub-cube. The invention solves the difficulty of massive data query, and simultaneously improves the response speed and analysis performance of the data cube.

Description

technical field [0001] The invention belongs to the technical field of data warehouses, and in particular relates to a data cube partition query method, system and terminal equipment. Background technique [0002] ROLAP stands for OLAP implementation based on relational database (Relational OLAP). With relational database as the core, data is represented and stored in a relational structure. ROLAP divides the structure of the database into two types of tables: one is the fact table, which is used to store data and dimension keywords; the other is the dimension table, that is, at least one table is used for each dimension to store the dimension level and member category Isodimensional description information. Dimension tables and fact tables are linked together through primary keys and foreign keys to form a "star schema". Its characteristic is to keep the detailed data in the fact table of the relational database, and the aggregated data is also stored in the relational d...

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): G06F16/25G06F16/28G06F16/27
Inventor 方小乔
Owner SWIFTPASS 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