Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2000-10-26
2004-04-13
Alam, Shahid (Department: 2172)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C707S793000, C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
06721735
ABSTRACT:
TECHNICAL FIELD
The invention relates to the field of communications systems and, more specifically, to managing related data respectively stored in a plurality of databases in a network management system.
BACKGROUND OF THE INVENTION
It is often the case that related data may be stored in different databases. For example, a bank may store related data such as account information, credit history, customer data, etc., in different databases. It can be appreciated that over time related data associated with a particular account (i.e., a customer) may become inconsistent across the different databases. As such, when data associated with the account is selected by a particular banking application from one of the databases and processed, the end result may be incorrect because the selected data is not consistent with its associated data stored in the other databases.
As another example, in a telecommunications application, different data that is related in some way, e.g., facility, provisioning and maintenance data, may be stored in different databases. If a person enters a subscription for telephone services, the facilities to implement the subscription are selected from a provisioning database. However, the selected facilities may not actually be available. The reason for this may be, for example, that the facilities were marked unavailable due to maintenance activity and shown as such in a maintenance database, but were inadvertently left marked as available in the provisioning database. As such, a user would be unsuccessful in implementing the requested service as a result of trying to use facilities that were not available.
Currently, updates of database changes are done at set intervals such as at night globally, to specific tables and/or to parameters when the databases become inaccessible to users. Unfortunately, if a user were to access the respective database containing the database record before the update of the respective database, inconsistent data will be retrieved.
SUMMARY OF THE INVENTION
The invention comprises a method and apparatus for reducing inconsistencies between databases supporting the operation of a large telecommunications network.
Specifically, a method of synchronizing databases containing related information, comprising the steps of detecting a change to at least one database record in any of a first plurality of databases based on a first set of parameters; notifying a controller of the change; and updating, according to the detected change, each of a second plurality of databases containing the respective database record in response to a determination that the change falls within a second parameter.
REFERENCES:
patent: 5261094 (1993-11-01), Everson et al.
patent: 5471629 (1995-11-01), Risch
patent: 5649195 (1997-07-01), Scott et al.
patent: 5897632 (1999-04-01), Dar et al.
patent: 5933837 (1999-08-01), Kung
patent: 5953347 (1999-09-01), Wong et al.
patent: 5983268 (1999-11-01), Freivald et al.
patent: 6202067 (2001-03-01), Blood et al.
patent: 6256634 (2001-07-01), Moshaiov et al.
patent: 6347374 (2002-02-01), Drake et al.
patent: 6496838 (2002-12-01), Zamora-McKelvy et al.
H. Jagadish et al., “Scalable Versioning in Distributed Databases with Commuting Updates,”Proc. Data Eng., Apr. 1997, pp. 520-531.
T. Griffin et al., “A Framework for Using Redundant Data to Optimize Read-Intensive Database Applications,”Proc. Int'l Workshop on Real-Time Databases, Sep. 1997.
P. Bohannon et al., “Logical and Physical Versioning in Main Memory Databases,”Proc. VLDB, Aug. 1997.
Alam Shahid
Ehichioya Fred
Lucent Technologies - Inc.
LandOfFree
Method and apparatus for synchronizing databases in a... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and apparatus for synchronizing databases in a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for synchronizing databases in a... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3214572