Patent ID: 6317733
Filing Date: 2001-11-13
Classification: H04Q,Y10S

Abstract:
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 ofreceiving 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, andperforming 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 ofmaintaining 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, andthe 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.