METHODS, SYSTEMS, AND STORAGE MEDIUMS FOR PROVIDING DATABASE MANAGEMENT SERVICES FOR A TELECOMMUNICATIONS SYSTEM

• US 20100037126A1
• Filed: 09/29/2009
• Published: 02/11/2010
• Est. Priority Date: 02/02/2004
• Status: Abandoned Application

• Current Assignee: AT&T Intellectual Property I LP (AT&T, Inc.), LYFT Incorporated
• Original Assignee: AT&T Intellectual Property I LP (AT&T, Inc.)
• Inventors: Andrews, Elisa, Greenstein, Stanley, Hoffner, Cynthia
• Application Number:
  US12/568,998
• Publication Number:
  US 20100037126A1
• Time in Patent Office: Days
• US Class Current: 715/215
• CPC Class Codes: H04L 41/024 using relational databases for representation of network management data, e.g. managing via structured query language [SQL]
• CPC Class Codes: H04L 41/145 involving simulating, designing, planning or modelling of a network

Abstract

Methods, systems, and storage mediums for database management services for a telecommunications system are provided. A method includes transferring, via a managed language application, raw data extracted from a legacy system to a first spreadsheet application macro. The method also includes merging, via the first spreadsheet application macro, selected portions of the raw data, and creating a first spreadsheet file that includes the merged data. The merged data relates each physical and virtual fiber of the telecommunications system to the merged data. The method further includes transferring, via the managed language application, the first spreadsheet file to another spreadsheet application macro, and generating, via the other spreadsheet application macro, a graphical drawing comprising a cable ring that includes fiber routes and telecommunications equipment. The graphical drawing is generated using the merged data.

Claims

1. A method for providing database management services for a telecommunications system, comprising:

transferring, via a managed language application, raw data extracted from a legacy system to a first spreadsheet application macro;

merging, via the first spreadsheet application macro, selected portions of the raw data, and creating a first spreadsheet file that includes the merged data, the merged data relating each physical and virtual fiber of the telecommunications system to the merged data;

transferring, via the managed language application, the first spreadsheet file to another spreadsheet application macro; and

generating, via the other spreadsheet application macro, a graphical drawing comprising a cable ring that includes fiber routes and telecommunications equipment, the graphical drawing generated using the merged data.

2. The method of claim 1, wherein the raw data includes a first set of raw data relating to telecommunications transmission lines.

3. The method of claim 2, wherein the raw data includes a second set of raw data relating to telecommunications equipment data.

4. The method of claim 3, wherein the raw data includes a third set of raw includes data relating to telecommunications wavelength division multiplexing data;

wherein the first, second, and third sets of raw data are extracted via respective first, second, and third routines of a network planning application.

5. The method of claim 1, wherein the data in the first spreadsheet file includes:

fiber locations;

a cable number;

a fiber channel number;

a WDM channel number;

a restriction code, if applicable;

a status code;

a date a fiber is placed in service; and

a sonet carrier identifier.

6. The method of claim 1, further comprising:

transferring, via the managed language application, a portion of the raw data comprising telecommunications wavelength division multiplexing data to a second spreadsheet application macro;

creating, via the second spreadsheet application macro, a second spreadsheet file, the second spreadsheet file comprising a listing of working and spare channels serviced by an enterprise, the working and spare channels identified by WDM location, WDM type, system identification numbers, and state.

7. The method of claim 1, wherein the cable ring drawing is represented by nodes, passthroughs, and cable lines.

8. A system for providing database management services for a telecommunications system, comprising:

a computer processing device; and

a managed language application and a network planning application executing on the host system, the managed language application and the network planning application implementing a method, comprising;

transferring, via the managed language application, raw data extracted from a legacy system to a first spreadsheet application macro;

merging, via the first spreadsheet application macro, selected portions of the raw data, and creating a first spreadsheet file that includes the merged data, the merged data relating each physical and virtual fiber of the telecommunications system to the merged data;

transferring, via the managed language application, the first spreadsheet file to another spreadsheet application macro; and

generating, via the other spreadsheet application macro, a graphical drawing comprising a cable ring that includes fiber routes and telecommunications equipment, the graphical drawing generated using the merged data.

9. The system of claim 8, wherein the raw data includes a first set of raw data relating to telecommunications transmission lines.

10. The system of claim 9, wherein the raw data includes a second set of raw data relating to telecommunications equipment data.

11. The system of claim 10, wherein the raw data includes a third set of raw includes data relating to telecommunications wavelength division multiplexing data;

wherein the first, second, and third sets of raw data are extracted via respective first, second, and third routines of the network planning application.

12. The system of claim 8, wherein the data in the first spreadsheet file includes:

fiber locations;

a cable number;

a fiber channel number;

a WDM channel number;

a restriction code, if applicable;

a status code;

a date a fiber is placed in service; and

a sonet carrier identifier.

13. The system of claim 8, further comprising:

transferring, via the managed language application, a portion of the raw data comprising telecommunications wavelength division multiplexing data to a second spreadsheet application macro;

creating, via the second spreadsheet application macro, a second spreadsheet file, the second spreadsheet file comprising a listing of working and spare channels serviced by an enterprise, the working and spare channels identified by WDM location, WDM type, system identification numbers, and state.

14. A storage medium including machine-readable computer program code for providing database management services for a telecommunications system, the storage medium including instructions for causing a computer to implement a method comprising:

providing database management services for a telecommunications system, comprising;

merging selected portions of raw data extracted from a legacy system, and creating a first spreadsheet file that includes the merged data, the merged data relating each physical and virtual fiber of the telecommunications system to the merged data; and

generating a graphical drawing comprising a cable ring that includes fiber routes and telecommunications equipment, the graphical drawing generated using the merged data.

15. The storage medium of claim 14, wherein the raw data includes a first set of raw data relating to telecommunications transmission lines.

16. The storage medium of claim 15, wherein the raw data includes a second set of raw data relating to telecommunications equipment data.

17. The storage medium of claim 16, wherein the raw data includes a third set of raw includes data relating to telecommunications wavelength division multiplexing data.

18. The storage medium of claim 14, wherein the data in the first spreadsheet file includes:

fiber locations;

a cable number;

a fiber channel number;

a WDM channel number;

a restriction code, if applicable;

a status code;

a date a fiber is placed in service; and

a sonet carrier identifier.

19. The storage medium of claim 14, further comprising instructions for implementing:

creating, a second spreadsheet file from a portion of the raw data comprising telecommunications wavelength division multiplexing data, the second spreadsheet file comprising a listing of working and spare channels serviced by an enterprise, the working and spare channels identified by WDM location, WDM type, system identification numbers, and state.

20. The method of claim 14, wherein the cable ring drawing is represented by nodes, passthroughs, and cable lines.