Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1998-04-02
2001-06-05
Choules, Jack (Department: 2177)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C379S207030
Reexamination Certificate
active
06243712
ABSTRACT:
FIELD OF THE INVENTION
This invention relates to a computer program that can create new operator services databases from all or parts of one or more existing operator services databases containing data information for the operation of data and voice audio telecommunication switches.
DESCRIPTION OF THE PRIOR ART
The configuration of telecommunication switches usually occurs in at least three environments. First, during the testing of switch hardware and software, a laboratory switch is configured to the requirements established for the test. Second, when a switch is sold to a customer, the switch is configured to the customer's specifications. Third, when a switch experiences a full failure, it often requires reconfiguration of the databases supporting the failed switch or configuration of new databases for an emergency backup switch or replacement switch. Normally, the configuration of telecommunication switches during these three environments requires the manual input of thousands and possibly millions of records of information. This process is extremely time consuming and can take weeks or months to complete.
In the first environment, telecommunication companies continually test new versions of switch software, peripheral devices and other hardware devices during the life of a telecommunication switch. When testing software or hardware, switch engineers design different operating environments to establish operating parameters of the new software or hardware. Data engineers manually input data to configure the operation of the switch for the designed test. Usually, the configuration of the testing environment is performed on a data build machine (computer). The configuration of the switch to simulate the desired testing operational conditions often involves retesting archived configurations or modified archived configurations. Otherwise, the testing configuration is accomplished by manual data entry.
In the second environment, telecommunication switches sold to customers are configured based on the customer's intended operational conditions and requirements. Usually, the configurations for new switches are manually built new data configurations without relying on existing database configurations. However, the configuration of the features, switching software and hardware is often adopted from other existing configurations.
The third operational environment is recovery of the switch after the switch has experienced a failure. These failures can result from equipment failure to natural disasters such as earthquakes, hurricanes or fires. Recovery of the failed switch sometimes requires the installation of an emergency backup switch. The emergency backup switch requires database configurations that replicate the databases in the damaged switch. Normally, the configuration of the emergency backup switch requires manual, time consuming input of data that will support specific customer features and routing of calls on the emergency backup switch. Having the ability to configure the telecommunication switch by transferring existing data information from known databases into new databases by automating the manual tasks of data entry would save considerable time, money and significantly improve productivity. In addition, instant access to many different switching systems is a critical task that currently requires many hours or days of research and manual browsing. A need exists for a robust process to automatically replace the current manual method data entry to configure operator services data for telecommunications switches.
SUMMARY
In order to automate the current manual data entry process of engineering operator services configuration databases, the computer program of this invention establishes a new database structure and mines source databases to load source operator services data into the new operator services database structure. The computer program is capable of searching for the desired data and automates many of the tasks for configuring a new operator services database from the source databases. This eliminates the current requirement for manual data entry for configuring new operator services databases for telecommunication switches.
This computer program is multifunctional allowing for the browsing of all operator services databases prior to the configuration. Once the target operator services databases are determined, the computer program creates a new data directory structure and selectively copies all or part of the data from the source operator services databases into the new database.
The invention selects the source databases, determines whether the operator services database supports European Transmission Standard Interface (ETSI), Alternate Mark Inversion (AMI), or both and modifies the equipment numbers and network addresses. The program removes the operator services positioning system (OSPS) equipment or network addresses for digital subscriber line (DSL) assignments, transmission control protocol/Internet protocol (TCP/IP) DSL equipment, IP addresses to ports information, IP access numbers and ETSI ISDN/OSPS numbers. The program modifies the equipment and network addresses with the new data relating to the new location of the equipment numbers and addresses. The computer program performs a series of queries regarding the OSPS configuration and extracts the data. The data is evolved to the same software release if needed, and loaded into the new OSPS data directory structure.
This invention provides accurate and timely customer information, significantly decreases the time interval for engineering a new operator services database, decreases the research and data entry time, decreases the interval for lab planning and project management, improves database integrity, provides a cleaner operator services database, reuses existing operator services data eliminating double data entry, reuses some existing software code, use preexisting tools, and provides a platform for future growth and expandability. By accomplishing these tasks, the telecommunication switch manufacturer or telecommunication switch operator saves time, money and decreases time-to-market product and service schedules.
REFERENCES:
patent: 5274802 (1993-12-01), Altine
patent: 5414812 (1995-05-01), Filip
patent: 5506897 (1996-04-01), Moore et al.
patent: 5625804 (1997-04-01), Cooper
patent: 5875242 (1999-02-01), Glaser et al.
patent: 5937048 (1999-08-01), Pelle
patent: WO 0 96 25715 (1996-08-01), None
Venkatraman B. R.: “Subscriber Profile Manager: A Customer Network Management Tool” Proceedings of the Network Operations and Management Symposium (NOMS), US, New York, IEEE vol. SYMP. 4, Feb. 14, 1994, XP000452404.
Lennert Joseph Francis
Mahaney William T.
Watson Eric B.
Choules Jack
Lucent Technologies - Inc.
LandOfFree
Method for creating and modifying similar and dissimilar... 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 for creating and modifying similar and dissimilar..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for creating and modifying similar and dissimilar... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2469308