Multi-dimensional performance data storage method, device and system based on oltp/olap hybrid application

A hybrid application and data storage technology, applied in the field of communications, can solve the problem of not being able to support TDD/FDD multi-dimensional performance data and unified storage at the same time

Active Publication Date: 2020-04-24
ZTE CORP
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] In order to overcome the problem that the existing storage method cannot simultaneously support TDD / FDD multi-dimensional performance data unified storage and support OLTP / OLAP hybrid application, the embodiment of the present invention provides a TDD / FDD multi-dimensional performance data based on OLTP / OLAP hybrid application. Data storage method and system

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 performance data storage method, device and system based on oltp/olap hybrid application
  • Multi-dimensional performance data storage method, device and system based on oltp/olap hybrid application
  • Multi-dimensional performance data storage method, device and system based on oltp/olap hybrid application

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] The technical scheme of the present invention will be described in further detail below in conjunction with the accompanying drawings and specific examples, so that those skilled in the art can better understand the present invention and implement it, but the examples given are not intended to limit the present invention .

[0029] like figure 1 As shown, it shows a multi-dimensional performance data storage method based on OLTP / OLAP hybrid application provided by the embodiment of the present invention. Specifically, the method provided by the embodiment of the present invention includes the following specific steps:

[0030] S10, providing a database table with a column and a row;

[0031] S20. Unifiedly store multi-dimensional performance data in one database table.

[0032] In this embodiment, the multi-dimensional fields of multi-dimensional performance data are uniformly stored in the same database table, wherein TDD and FDD multi-mode performance data are desig...

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

A data storage method, apparatus and system, the method comprising: providing database tables having columns and rows (S10); and storing together multidimensional performance data in one of the database tables (S20). Hybrid applications of OLTP / OLAP big data can be supported, TDD / FDD performance data can be simultaneously stored in one table, and multidimensional (time, location, system) analysis is supported.

Description

technical field [0001] The present invention relates to the field of communication technology, in particular, to a multi-dimensional performance data storage method based on OLTP (On-Line Transaction Processing, online transaction processing system) / OLAP (On-Line Analytical Processing, online analysis and processing system) hybrid application , devices and systems. Background technique [0002] With the wide application of database technology, information systems have produced a large amount of data. How to extract useful information for decision-making analysis from these massive data has gradually become an important problem faced by decision-making managers. [0003] Today's data processing systems can be roughly divided into two categories: online transaction processing system OLTP and online analytical processing system OLAP. OLTP is the main application of traditional relational databases, mainly for basic and daily transaction processing, such as bank transactions. ...

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/22G06F16/28
CPCG06F16/254G06F16/283
Inventor 陈波
Owner ZTE CORP
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