What is claimed is:
1. A membership management method in a membership management system comprising at least one user terminal connected via a network, a database held by each of a plurality of service provision sites, and a database held by an integrated membership management center, wherein when a user makes an application for a registration of membership information to one service provision site by using said user terminal, the application-requested service provision site registers at least a part of the membership information into a database held by the service provision site, and when this membership information has not yet been registered in a database held by the integrated membership management center, the integrated membership management center also registers this membership information into the database held by the integrated membership management center.
2. A membership management system comprising at least one user terminal connected via a network, a database held by each of a plurality of service provision sites, and a database held by an integrated membership management center, wherein each service provision site comprises: membership registration guidance display means for requesting a user to register membership information; means for guiding the user to obtain from a user terminal the membership information that has been input from the user terminal based on the guidance of the membership registration guidance display means; means for requesting the integrated membership management center to register the membership information; means for obtaining from the integrated membership management center the information about whether the requested membership information has already been registered in the integrated membership management center or the integrated membership management center has registered the requested membership information as new registration; and means for posting to the user terminal a user ID and a password that have been authenticated by the integrated membership management center.
3. The membership management system according to claim 2, wherein the integrated membership management center comprises: means for searching for a record that coincides with user information when this means has received from a service provision site a request for registering membership information; means for preparing a user ID and a password and adding these to a database when there is no record that coincides with the registration-requested membership information as a result of the searching; means for adding a service qualification to the user to enable the user to receive services of the service provision site when there is a record that coincides with the registration-requested membership information as a result of the searching; and means for posting the user ID and the password authenticated by the integrated membership management center to the service provision site.
4. The membership management system according to claim 2, wherein the membership registration guidance display means requests a user to input items of membership information that are necessary for the integrated membership management center even if these pieces of information are not necessary for the service provision site.
5. An integrated membership management center that is connected to a plurality of service provision sites and to at least one user terminal via a network, the integrated membership management center comprising a database for registering new membership information that a user has used when the user has accessed a service provision site from a user terminal.
6. The integrated membership management center according to claim 5, further comprising: means for searching for a record that coincides with user information when this means has received from a service provision site a request for registering membership information; means for preparing a user ID and a password and adding these to a database when there is no record that coincides with the registration-requested membership information as a result of the searching; means for adding a service qualification to the user to enable the user to receive services of the service provision site when there is a record that coincides with the registration-requested membership information as a result of the searching; and means for posting the user ID and the password to the service provision site.
7. A service provision site comprising: membership registration guidance display means for requesting a user to register membership information; means for guiding the user to obtain from a user terminal the membership information that has been input from the user terminal based on the guidance of the membership registration guidance display means; means for requesting an integrated membership management center to register the membership information; means for obtaining from the integrated membership management center the information about whether the requested membership information has already been registered in the integrated membership management center or the integrated membership management center has registered the requested membership information as new registration; and means for posting to the user terminal a user ID and a password that have been authenticated by the integrated membership management center, wherein the membership registration guidance display means requests the user to input items of membership information that are necessary for the integrated membership management center even if these pieces of information are not necessary for the service provision site.
The claims below are in addition to those above.
All refrences to claim(s) which appear below refer to the numbering after this setence.
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 \u201cswitch object code\u201d, \u201carea codes\u201d, \u201cswitch object name\u201d, \u201cswitch type code\u201d, \u201cfather switch ID \u201c, \u201cthe state of switch alarms\u201d and \u201c switch working status\u201d;
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 \u201cswitch type code\u201d, \u201cswitch type name\u201d and \u201cswitch part of their process ID\u201d;
alarm information table: used to store all switch alarm information in switch object table, the main field including \u201cswitch ID\u201d, \u201cswitch type code\u201d, \u201cfault-type number\u201d, \u201calarm details\u201d, \u201c alarm canceled\u201d and \u201c alarm cancellation time\u201d;
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 \u201cCR\u201d, 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 \u201cCR\u201d an alias as \u201cC1\u201d, start the cycle of the data record and initialize \u201crecnum\u201d variable 0 and \u201cv_neid\u201d variable i.e. current cursor number of switch that is \u201cC1.NE_ID\u201d; calculate the alarm records of which the field \u201ccancel_by\u201d value is \u22129 and the field NE_ID value is \u201cv_neid\u201d; and then give the total number to \u201crecnum\u201d 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 \u201cv_neid\u201d value to Zero; if \u201crecnum\u201d 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 \u201cCR\u201d, 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 \u201cCR\u201d an alias as \u201cC1\u201d, start the cycle of the data record and initialize \u201crecnum\u201d variable 0 and \u201cv_neid\u201d variable i.e. current cursor number of switch that is \u201cC1.NE_ID\u201d; calculate the alarm records of which the field \u201ccancel_by\u201d value is \u22129 and the field NE_ID value is \u201cv_neid\u201d; and then give the total number to \u201crecnum\u201d 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 \u201cv_neid\u201d value zero; if \u201crecnum\u201d 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.