Database operating and scheduling method and device for performance data acquisition system

A technology of data acquisition system and scheduling method, which is applied in the information field, can solve problems affecting system availability, large database load, and superposition, and achieve the effects of improving system availability, avoiding overload, and sharing pressure

Active Publication Date: 2013-06-12
ZTE CORP
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In the current performance data collection system, these operations involving the database are not well planned in terms of execution timing. The storage of performance data is done after the performance data collection is completed, and periodic report generation with larger granularity and expired data are stored. Deletion is scheduled by a timer. Since the relevance and timeliness of these database operations are not considered, this scheduling method itself may be invalid. For example, when a 30-minute report needs to be generated, the data of the first 30 minutes is not completely saved Complete, affecting the correctness of the generated data; at the same time, such scheduling may cause different database operations to overlap at the same time, resulting in excessive database load
In addition, in the prior art, the selection of the acquisition cycle often does not consider the time-consuming data acquisition and storage, which will also lead to the superposition of related database operations, making the bottleneck caused by the database load affect the availability of the system itself
[0004] Therefore, in order to overcome the database-related data storage, report generation, and expired data processing operations (mainly including expired data deletion and dump operations) in the performance data acquisition system, the operations that constitute database pressure are not well planned in terms of execution timing, resulting in The database load is too large, which makes the database load the bottleneck of the system, and the invalid operation problem caused by not considering the timeliness. It is urgent to develop a new scheduling scheme for database operations of the performance data acquisition 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 operating and scheduling method and device for performance data acquisition system
  • Database operating and scheduling method and device for performance data acquisition system
  • Database operating and scheduling method and device for performance data acquisition system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] The present invention will be described in further detail below in conjunction with the accompanying drawings and specific embodiments.

[0029] figure 1 It is a functional block diagram of the database operation scheduling method for the performance data collection system of the present invention. As shown in the figure, the database operation scheduling method for the performance data collection system of the present invention specifically includes:

[0030] The period dividing step is used to divide the performance data collection period into two parts: a performance data storage period and a non-performance data storage period, wherein the performance data storage period is dedicated to performing performance data storage operations. This period begins when the performance data collection is completed, and it is guaranteed that the collected data within this period can be stored completely. Delineate a dedicated period for performance data storage operations, and t...

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 database operating and scheduling method for a performance data acquisition system, which comprises: a period division step for dividing a performance data acquisition period into a performance data storage period and a non performance data storage period, wherein the performance data storage period is special for executing performance data storage; a task addition step for creating two task queues, wherein one task queue is used for storing a report generating task, and the other task queue is used for storing an expired data processing task; and a task execution step for taking the task out of the two task queues to perform execution according to the execution principle that the report generating task is superior to the expired data processing task at the non performance data storage period. The method can effectively balance the database load and prevent overload of the database. The invention also provides a database operating and scheduling method for the performance data acquisition system corresponding to the method. The method and the device are particularly applicable in the performance data acquisition field of an equipment management system in the communication field.

Description

technical field [0001] The invention belongs to the field of information technology, and in particular relates to an operation scheduling method and device capable of balancing database loads in a performance data collection system. Background technique [0002] In the performance data collection system, it is often necessary to periodically collect various performance data from multiple collection points of the device. The collection point refers to the physical entity on the device that can provide performance data collection and statistics. Source of performance data. These performance data will be stored in the database, and data reports with larger granularity can be generated periodically. In order to prevent the data stored in the database from growing without limit, the expired data of these reports can also be periodically deleted or dump. [0003] In the current performance data collection system, these operations involving the database are not well planned in te...

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): G06F17/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