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

Database read and write method for massive performance data of network management system

A technology of network management system and reading and writing method, which is applied in the direction of database update, electronic digital data processing, structured data retrieval, etc. It can solve the problems of reduced efficiency of database reading and writing, avoid batch deletion of transactions, improve efficiency, and reduce reading The effect of data volume

Active Publication Date: 2019-12-10
WUHAN HONGXIN TELECOMM TECH CO LTD
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The purpose of the present invention is to overcome the problem that the network management system reduces the efficiency of reading and writing the database under massive data, and provides a database reading and writing method for the massive performance data of the network management 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
  • Database read and write method for massive performance data of network management system
  • Database read and write method for massive performance data of network management system
  • Database read and write method for massive performance data of network management system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] The technical solutions of the present invention will be further specifically described below through the embodiments and accompanying drawings.

[0029] see figure 1 , the storage form of the performance data in the database and the working mode of the partition table maintenance component in the embodiment of the present invention specifically include the following processing:

[0030] 1. When creating a database, define a partition data table for data storage. The partitions are uniformly named in the format of 'PM+year, month, and day'. For example, partition PM20161101 represents the partition on November 1, 2016, and the partition data range is from 2016-11-0100:00:00 to 2016-11-01 23: 59:59, that is, this partition stores the performance data of the whole day on November 1, 2016.

[0031] 2. Add partitions for future dates, see figure 1 Center 102: The partition table maintenance component regularly inserts the partitions of future dates and the range of data ...

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 database read-write method for mass performance data of a network management system. The method is characterized in that when a database is established, a partition data table is defined for storage of the data, partitioning is performed by date with days being granularity, and a partition table maintenance component is used for increasing a new partition and deleting an overdue partition; when the data is written in, the database allocates the data into different partitions according to a defined partition range, and the data is subjected to format compression first and then written into the database; when the data is read, the data is filtered from multiple partitions in parallel, and after format decompression is performed, a result is returned to the network management system. According to the technical scheme, the database read-write efficiency can be improved under the mass performance data by scattering data storage, lowering the data reading size and increasing the data reading parallelism degree.

Description

technical field [0001] The invention relates to the field of massive performance data processing and calculation, in particular to a database reading and writing method for massive performance data of a network management system. Background technique [0002] With the rapid development of mobile communication and the continuous increase of network element equipment, the network element management system stores more and more performance data. At this time, the efficiency of reading and writing data in the database is becoming more and more important. up. In the engineering of the network management system, it is often encountered that the server hardware cannot be upgraded, and a large amount of performance data is generated every day, which will inevitably lead to a decrease in the efficiency of reading and writing the database, and problems such as data loss and query timeout will seriously affect the network management system. Stability, so there is a need for a method th...

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/215G06F16/23
CPCG06F16/215G06F16/2282G06F16/258
Inventor 喻辉李鹏胡涛
Owner WUHAN HONGXIN TELECOMM 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