Data extraction process

• US 6,678,370 B1
• Filed: 09/21/1999
• Issued: 01/13/2004
• Est. Priority Date: 09/21/1999
• Status: Expired due to Fees

• Current Assignee: Verizon Laboratories Incorporated (Verizon Communications Inc.)
• Original Assignee: Verizon Laboratories Incorporated (Verizon Communications Inc.)
• Inventors: Jack, Carolyn M., Freebersyser, William T., Doleac, John S.
• Primary Examiner(s): DEANE JR, WILLIAM J
• Application Number:
  US09/401,013
• Time in Patent Office: 1,575 Days
• Field of Search: 379/279, 379/201.01, 379/112.02, 379/201.03, 379/201.05, 379/201.12, 379/221.04, 379/221.05, 379/221.06, 379/221.03
• US Class Current: 379/221.04
• CPC Class Codes: H04M 3/2263 Network management

Abstract

The system automatically generates electronic commands necessary to modify or provision different types of program control switches as may be included in a public switch telephone network. A data schema and organization of tables and data structures provide for command generation for each of the different switch types. Additionally, a self-modifying dynamic data structure is used as a common area to communicate information between various programs and formulate the commands due to a limited number of parameters used to communicate information between programs that generate the command for the switches. A technique for verifying switch commands automatically generated by a second new provisioning system is described. A technique is described for automatically extracting switch specific commands and options as generated by a first system for use in populating data stores used in a second system for command generation.

Claims

1. A method executed in a computer system of determining generated command options comprising:

determining a set of one or more working features generated by a first system, said set of one or more working features being determined in accordance with service options observed in accordance with usage of said first system;

determining said generated command options corresponding to said set of one or more working features, said generated command options being generated by said first system; and

using said generated command options and said set of one or more working features to populate data tables included in a second system for generating said generated command options in accordance with said set of one or more working features.

2. The method of claim 1, wherein said first system is an existing provisioning system and said second system is a new provisioning system replacing said first system.

3. The method of claim 1, wherein said first system and said second system generate commands for a telephone switch system including switch specific commands and command options.

4. The method of claim 1, wherein said set of one or more features are those features corresponding to at least one telephone subscription service.

5. The method of claim 1 further including:

for each switch identifier included in a switching network, generating a set of one or more orders in which each of said orders has a corresponding feature set of one or more working features determined in accordance with features actually in use by at least one current telephone subscriber;

for each of said orders, eliminating those working features from said corresponding feature set not used in determining a class of service;

for each of said orders, determining a service name corresponding to those working features used in determining a class of service; and

for each of said orders, using said service name, said features used in determining a class of service, and said generated command options corresponding to said features to populate said data tables used in said second system.

6. The method of claim 5, further including:

extracting said generated command options from commands generated by said first system.

7. The method of claim 6, wherein said generated command options are used in a public switch telephone network.

8. The method of claim 7, wherein said command options are determined in accordance with switch type of a switch included in said public switch telephone network.

9. The method of claim 1, wherein said first system is an electronic banking system, and said second system is an electronic banking system.

10. The method of claim 1, further including:

generating an order identifier corresponding to said set of one or more working features; and

storing order identifier information in an order identifier table, said order identifier information including said order identifier and said set of one or more working features.

11. The method of claim 1, further including:

generating, with said second system, a command including said generated command options using said data tables.

12. A system for determining generated command options comprising:

means for determining a set of one or more working features generated by a first system, said set of one or more working features being determined in accordance with service options observed in accordance with usage of said first system;

means for determining said generated command options corresponding to said set of one or more working features, said generated command options being generated by said first system; and

means for using said generated command options and said set of one or more working features to populate data tables included in a second system for generating said generated command options in accordance with said set of one or more working features.

13. The system of claim 12, wherein said first system is an existing provisioning system and said second system is a new provisioning system replacing said first system.

14. The system of claim 12, wherein said first system and said second system generate commands for a telephone switch system including switch specific commands and command options.

15. The system of claim 12, wherein said set of one or more features are those features corresponding to at least one telephone subscription service.

16. The system of claim 12 further including:

means for generating, for each switch identifier included in a switching network, a set of one or more orders in which each of said orders has a corresponding feature set of one or more working features determined in accordance with features actually in use by at least one current telephone subscriber;

means for eliminating, for each of said orders, those working features from said corresponding feature set not used in determining a class of service;

means for determining, for each of said orders, a service name corresponding to those working features used in determining a class of service; and

means for using said service name, said features used in determining a class of service, and said generated command options corresponding to said features, for each of said orders, to populate said data tables used in said second system.

17. The system of claim 16, further including:

means for extracting said generated command options from commands generated by said first system.

18. The system of claim 17, wherein said generated command options are used in a public switch telephone network.

19. The system of claim 18, wherein said command options are determined in accordance with switch type of a switch included in said public switch telephone network.

20. The system of claim 12, wherein said first system is an electronic banking system, and said second system is an electronic banking system.

21. The system of claim 12, further including:

means for generating an order identifier corresponding to said set of one or more working features; and

means for storing order identifier information in an order identifier table, said order identifier information including said order identifier and said set of one or more working features.

22. The system of claim 12, further including:

means for generating, with said second system, a command including said generated command options using said data tables.

23. A system for determining generated command options comprising:

machine executable code for determining a set of one or more working features generated by a first system, said set of one or more working features being determined in accordance with service options observed in accordance with usage of said first system;

machine executable code for determining said generated command options corresponding to said set of one or more working features, said generated command options being generated by said first system; and

machine executable code for using said generated command options and said set of one or more working features to populate data tables included in a second system for generating said generated command options in accordance with said set of one or more working features.

24. The system of claim 23, wherein said first system is an existing provisioning system and said second system is a new provisioning system replacing said first system.

25. The system of claim 23, wherein said first system and said second system generate commands for a telephone switch system including switch specific commands and command options.

26. The system of claim 23, wherein said set of one or more features are those features corresponding to at least one telephone subscription service.

27. The system of claim 23 further including:

machine executable code for generating, for each switch identifier included in a switching network, a set of one or more orders in which each of said orders has a corresponding feature set of one or more working features determined in accordance with features actually in use by at least one current telephone subscriber;

machine executable code for eliminating, for each of said orders, those working features from said corresponding feature set not used in determining a class of service;

machine executable code for determining, for each of said orders, a service name corresponding to those working features used in determining a class of service; and

machine executable code for using said service name, said features used in determining a class of service, and said generated command options corresponding to said features for each of said orders to populate said data tables used in said second system.

28. The system of claim 27, further including:

machine executable code for extracting said generated command options from commands generated by said first system.

29. The system of claim 28, wherein said generated command options are used in a public switch telephone network.

30. The system of claim 29, wherein said command options are determined in accordance with switch type of a switch included in said public switch telephone network.

31. The system of claim 23, wherein said first system is an electronic banking system, and said second system is an electronic banking system.

32. The system of claim 23, further including:

machine executable code for generating an order identifier corresponding to said set of one or more working features; and

machine executable code for storing order identifier information in an order identifier table, said order identifier information including said order identifier and said set of one or more working features.

33. The system of claim 23, further including:

machine executable code for generating, with said second system, a command including said generated command options using said data tables.