Polling Method of Switch Status Based on Timer-triggered Scheduler of Stored Procedures

• US 20100179957A1
• Filed: 12/22/2009
• Published: 07/15/2010
• Est. Priority Date: 01/09/2009
• Status: Abandoned Application

• Current Assignee: Linkage Technology Group Company Limited
• Original Assignee: Linkage Technology Group Company Limited
• Inventors: ZHOU, JUNHUA, SONG, HAIHUA, LIU, GUOXIANG, SUN, LIBIN, HUANG, XIWEI
• Application Number:
  US12/645,048
• Publication Number:
  US 20100179957A1
• Time in Patent Office: Days
• US Class Current: 707/754
• CPC Class Codes: H04L 41/024 using relational databases for representation of network management data, e.g. managing via structured query language [SQL]
• CPC Class Codes: H04L 43/0817 by checking functioning
• CPC Class Codes: H04L 43/10 Active monitoring, e.g. heartbeat, ping or trace-route

Abstract

The polling method of switch status based on Timer-triggered Scheduler of Stored Procedures is to create interface tables related with switch status in the database including switch object table, switch type table, alarms information table which are used to store meta-information and switch status values. Then, create stored procedure of acquiring relevant switch status for each kind of switch needed for polling of switch status, and data will be filtered out and switch status will be judged via the related stored procedures, and write the status values into relevant switch status interface table; finally create regularly-executed tasks to regularly schedule each stored procedure required to poll switch status. The whole process is composed of three parts: i.e., create relevant switch status interface table; create stored procedure of acquiring switch status and setting status value; regularly-executed tasks.

Claims

1. A polling method of switch status based on Timer-triggered Scheduler of Stored Procedures is to create a lot of interface table related with switch status in the database including object tables, the switch type table, switch alarms table and network information table used to store meta-information and switch status values;

then create stored procedure of acquiring the corresponding switch status for all types of switch needed for polling of switch status;

the corresponding stored procedure will filter out data and determine the switch status, and then write the corresponding state value into switch status interface table;

finally create regularly-executed tasks for timer-triggered scheduler of stored procedures, including the establishment of the relevant switch status interface table;

access to switch status and set the stored procedure of the status value; and

stored procedure will be dispatched by regularly-executed tasks;

1) Create the related switch state interface table;

state of the relevant switch interface is a set of tables in the database to establish the state of switch and storage-related data tables for storing switch status information, including the switch object table, switch type table and alarm information table;

switch object table;

used to store the basic switch information and status information, the main fields, including “

switch object code”

, “

area codes”

, “

switch object name”

, “

switch type code”

, “

father switch ID “

, “

the state of switch alarms” and

“

switch working status”

;

switch type tables are shown as follow;

used to store information about switch type to distinguish which types each switch is belonging to in switch object table, its main fields including “

switch type code”

, “

switch type name” and

“

switch part of their process ID”

;

alarm information table;

used to store all switch alarm information in switch object table, the main field including “

switch ID”

, “

switch type code”

, “

fault-type number”

, “

alarm details”

, “

alarm canceled” and

“

alarm cancellation time”

;

create switch object table, switch types table, alert network information table in the database which are used to store meta-information and state information among which the switch number basic information and related warning information can be indexed using the switch type ID and the type of switch can be distinguished whether belonging to the host or the type of the process;

2) access switch status and set the state value of the stored procedure

the function is to be realized through a group of SQL statements programmed to access switch status and finish the storage function of its state value and through controlling the implementation of these SQL statements and then making judgment logically;

this set of SQL statements, and logic judgment program used to control the execution flow of these SQL statements are called stored procedure in BD technology;

these stored procedures can be stored in the database after being compiled;

users can specify the name of stored procedure and then once parameters are given, the procedure is to be implemented, compiling only needed while creating a stored procedures, afterwards, there is no need to re-compile when stored procedure is executed each time;

stored procedure of accessing to switch status of process is used to access to the status of application program switch;

its steps are shown as below;

a) create a database cursor from network object table and filter out the application type switch record;

b) start circulate the cursor records;

c) initialize parameters;

d) calculate the records with un-covered status from alarm record table, and of which the switch ID is equal to the current cursor record number;

e) determine whether the total number of alarm records is zero;

if it is zero, set the alarm state with the non-alarm;

f) or else, set alarm to the switch to which the current cursor recorded switch ID is equal in switch object table;

g) continue cycle the cursor until the last of the record;

h) finally, submit the modifications of all records;

access to stored procedure of the host switch status is used to obtain the host of the switch status, main steps are shown as follow;

a) create a database cursor, and from the switch object table, filter out host-type switch record;

b) start to circulate the record of the cursor;

c) initialize parameters;

d) calculate the totals of alarm record of which the status is not recovered and switch ID is equal to the host switch ID of the current cursor record number;

Calculate the totals of the switch object table of which the parent of the element number is equal to the current cursor record number of the host switch and also the totals of subset record with the alarm status of alarm;

e) determine whether both total alarm records number and total sub-switch record number are zero;

if it is both zero, set alarm status of the host switch with the non-alarm of which the same switch object table number is equal to the current cursor record;

f) or else, set the alarm status with alarm;

g) continue to circulate the record of the cursor until the last record;

h) finally, submit modifications of all records;

create stored procedures to access to the process'"'"'s switch status and the host'"'"'s switch status in the database to access or set state values of the switch status of process and host;

main steps of the processing for these two stored procedures are;

firstly, data indexing and data filtering treatment from the switch interface tables;

after filtering out the data, making judgments logically to obtain the status switch, and then update the status value to the state field in the relevant records from the switch object table;

3) stored procedure timer-triggered scheduled by regular tasks use regularly-executed task function in the database to establish a regularly-executed task;

set those procedures mentioned above to the tasks need to be executed, i.e., formerly-established stored procedures of accessing to switch status and host switch status;

then set a interval to execute this task, which can achieve the purpose of regularly inquiring switch status so that polling of switch status can be realized.

2. The polling method of switch status based on Timer-triggered Scheduler of Stored Procedures of claim 1, wherein by the manually edit of switch type table in the switch status interface tables, and it is used to define the switch type ID, type name of switch;

CLASS_ID field means the switch types number, when its value is 1, it means the host type;

except ALARM_STATE field which is set by the stored procedure in the switch object table, the other fields are automatically reported by the application procedure, in the switch object table, field ALARM_STATE says the alarm state, when its value is 1, it means it has alarm;

if it is 0, that means no alarm of the switch, WORK_STATE field in the switch object table says the work status of switch, and reported directly by the application procedure, when the value is 1, it means the switch is running, if 0, it indicates that the switch has ceased running;

all fields are automatically reported by network target in alarm information tables except the field CANCEL_BY that means recovery and field CANCEL_TIME means recovery time;

switch ID number field NE_ID in the alarm information table is correspondent with the switch NE_ID in the switch object table, through field the switch number, it can indexed out that what switch ID a alarm record is belonging to.

3. The polling method of switch status based on Timer-triggered Scheduler of Stored Procedures of claim 1, wherein to access to the process of switch status stored procedure and steps are:

to establish a database cursor named “

CR”

, select records of which field class_id value is not equal to 1 and field ENABLE value equal to 1 from the Switch object table;

name the cursor “

CR”

an alias as “

C1”

, start the cycle of the data record and initialize “

recnum”

variable 0 and “

v_neid”

variable i.e. current cursor number of switch that is “

C1.NE_ID”

;

calculate the alarm records of which the field “

cancel_by”

value is −

9 and the field NE_ID value is “

v_neid”

; and

then give the total number to “

recnum” and

at the same time to inquire whether the value is Zero, if zero then set the field alarm_state of which the NE_ID value is equal to “

v_neid”

value to Zero;

if “

recnum”

is non-zero, then set the field alarm_state to 1;

at last, to decide whether the current cursor is the last record or not, if not, continue to cycle, if yes, then terminate the cycle and submit all modifications records.

4. The polling method of switch status based on Timer-triggered Scheduler of Stored Procedures of claim 1, wherein to access to the process of host switch status stored procedure and steps are:

to establish a database cursor named “

CR”

, select records of which field class_id value is not equal to 1 and field ENABLE value equal to 1 from the Switch object table;

name the cursor “

CR”

an alias as “

C1”

, start the cycle of the data record and initialize “

recnum”

variable 0 and “

v_neid”

variable i.e. current cursor number of switch that is “

C1.NE_ID”

;

calculate the alarm records of which the field “

cancel_by”

value is −

9 and the field NE_ID value is “

v_neid”

; and

then give the total number to “

recnum” and

at the same time to inquire whether the value is Zero, if zero then set the field alarm_state of which the NE_ID value is equal to “

v_neid”

value zero;

if “

recnum”

is non-zero, then set the field alarm_state to 1;

at last, to decide whether the current cursor is the last record or not, if not, continue to cycle, or else, terminate the cycle and submit all modifications records.