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

• US 20050169260A1
• Filed: 02/02/2004
• Published: 08/04/2005
• Est. Priority Date: 02/02/2004
• Status: Active Grant

• Current Assignee: AT&T Intellectual Property I LP (AT&T, Inc.), LYFT Incorporated
• Original Assignee: At&T Delaware Intellectual Property, Inc. (AT&T, Inc.)
• Inventors: Andrews, Elisa, Greenstein, Stanley, Hoffner, Cynthia
• Granted Patent: US 7,636,351 B2
• Time in Patent Office: Days
• US Class Current: 370/389
• 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

Embodiments relate to a method, system, and storage medium for providing database management services for a telecommunications system. The method includes extracting a first set of raw data from a legacy system relating to telecommunications transmission lines via a first routine of a network planning application. The method further includes extracting a second set of raw data from the legacy system relating to telecommunications equipment via a second routine of a network planning application. The method also includes extracting a third set of raw data from the legacy system relating to telecommunications wavelength division multiplexing data via a third routine of the network planning application. The method also includes generating a first spreadsheet file comprising data selected and combined by the first spreadsheet application macro. Utilizing a managed language application, the third set of raw data is also used by a second application macro to create a second spreadsheet application.

Claims

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

extracting a first set of raw data from a legacy system via a first routine of a network planning application, said first set of raw data relating to telecommunications transmission lines data;

executing a keystroke emulator on said first set of raw data operable for further extracting details relating to said telecommunications transmission lines data;

extracting a second set of raw data from said legacy system via a second routine of a network planning application, said second set of raw data relating to telecommunications equipment data;

extracting a third set of raw data from said legacy system via a third routine of said network planning application, said third set of raw data relating to telecommunications wavelength division multiplexing data;

utilizing a managed language application, transferring raw data resulting from said executing a keystroke emulator, said second set of raw data, and said third set of raw data to a first spreadsheet application macro, said first spreadsheet application macro operable for merging selected data; and

generating a first spreadsheet file comprising data selected and combined by said first spreadsheet application macro.

2. The method of claim 1, wherein said first spreadsheet file is a DETCAB worksheet comprising data relating each physical and virtual fiber to said data including:

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.

3. The method of claim 1, further comprising:

utilizing said managed language application, transferring said third set of raw data to a second spreadsheet application macro, said second spreadsheet application macro operable for merging selected data; and

generating a second spreadsheet file comprising data selected and combined by said second spreadsheet application macro;

wherein said second spreadsheet file is a WDM SUMMARY file comprising a listing of working and spare channels serviced by an enterprise, said working and spare channels identified by WDM location, WDM type, system identification numbers, and state.

4. The method of claim 2, further comprising:

utilizing said managed language application, transferring DETCAB worksheet to a third spreadsheet application macro, said third spreadsheet application macro operable for merging selected data; and

generating a graphical drawing comprising data selected and combined by said third spreadsheet application macro;

wherein said graphical drawing is a cable ring drawing including fiber routes and telecommunications equipment including a ring of;

nodes;

passthroughs; and

cable lines.

5. The method of claim 2, further comprising:

importing said DETCAB worksheet to a relational database with built-in queries; and

based upon a query presented to said relational database, generating a report.

6. The method of claim 1, wherein said first routine is an X02GETCABLE routine.

7. The method of claim 1, wherein said second routine is an X02SCIDSYS routine.

8. The method of claim 1, wherein said third routine is an X02WDMTABLE routine.

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

extracting a first set of raw data from a legacy system via a first routine of a network planning application, said first set of raw data relating to telecommunications transmission lines data;

executing a keystroke emulator on said first set of raw data operable for further extracting details relating to said telecommunications transmission lines data;

extracting a second set of raw data from said legacy system via a second routine of a network planning application, said second set of raw data relating to telecommunications equipment data;

extracting a third set of raw data from said legacy system via a third routine of said network planning application, said third set of raw data relating to telecommunications wavelength division multiplexing data;

utilizing a managed language application, transferring raw data resulting from said executing a keystroke emulator, said second set of raw data, and said third set of raw data to a first spreadsheet application macro, said first spreadsheet application macro operable for merging selected data; and

generating a first spreadsheet file comprising data selected and combined by said first spreadsheet application macro.

10. The storage medium of claim 9, wherein said first spreadsheet file is a DETCAB worksheet comprising data relating each physical fiber and virtual fiber, said data including:

fiber locations;

a fiber channel number;

a cable number;

a WDM channel number;

a restriction code, if applicable;

a status code;

a date a fiber is placed in service; and

a SCID identifier.

11. The storage medium of claim 9, further comprising instructions for causing said server to implement:

utilizing said managed language application, transferring said third set of raw data to a second spreadsheet application macro; and

generating a second spreadsheet file comprising data selected and combined by said second spreadsheet application macro;

wherein said second spreadsheet file is a WDM SUMMARY file comprising a listing of working and spare channels serviced by an enterprise, said working and spare channels identified by WDM location, WDM type, system identification numbers, and state.

12. The storage medium of claim 10, further comprising instructions for causing said computer to implement:

utilizing said managed language application, transferring DETCAB worksheet to a third spreadsheet application macro, said third spreadsheet application macro operable for merging selected data; and

generating a graphical drawing comprising data selected and combined by said third spreadsheet application macro;

wherein said graphical drawing is a cable ring drawing including fiber routes and telecommunications equipment including a ring of;

nodes;

passthroughs; and

cable lines.

13. The storage medium of claim 10, further comprising instructions for causing said server to implement:

importing said DETCAB worksheet to a relational database with built-in queries; and

based upon a query presented to said relational database, generating reports.

14. The storage medium of claim 9, wherein said first routine is an X02GETCABLE routine.

15. The storage medium of claim 9, wherein said second routine is an X02SCIDSYS routine.

16. The storage medium of claim 9, wherein said third routine is an X02WDMTABLE routine.

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

a server executing;

a legacy system program;

a network planning application including a first routine, a second routine, and a third routine;

a managed language application executing on said server, said managed language program including a first spreadsheet application macro, a second spreadsheet application macro, and a third spreadsheet application macro;

a legacy data repository in communication with said server via a communications network, said legacy data repository storing legacy tables and reports; and

a relational database in communication with said server via said communications network;

wherein said server performs;

extracting a first set of raw data from a legacy system via a first routine of a network planning application, said first set of raw data relating to telecommunications transmission lines data;

executing a keystroke emulator on said first set of raw data operable for further extracting details relating to said telecommunications transmission lines data;

extracting a second set of raw data from said legacy system via a second routine of a network planning application, said second set of raw data relating to telecommunications equipment data;

extracting a third set of raw data from said legacy system via a third routine of said network planning application, said third set of raw data relating to telecommunications wavelength division multiplexing data;

utilizing a managed language application, transferring raw data resulting from said executing a keystroke emulator, said second set of raw data, and said third set of raw data to a first spreadsheet application macro, said first spreadsheet application macro operable for merging selected data; and

generating a first spreadsheet file comprising data selected and combined by said first spreadsheet application macro.