Event recording in a service database system

• US 6,317,733 B1
• Filed: 02/16/1999
• Issued: 11/13/2001
• Est. Priority Date: 08/29/1996
• Status: Expired due to Fees

• Current Assignee: Nokia Telecommunications Oy (Nokia Corporation)
• Original Assignee: Nokia Telecommunications Oy (Nokia Corporation)
• Inventors: Lehtinen, Pekka
• Primary Examiner(s): Choules, Jack
• Assistant Examiner(s): BLACK, LINH
• Application Number:
  US09/250,092
• Time in Patent Office: 1,001 Days
• Field of Search: 707/1-10, 379/88.11, 379/88.17, 379/88.19, 379/219-232
• US Class Current: 1/1
• CPC Class Codes: H04Q 3/0079 involving restoration of networks, e.g. disaster recovery, self-healing networks
• CPC Class Codes: Y10S 707/99931 Database or file accessing

Abstract

The invention relates to a method of handling the event recordings in a service database system. The database comprises measurement tables (MT) which include consecutive rows (Ri). A single row comprises data about a single measurement object. In order to be able to share the processor load evenly (a) the counters on the measurement table row have been duplicated, and in every recording interval the counter values of a given counter group on said row are incremented, and the counter values of another counter group on the same row are recorded according to a predefined rotation principle, and (b) the recording and zeroing process of the counters is started during each recording interval repeatedly at short intervals, and during each startup the processing is performed on a limited portion of the measurement objects included in the measurement group.

Claims

1. A method for performing event recordings in a service database system, the database comprising measurement tables (MT) which comprise consecutive rows (Ri), whereby a single row comprises data related to a single measurement object and the measurement objects of one measurement table are of the same type so that they form a measurement group, the method comprising the steps of

receiving service requests (SR) into the system during whose processing it is necessary to count the number of events occurring per each measurement object,

activating the provision of the service as a response to the service request,

performing the recording of events by incrementing the measurement object-specific counters for each different event during the processing of the service request for a time determined by a certain, predefined recording interval, and

performing the recording of counter values by storing the measurement object-specific counter values after each recording interval,

characterized in that the method further comprises the steps of

maintaining a single measurement counter copied to N copies on the row of the measurement table so that each of the N counters belongs to a different counter group, whereby N counter groups are located on the row,

dividing time domain into consecutive recording intervals (TP) so that only the values of a selected counter group located on the row are incremented during each recording interval, and the counter group to be incremented is changed from one recording interval to another,

handling the recording and zeroing of counter values during a recording interval one measurement object at a time by processing the rows of the measurement table one at a time so that the recording and zeroing of the counter values of a single counter group is performed during the recording intervals which are left between the recording intervals during which the counters of the counter group in question are incremented, and

the recording and zeroing process of the counter values is started during each recording interval repeatedly at short intervals and during each startup a limited portion of the measurement objects included in the measurement group are processed, and a variable is maintained in the system which specifies the maximum number of measurement table rows whose counter values can be processed during a single startup, whereby during a single processing the counters are at least zeroed.

2. A method according to claim 1, characterized in that each counter on the row corresponding to the measurement object is maintained as a duplicate, whereby the first counter belongs to the first counter group (CG1), and the second counter in the second counter group (CG2), and the counter values of the first counter groups are incremented and the counter values of the second counter groups are recorded and zeroed during every second recording interval, and the counters of the second counter groups are incremented and the counter values of the first counter groups are recorded and zeroed during the alternate recording interval.

3. A method according to claim 2, characterized in that if there has not been enough time to process the counter values on all measurement table rows by the next changing moment of the recording interval, the rows which are not yet processed are left entirely unprocessed.

4. A method according to claim 2, characterized in that a measurement group-specific flag is maintained in the system which indicates when all counter groups of all objects of the measurement table which correspond to the current recording interval have been processed during the current recording interval.

5. A method according to claim 4, characterized in that the processing of counters is skipped during all startups in which the process detects that said flag is set.

6. A method according to claim 5, characterized in that time stamps which indicate the two latest moments at which the row was processed are maintained on the row of a single object and said time stamps are updated during each time that the row is processed.

7. A method according to claim 1, characterized in that the during each startup of the recording and zeroing process of the counters it is checked whether the value of the recording interval length has been changed by a user.

8. A method according to claim 1, characterized in that during each startup of the recording and zeroing process of the counters it is checked whether the measurement related to the measurement group has been activated or deactivated since the previous startup.

9. A method according to claim 1, characterized in that the during each startup of the recording and zeroing process of the counters it is checked whether the measurement related to the measurement object has been activated or deactivated since the previous startup.

10. A method according to claim 1, characterized in that the startup is executed 10 to 1000 times during one recording interval.