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

Data cube partitioning method, system and terminal device

A data cube and cube technology, applied in the database field, can solve the problems of low query efficiency and large storage space for data, and achieve the effect of improving response speed and analysis performance

Inactive Publication Date: 2019-02-01
SWIFTPASS TECH CO LTD
View PDF3 Cites 3 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 partitioning method, system and terminal equipment to solve the problems in the prior art that the data occupies a very large storage space and the query efficiency is reduced

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
  • Data cube partitioning method, system and terminal device
  • Data cube partitioning method, system and terminal device
  • Data cube partitioning method, system and terminal device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

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

[0029] Step S101, based on the original business data of the payment platform, construct a data cube and dynamically fill it with data.

[0030] In this embodiment, since the payment platform will add new data to the original business data of the payment platform according to the new transaction events that continue to occur, the newly added data will also be added to the data cube in time, thereby realizing the dynamic filling of the data cube data.

[0031] Step S102, partitioning the data cube according to preset dimension member information to obtain multiple sub-data cubes and corresponding partition rules.

[0032] In this embodiment, dimension member information refers to dimension member v...

Embodiment 2

[0089] Such as Figure 6 As shown, an embodiment of the present invention provides a data cube partitioning system 100 for performing figure 1 The method step in the corresponding embodiment, it comprises:

[0090] The cube construction module 110 is configured to construct a data cube and dynamically fill it with data based on the original business data of the payment platform.

[0091] The cube partitioning module 120 is configured to partition the data cube according to preset dimension member information to obtain multiple sub-data cubes and corresponding partition rules.

[0092] The partition processing module 130 is configured to store the multiple sub-data cubes in different storage media respectively.

[0093] In one embodiment of the present invention, the cube construction module 110 includes:

[0094] The dimension table construction unit is used to construct the dimension table based on the original business data of the payment platform.

[0095] The fact tabl...

Embodiment 3

[0115] 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 6 The functions of modules 110 to 130 are shown.

[0116] 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 invention provides a partitioning method, a system and a terminal device of a data cube, wherein the method comprises the following steps of: constructing a data cube based on the original servicedata of a payment platform and dynamically filling the data into the data cube; partitioning the data cube according to preset dimension member information to obtain a plurality of sub data cubes andcorresponding partitioning rules; the plurality of sub-data cubes are respectively saved to different storage media. The invention solves the difficulty of mass data storage, and improves the response speed and the analysis performance of the data cube at the same time.

Description

technical field [0001] The invention belongs to the technical field of databases, and in particular relates to a data cube partitioning 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 database. ...

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): G06F16/28
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