Apparatus and method for saving historical data

A technology of historical data and data, applied in the field of network management historical data storage, can solve the problems of time-consuming, no data management in the data table, failure to query historical data, etc., to reduce the probability of failure, increase availability, and ensure the effect of speed

Inactive Publication Date: 2008-06-25
ZTE CORP
View PDF0 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In this way, since the database table has added an index for query efficiency, the data insertion operation after the database table is too large needs to be addressed in the index, which will consume more time, and may be due to the time when the table is locked when historical data is stored. Too long will cause users to fail to quer

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
  • Apparatus and method for saving historical data
  • Apparatus and method for saving historical data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0016] The method and device for storing historical data of the present invention will be described in detail below in conjunction with the accompanying drawings.

[0017] In order to solve the problem in the prior art that the historical data table of the network management is too large, which causes the locking time of table inserting data to be too long and affects the normal query of historical data by users. The method and device for storing historical data provided by the present invention provide a method and device for storing historical data using two data tables.

[0018] The principle of the method for preserving historical data of the present invention is that when the historical data in this table exceeds a certain amount of data, the historical data in this table is transferred in the dump table, and its method flow is described as follows:

[0019] Step 1. Set a data volume upper limit for the original table that saves historical data to control the data volume ...

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 storing historical data, and relates to the storing of network management historical data. The invention is invented to solve the problem existing in the prior art that the historical data sheet is too large to cause the locking time for the sheet to be inserted with data to be overlong and influence the user to normally inquiry the historical data. The method for storing the historical data comprises the following steps: firstly, the data quantity upper limit of the sheet is set; secondly, whether the historical data in the sheet exceeds the data quantity upper limit is judged. If the historical data in the sheet exceeds the data quantity upper limit, the historical data part which exceeds the data quantity upper limit is inserted to a dump sheet, and is deleted from the sheet. The corresponding device of the invention comprises an original sheet provided with a data appending interface and a data inquiry interface, and also comprises a dump sheet, and the dump sheet is provided with a data inquiry interface. A data transferring interface is arranged between the dump sheet and the original sheet. The invention is mainly applied to store the historical data in a network management system.

Description

technical field [0001] The invention relates to a method and a device for storing data, in particular to a method and a device for storing network management historical data. Background technique [0002] In many existing management systems, system data needs to be backed up in real time, and historical data generated by backup often takes up too much space. For example, for a DWDM (Dense Wavelength Division Multiplexing) system, each board of the network element will report 15 minutes of historical performance data to the network management every 15 minutes, even if it is kept in the database for 3 months according to the minimum requirements of the project Historical performance data, in the case of configuring all 32 waves and 100 network elements, the space occupied by historical performance data is also about 8G. Taking the 15-minute historical performance data of the transmission network management system as an example, the network element regularly reports the histor...

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
IPC IPC(8): H04L12/24G06F17/30
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap