Method for creating and modifying similar and dissimilar databases for use in GSM wireless network configurations for telecommunication systems

• US 6,301,477 B1
• Filed: 04/02/1998
• Issued: 10/09/2001
• Est. Priority Date: 04/02/1998
• Status: Expired due to Fees

• Current Assignee: Lucent Technologies, Inc. (Nokia Corporation)
• Original Assignee: Lucent Technologies, Inc. (Nokia Corporation)
• Inventors: Mahaney, William T., Lennert, Joseph Francis, Zawiski, Curt R., Mahaney, Rowena F.
• Primary Examiner(s): Chang, Vivian
• Assistant Examiner(s): Nguyen, Duc
• Application Number:
  US09/054,324
• Time in Patent Office: 1,286 Days
• Field of Search: 455/433, 455/434, 455/435, 455/422, 455/461-62, 455/466, 379/207, 379/221, 379/279, 707/4, 707/102, 707/103, 707/104, 707/203
• US Class Current: 455/433
• CPC Class Codes: H04Q 3/0029 Provisions for intelligent networking
• CPC Class Codes: H04Q 3/54533 Configuration data, translation, passwords, databases
• CPC Class Codes: H04W 24/02 Arrangements for optimising operational condition
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

This invention uses a computer program to mine preexisting wireless data located in a variety of preexisting source GSM wireless network databases. The computer program either creates a new wireless database from parts of existing wireless databases or modifies an existing wireless database. The computer program replaces the current system'"'"'s reliance upon manual data entry by data engineers to configure the operation of a new telecommunication switch or replace the software in a telecommunication switch that was damaged or requires a new wireless network data configuration. This invention provides accurate and timely customer information, significantly decreases the time interval for engineering a new wireless database, decreases the research and data entry time, decreases the interval for lab planning and project management, improves wireless database integrity, provides a cleaner wireless database, reuses existing data eliminating double data entry, reuses some existing software code, and uses preexisting office data administration tools and provides a platform for future growth and expandability. By accomplishing these tasks, the telecommunication switch manufacturer or telecommunication switch operator saves time, money and decreases time-to-market product and service schedules.

Claims

1. A process for configuring a telephony management system that includes a GSM wireless database, the process comprising the steps of:

querying a plurality of source databases of the telephony management system for a predetermined plurality of data structures that are linked through one or more routines that rely on one or more tools located on a data build machine;

selecting the predetermined plurality of data structures;

modifying a subset of the predetermined plurality of data structures based on at least one preselected criterion;

inserting the subset of the predetermined plurality of data structures into the telephony management system;

wherein the step of selecting the predetermined plurality of data structures comprises the steps of;

selecting the predetermined plurality of data structures to comprise a first predetermined data structure that comprises feature information;

selecting the predetermined plurality of data structures to comprise a second predetermined data structure that comprises dialing information;

selecting the predetermined plurality of data structures to comprise a third predetermined data structure that comprises platform information;

wherein the plurality of source databases comprises a first source database, a second source database, and a third source database, wherein the first source database is different from the second source database, wherein the first source database and the second source database comprise different types of information, wherein the first source database is different from the third source database, wherein the second source database is different from the third source database;

wherein the step of querying the plurality of source databases of the telephony management system for the predetermined plurality of data structures that are linked through the one or more routines that rely on the one or more tools located on the data build machine comprises the steps of;

querying the first source database for the first predetermined data structure that comprises the feature information;

querying the second source database for the second predetermined data structure that comprises the dialing information;

querying the third source database for the third predetermined data structure that comprises the platform information.

2. The process of claim 1, wherein the step of modifying the subset of the predetermined plurality of data structures based on the at least one preselected criterion and the step of inserting the subset of the predetermined plurality of data structures into the telephony management system comprise the step of copying GSM wireless based data from a data structure of a source database of the plurality of source databases to a similarly sized data structure in a new database of the telephony management system.

3. The process of claim 1, wherein the step of modifying the subset of the predetermined plurality of data structures based on the at least one preselected criterion and the step of inserting the subset of the predetermined plurality of data structures into the telephony management system comprise the step of copying GSM wireless data from a data structure of a source database of the plurality of source databases to a dissimilarly sized data structure in a new database of the telephony management system.

4. The process of claim 1, wherein the step of querying the plurality of source databases of the telephony management system for the predetermined plurality of data structures and the step of selecting the predetermined plurality of data structures comprise the step of selecting the predetermined plurality of data structures to comprise subscriber identity confidentiality data.

5. The process of claim 1, wherein the step of querying the plurality of source databases of the telephony management system for the predetermined plurality of data structures and the step of selecting the predetermined plurality of data structures comprise the step of selecting the predetermined plurality of data structures to comprise subscriber identity authentication data.

6. The process of claim 1, wherein the step of querying the plurality of source databases of the telephony management system for the predetermined plurality of data structures and the step of selecting the predetermined plurality of data structures comprise the step of selecting the predetermined plurality of data structures to comprise signaling information data.

7. The process of claim 1, wherein the step of querying the plurality of source databases of the telephony management system for the predetermined plurality of data structures and the step of selecting the predetermined plurality of data structures comprise the step of selecting the predetermined plurality of data structures to comprise voice encoding confidentiality data.

8. The process of claim 1, wherein the step of querying the plurality of source databases of the telephony management system for the predetermined plurality of data structures and the step of selecting the predetermined plurality of data structures comprise the step of selecting the predetermined plurality of data structures to comprise subscriber equipment validation data.

9. The process of claim 1, wherein the step of querying the plurality of source databases of the telephony management system for the predetermined plurality of data structures and the step of selecting the predetermined plurality of data structures comprise the step of selecting the predetermined plurality of data structures to comprise subscriber location data.

10. The process of claim 9, wherein the step of selecting the predetermined plurality of data structures to comprise the subscriber location data comprises the step of selecting the subscriber location data to comprise initial registration data.

11. The process of claim 9, wherein the step of selecting the predetermined plurality of data structures to comprise the subscriber location data comprises the step of selecting the subscriber location data to comprise location update registration data.

12. The process of claim 1, wherein the step of inserting the subset of the predetermined plurality of data structures into the telephony management system comprises the step of creating a new database.

13. The process of claim 1, wherein the step of inserting the subset of the predetermined plurality of data structures into the telephony database management system comprises the step of updating a preexisting database.

14. The process of claim 1, wherein the step of selecting the predetermined plurality of data structures to comprise the first predetermined data structure that comprises the feature information comprises the step of:

selecting the predetermined plurality of data structures to comprise a first predetermined data structure that comprises rate and routing information;

wherein the step of selecting the predetermined plurality of data structures to comprise the second predetermined data structure that comprises the dialing information comprises the step of;

selecting the predetermined plurality of data structures to comprise a second predetermined data structure that comprises a first portion of switch module configuration information and networking rate and routing information;

wherein the step of selecting the predetermined plurality of data structures to comprise the third predetermined data structure that comprises the platform information comprises the step of;

selecting the predetermined plurality of data structures to comprise a third predetermined data structure that comprises a second portion of the switch module configuration information that is different from the first portion of the switch module configuration information;

wherein the step of querying the first source database for the first predetermined data structure that comprises the feature information comprises the step of;

querying the first source database for the first predetermined data structure that comprises the rate and routing information;

wherein the step of querying the second source database for the second predetermined data structure that comprises the dialing information comprises the step of;

querying the second source database for the second predetermined data structure that comprises the first portion of the switch module configuration information and the networking rate and routing information;

wherein the step of querying the third source database for the third predetermined data structure that comprises the platform information comprises the step of;

querying the third source database for the third predetermined data structure that comprises the second portion of the switch module configuration information.

15. A process for configuring a telephony management system that includes a GSM wireless database, the process comprising the steps of:

querying a plurality of source databases of the telephony management system for a predetermined plurality of data structures that are linked through one or more routines that rely on one or more tools located on a data build machine;

selecting the predetermined plurality of data structures;

selecting a configuration type for a home location register of the telephony management system;

modifying a subset of the predetermined plurality of data structures based on at least one preselected criterion; and

inserting the subset of the predetermined plurality of data structures into the telephony management system

wherein the step of selecting the predetermined plurality of data structures comprises the steps of;

selecting the predetermined plurality of data structures to comprise a first predetermined data structure that comprises feature information;

selecting the predetermined plurality of data structures to comprise a second predetermined data structure that comprises dialing information;

selecting the predetermined plurality of data structures to comprise a third predetermined data structure that comprises platform information;

wherein the plurality of source databases comprises a first source database, a second source database, and a third source database, wherein the first source database is different from the second source database, wherein the first source database and the second source database comprise different types of information, wherein the first source database is different from the third source database, wherein the second source database is different from the third source database;

wherein the step of querying the plurality of source databases of the telephony management system for the predetermined plurality of data structures that are linked through the one or more routines that rely on the one or more tools located on the data build machine comprises the steps of;

querying the first source database for the first predetermined data structure that comprises the feature information;

querying the second source database for the second predetermined data structure that comprises the dialing information;

querying the third source database for the third predetermined data structure that comprises the platform information.

16. The process of claim 15, wherein the step of selecting the configuration type for the home location register of the telephony management system comprises the step of selecting the home location register to comprise integrated data.

17. The process of claim 15, wherein the step of selecting the configuration type for the home location register of the telephony management system comprises the step of selecting the home location register to comprise stand alone data.

18. The process of claim 15, wherein the step of selecting the configuration type for the home location register of the telephony management system comprises the step of determining a “

C”

interface.

19. The process of claim 18, wherein the step of selecting the configuration type for the home location register of the telephony management system comprises the step of building a database for the home location register.

20. The process of claim 19, wherein the step of modifying the subset of the predetermined plurality of data structures based on the at least one preselected criterion and the step of inserting the subset of the predetermined plurality of data structures into the telephony management system comprise the step of building signaling connection control part data for a new database of the telephony management system.

21. The process of claim 15, wherein the step of modifying the subset of the predetermined plurality of data structures based on the at least one preselected criterion and the step of inserting the subset of the predetermined plurality of data structures into the telephony management system comprise the step of determining whether mobile switching center data is included in a new database of the telephony management system.

22. The process of claim 21, wherein the step of modifying the subset of the predetermined plurality of data structures based on the at least one preselected criterion and the step of inserting the subset of the predetermined plurality of data structures into the telephony management system comprise the step of including the mobile switching center data in the new database.

23. The process of claim 22, wherein the step of modifying the subset of the predetermined plurality of data structures based on the at least one preselected criterion and the step of inserting the subset of the predetermined plurality of data structures into the telephony management system comprise the step of building visitor location register data in the new database.

24. The process of claim 22, wherein the step of modifying the subset of the predetermined plurality of data structures based on the at least one preselected criterion and the step of inserting the subset of the predetermined plurality of data structures into the telephony management system comprise the step of building equipment identity register data in the new database.

25. The process of claim 22, wherein the step of modifying the subset of the predetermined plurality of data structures based on the at least one preselected criterion and the step of inserting the subset of the predetermined plurality of data structures into the telephony management system comprise the step of determining “

A”

interface data in the new database.

26. The process of claim 22, wherein the step of modifying the subset of the predetermined plurality of data structures based on the at least one preselected criterion and the step of inserting the subset of the predetermined plurality of data structures into the telephony management system comprise the step of determining base station interfaces data in the new database.

27. The process of claim 22, wherein the step of modifying the subset of the predetermined plurality of data structures based on the at least one preselected criterion and the step of inserting the subset of the predetermined plurality of data structures into the telephony management system comprise the step of determining location areas data in the new database.

28. The process of claim 22, wherein the step of modifying the subset of the predetermined plurality of data structures based on the at least one preselected criterion and the step of inserting the subset of the predetermined plurality of data structures into the telephony management system comprise the step of determining geographic location interfaces data in the new database.

29. The process of claim 22, wherein the step of modifying the subset of the predetermined plurality of data structures based on the at least one preselected criterion and the step of inserting the subset of the predetermined plurality of data structures into the telephony management system comprise the step of determining short message service data in the new database.

30. The process of claim 22, wherein the step of modifying the subset of the predetermined plurality of data structures based on the at least one preselected criterion and the step of inserting the subset of the predetermined plurality of data structures into the telephony management system comprise the step of building dialed digit strings in the new database.

31. The process of claim 22, wherein the step of modifying the subset of the predetermined plurality of data structures based on the at least one preselected criterion and the step of inserting the subset of the predetermined plurality of data structures into the telephony management system comprise the step of building call routing data in the new database.

32. The process of claim 22, wherein the step of modifying the subset of the predetermined plurality of data structures based on the at least one preselected criterion and the step of inserting the subset of the predetermined plurality of data structures into the telephony management system comprise the step of building billing data in the new database.

33. The process of claim 22, wherein the step of modifying the subset of the predetermined plurality of data structures based on the at least one preselected criterion and the step of inserting the subset of the predetermined plurality of data structures into the telephony management system comprise the step of building signaling connection control part data for the new database.

34. The process of claim 15, wherein the step of inserting the subset of the predetermined plurality of data structures into the telephony management system comprises the step of creating a new database.

35. The process of claim 15, wherein the step of inserting the subset of the predetermined plurality of data structures into the telephony database management system comprises the step of updating a preexisting database.

36. The process of claim 15, wherein the step of selecting the predetermined plurality of data structures to comprise the first predetermined data structure that comprises the feature information comprises the step of:

selecting the predetermined plurality of data structures to comprise a first predetermined data structure that comprises rate and routing information;

wherein the step of selecting the predetermined plurality of data structures to comprise the second predetermined data structure that comprises the dialing information comprises the step of;

selecting the predetermined plurality of data structures to comprise a second predetermined data structure that comprises a first portion of switch module configuration information and networking rate and routing information;

wherein the step of selecting the predetermined plurality of data structures to comprise the third predetermined data structure that comprises the platform information comprises the step of;

selecting the predetermined plurality of data structures to comprise a third predetermined data structure that comprises a second portion of the switch module configuration information that is different from the first portion of the switch module configuration information;

wherein the step of querying the first source database for the first predetermined data structure that comprises the feature information comprises the step of;

querying the first source database for the first predetermined data structure that comprises the rate and routing information;

wherein the step of querying the second source database for the second predetermined data structure that comprises the dialing information comprises the step of;

querying the second source database for the second predetermined data structure that comprises the first portion of the switch module configuration information and the networking rate and routing information;

wherein the step of querying the third source database for the third predetermined data structure that comprises the platform information comprises the step of;

querying the third source database for the third predetermined data structure that comprises the second portion of the switch module configuration information.