Local exchange routing guide information maintenance system and method

• US 8,532,096 B2
• Filed: 02/01/2006
• Issued: 09/10/2013
• Est. Priority Date: 02/01/2006
• Status: Active Grant

• Current Assignee: Cisco Technology, Inc. (Cisco Systems, Inc.)
• Original Assignee: Cisco Technology, Inc. (Cisco Systems, Inc.)
• Inventors: Rao, Pramod S.
• Primary Examiner(s): Phillips, Hassan
• Assistant Examiner(s): SWEET, LONNIE V
• Application Number:
  US11/346,487
• Publication Number:
  US 20070189491A1
• Time in Patent Office: 2,778 Days
• Field of Search: None
• US Class Current: 370/389
• CPC Class Codes: H04Q 3/66 Traffic distributors

Abstract

The present invention system and method facilitates efficient and accurate maintenance of LERG information. The present system and method periodic implementation of LERG downloads permits network devices to automatically update LERG information. A local exchange routing guide update method includes performing an automated LERG maintenance initialization process; engaging in an automated LERG parsing process; and executing an automated LERG synchronization process.

Claims

1. A method comprising:

receiving data from a first content supplier and a second content supplier, wherein the data is an update for a local exchange routing guide (LERG) file;

providing a user interface for editing an extensible markup language (XML) configuration file;

parsing, with a networking device, the XML configuration file to identify scheduling information and mapping information included in the XML configuration file,

wherein the mapping information is configured to define a mapping between the LERG file and a local database,

generating a copy of the XML configuration file;

polling the copy of the XML configuration file according to the scheduling information;

wherein the scheduling information is configured to identify a time for the networking device to populate the local database with information from the update for the LERG file, and

in response to the time identified in the scheduling information in the XML configuration file, populating, with the networking device, the local database with information from the update for the LERG file based on the mapping information.

2. The method of claim 1, wherein the XML configuration file includes connection information corresponding to the local database, and wherein the populating of the local database with information from the update for the LERG file further comprises connecting with the local database according to the connection information from the XML configuration file.

3. The method of claim 1, wherein the scheduling information is configured to identify multiple periodic synchronization times for the local database to be updated with LERG information.

4. The method of claim 1, wherein the mapping information is configured to identify one or more columns in the local database to populate with corresponding columns from the LERG file.

5. The method of claim 1, further comprising

receiving the XML configuration file from a user interface device;

and

receiving the update for the LERG file from a remote device.

6. A device comprising:

a database device to store routing information and a configuration file;

a controller configured to identify scheduling information included in the configuration file, wherein the controller is configured to store a copy of the configuration file at an install directory according to the scheduling information;

a polling device configured to periodically poll the install directory for the copy of the configuration file;

wherein the controller is configured to route network traffic based on the routing information stored in the database device,

wherein the controller is configured to parse the copy of the configuration file to identify mapping information included in the configuration file, wherein the mapping information is configured to define a mapping between a local exchange routing guide (LERG) file and the database device,

wherein the scheduling information is configured to identify a time for the networking device to populate the local database with information from the LERG file,

wherein the configuration file is separate from the LERG file, and

wherein, in response to the time identified in the scheduling information in the configuration file, the controller is configured to populate the database device with the routing information based on the LERG file and the mapping information.

7. The device of claim 6, wherein the configuration file includes connection information corresponding to the database device, and wherein the populating of the database device further comprises connecting with the database device according to the connection information from the configuration file.

8. The device of claim 6, wherein the scheduling information is configured to identify a one-time synchronization of the LERG file and the database device or multiple periodic synchronization times for the database device to be updated with LERG information.

9. The device of claim 6, further comprising an input port to receive an updated LERG file, and wherein the controller is configured to populate the database device with information from the updated LERG file based on the mapping information in the configuration file and in response to the scheduling information in the configuration file.

10. The device of claim 6, wherein the mapping information is configured to identify one or more columns in the database device to populate with corresponding columns from the LERG file.

11. The device of claim 6, wherein the configuration file is in an Extensible Markup Language (XML).

12. An apparatus including a computer-readable memory device storing instructions configured to cause a controller to perform operations comprising:

receiving data from a first content supplier and a second content supplier, wherein the data is an update for a local exchange routing guide (LERG) file;

providing a user interface for editing an extensible markup language (XML) configuration file;

parsing the XML configuration file to identify scheduling information and mapping information included in the XML configuration file,

generating a copy of the XML configuration file;

polling the copy of the XML configuration file according to the scheduling information;

wherein the mapping information is configured to define a mapping between the LERG file and a local database,

wherein the scheduling information is configured to identify a time for the networking device to populate the local database with information from the update for the LERG file, and

wherein the XML configuration file is separate from the update for the LERG file; and

populating the local database with information from the update for the LERG file based on the mapping information and in response to the scheduling information in the XML configuration file.

13. The apparatus of claim 12, wherein the XML configuration file includes connection information corresponding to the local database, and wherein the populating of the local database with information from the update for the LERG file further comprises connecting with the local database according to the connection information from the XML configuration file.

14. The apparatus of claim 12, wherein the scheduling information is configured to initiate a one-time synchronization of the update for the LERG file and the local database based on the mapping information.

15. The apparatus of claim 12, wherein the scheduling information is configured to identify multiple periodic synchronization times for the local database to be updated with LERG information.

16. The apparatus of claim 12, wherein the mapping information is configured to identify one or more columns in the local database to populate with corresponding columns from the LERG file.

17. The apparatus of claim 12, wherein the instructions are further configured to cause the controller to perform operations comprising:

receiving the XML configuration file from a user interface device.