System and method for network element database population

• US 7,277,882 B1
• Filed: 03/29/2002
• Issued: 10/02/2007
• Est. Priority Date: 03/29/2002
• Status: Expired due to Fees

• Current Assignee: Bellsouth Intellectual Property Corporation (AT&T, Inc.)
• Original Assignee: AT&T Intellectual Property I LP (AT&T, Inc.)
• Inventors: Walters, Jon Timothy, O'Steen, Roberta R., Hodges, Jr., Charles Y., Huff, Leslie, Reddick, Linda
• Primary Examiner(s): RIMELL, SAMUEL G
• Application Number:
  US10/109,912
• Time in Patent Office: 2,013 Days
• Field of Search: 707 1- 3, 707/104.1, 707/100, 370/410, 709/219, 379/265.09
• US Class Current: 1/1
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

In an illustrative method for populating a database for use in automated administration of network elements, data that describes network elements in a telecommunication system is aggregated from existing systems. The aggregated data is formatted for loading into the telecommunication system. The formatting may include, for example, creating circuit data that identifies circuits, or groupings, that exist in the telecommunication system. The formatting may also comprise formatting network element data to conform to a new database format. Thereafter, the network element data is loaded into the new database. This step may comprise loading the circuit data and the network element data. Finally, the results of the load operation, including any error messages, are retrieved.

Claims

1. A method for loading network element data from a first database resident in a first computing device to a second database resident in a second computing device, comprising:

receiving network element data from the first database identifying network elements in a communications network, the network elements being individual pieces of equipment;

creating from the network element data grouping data identifying logical groupings of network elements that exist in the communications network;

creating from the network element data target data identifying the network elements;

reformatting the network element data and the target data for loading into the second database; and

loading the reformatted network element data and target data into the second database for use by the second computing device for provisioning network elements,

wherein creating grouping data comprises creating data identifying network elements that are members of a SONET ring by specifying at least a SONET ring carrier ID (SCID) among the members of the SONET ring as a name for the logical grouping.

2. The method of claim 1, further comprising requesting a directory location of the network element data to be loaded.

3. The method of claim 2, further comprising retrieving the network data from the directory location.

4. The method of claim 1, wherein reformatting the network element data and the target data is accomplished by a method selected from a group of methods comprising at least one of renaming a data element changing the capitalization of a data element and assigning default values to a data element.

5. The method of claim 1, further comprising retrieving data identifying the results of loading the network element data and target data.

6. A computer readable medium having computer executable instructions thereon for performing the following:

receiving network element data from a first database identifying network elements in a communications network, the network elements being individual pieces of equipment;

creating from the network element data grouping data identifying logical groupings of network elements that exist in the communications network;

creating from the network element data target data identifying the network elements;

reformatting the network element data and the target data for loading into a second database; and

loading the network element data and target data into the second database for use by a system for provisioning network elements,

wherein creating grouping data comprises creating data identifying network elements that are members of a SONET ring by specifying at least a SONET ring carrier ID (SCID) among the members of the SONET ring as a name for the logical grouping.

7. The computer readable medium of claim 6, further comprising executable instructions stored thereon for requesting a directory location of the network element data to be loaded.

8. The computer readable medium of claim 7, further comprising executable instructions stored thereon for retrieving the network data from the directory location.

9. The computer readable medium of claim 6, wherein the logical grouping is defined by data items selected from a group of data items comprising at least one of target_group_name, source_identification, duplicate_detection, aging_timer and group_logging.

10. The computer readable medium of claim 6, further comprising executable instructions stored thereon for retrieving data identifying the results of loading the network element data and target data.

11. A system for loading network element data, comprising:

a processor operable to execute computer executable instructions;

a memory, said memory having stored therein computer executable instructions for performing the following;

receiving network element data identifying network elements in a communications network, the network elements being individual pieces of equipment;

creating from the network element data in a first database grouping data identifying logical groupings of network elements that exist in the communications network;

creating from the network element data target data identifying the network elements;

reformatting the network element data and the target data for loading into a second database; and

loading the network element data and target data into the second database for use by a system for provisioning network elements,

wherein creating grouping data comprises creating data identifying network elements that are members of a SONET ring by specifying at least a SONET ring carrier ID (SCID) among the members of the SONET ring as a name for the logical grouping.

12. The system of claim 11, wherein said memory has stored therein computer executable instructions for requesting a directory location of the network element data to be loaded.

13. The system of claim 12, wherein said memory has stored therein computer executable instructions for retrieving the network data from the directory location.

14. The system of claim 11, wherein said memory has stored therein executable instructions for retrieving data identifying the results of loading the network element data and target data.