Data audits based on timestamp criteria in replicated data bases within digital mobile telecommunication system

• US 5,937,413 A
• Filed: 11/07/1997
• Issued: 08/10/1999
• Est. Priority Date: 11/30/1994
• Status: Expired due to Term

• Current Assignee: Pendragon Electronics and Telecommunications Research LLC (Pendrell Corporation)
• Original Assignee: Electronics and Telecommunications Research Institute
• Inventors: Kim, Sung-Hee, Hyun, Eun-Hee
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Alam, Hosain T.
• Application Number:
  US08/965,767
• Time in Patent Office: 641 Days
• Field of Search: 707/1, 707/7, 707/8, 707/10, 707/201, 707/202-203, 455/413, 455/433, 395/182.18, 395/200.33
• US Class Current: 1/1
• CPC Class Codes: G06F 16/215 Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
• CPC Class Codes: G06F 16/2308 Concurrency control transaction processing G06F9/466
• CPC Class Codes: Y10S 707/99938 Concurrency, e.g. lock management in shared database
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

The present invention provides a method which uses a data audit function in order to maintain a consistency about a plurality of data stored as a replication data among data base nodes consisting of a mobile communication system. The method for auditing data based on timestamp criteria in replicated data bases in a digital mobile telecommunication system includes the steps of: (a) when there is a database access request, setting a time stamp about tuple accessed by the request, and managing a start, suspend, stop and resume events for a audit process; (b) managing a current status of the audit process, and information necessary for scanning each tuple; and (c) managing a request queue for the data base and CPU load. Accordingly, the present invention satisfies a system basic requirement being a real-time access in a mobile communication system including at least two data bases, maintains a consistency between two data replicated to each other, accurately controls a relationship between a mobile subscriber and a mobile terminal, and removes the incorrect data and the garbage data which may occur in a system operation, thereby effectively using the data base resource.

Claims

1. A method for auditing data based on timestamp criteria in replicated data bases in a digital mobile telecommunication system, comprising the steps of:

(a) when there is a database access request, setting a time stamp about tuple accessed by the request, and managing a start, suspend, stop and resume events for a audit process;

(b) managing a current status of the audit process, and information necessary for scanning each tuple; and

(c) managing a request queue for the data base and CPU load.

2. A method for checking a data validity in software modules including a database monitor, a data audit process, and data verifier in each data base, comprising:

a) first step for performing a data audit process through the database monitor in order to ensure a consistency among registers for storing/managing information for a mobile subscriber in a mobile communication network environment and other register for storing information for a mobile equipment, and performing a data validity check;

b) second step for setting timestamp every a stored tuple is searched or updated, determining the tuple as an invalid data if there is no operation for a given time which is defined as a system parameter during data auditing, and determining incorrect and garbage data for a data validity check; and

c) third step for requesting other data base having a replicated data of the tuple to perform a data search when the tuple being the invalid data is reported to the data base monitor, receiving a result of the data search, comparing the result with data of the data verifier, determining the data as a valid data and setting a new timestamp if the data of the data verifier is identical with the data search result, if the data of the data verifier is not identical with the data search result, requesting a paging of a subscriber having the data, modifying the data as other data obtained by a response against the paging, and deleting the data of the subscriber in the data base if there is no response against the paging.

3. The method according to the claim 2, wherein the step (a) comprises:

(a) first step for managing a system parameter such as an audit period or a data lifetime for a data auditing, the system parameter being modified by an operator through an operation command;

(b) second step for starting the audit process on the basis of the audit period which is defined at initial time point of the system or modified by the operator;

(c) third step for monitoring a request queue and load of the data base, when the request queue and the load are over a limit level defined by the system and a corresponding audit process is performed, and suspending the audit process; and

(d) fourth step for resuming the suspended audit process if the data base load is lower than the limit level.

4. The method according to claim 2, wherein the data audit process is activated by a audit processing start command of the operator or by a period managed by the data base monitor.

5. The method according to claim 4, wherein the data audit process already activated is incompletely terminated by an audit processing stop command.

6. A method for auditing data in data audit process having four states being an idle state, operator active state, active state, and sleep state, comprising:

a) first step for transitting the idle state to the operator active state when the idle state receives an audit processing start command by the operator active state;

b) second step for transitting the idle state to the active state when the idle state receives the audit processing start command through an audit period;

c) third step for transitting the operator active state to the sleep state when the operator active state receives the audit processing suspend command;

d) fourth step for transitting the active state to the sleep state when an overload of data base is sensed in the active state;

e) fifth step for transitting the sleep state to the operator active state when the sleep state receives the audit processing resume command from the operator; and

f) sixth step for transitting the sleep state to the active state when the overload of data is released.