Method and system for separating business and device logic in a computing network system

• US 7,688,960 B1
• Filed: 02/26/2002
• Issued: 03/30/2010
• Est. Priority Date: 02/26/2002
• Status: Active Grant

• Current Assignee: T-Mobile Innovations LLC (Deutsche Telekom AG)
• Original Assignee: Sprint Communications Company LP (Deutsche Telekom AG)
• Inventors: Mitchell, Kay Ellen, Aubuchon, Kenneth James, Kimminau, Benjamin David
• Primary Examiner(s): PATEL, HEMANT SHANTILAL
• Application Number:
  US10/083,064
• Time in Patent Office: 2,954 Days
• Field of Search: 379/201.12, 379/201.03, 379/201.02, 379/201.05, 379/207.02, 379/221.09, 455/3.03, 455/418, 705/1, 709/203, 709/238, 709243-244, 717171-173
• US Class Current: 379/201.12
• CPC Class Codes: H04L 41/50 Network service management, e.g. ensuring proper service fulfilment according to agreements
• CPC Class Codes: H04M 2242/14 with services dependent on location where the service is an information service H04M2242/15; services independent of location H04M3/42229
• CPC Class Codes: H04M 3/42144 by service provider
• CPC Class Codes: H04Q 2213/1305 Software aspects
• CPC Class Codes: H04Q 3/0062 Provisions for network management

Abstract

The present invention is directed to a method and system for use on a computer for the automated generation of commands or other data to populate tables of a database. The automated generation process of the present invention entails separating business logic from device specific logic, defining the organization of incoming data, identifying and setting default data parameters, defining the format for the output data, and implementing the command generating object oriented classes in program source code, to generate device specific commands.

Claims

1. A computer readable medium having computer executable instructions embodied thereon for performing a method of building commands useable by a computing device in a telecommunications network to provide instructions on performing a task, the method comprising:

interfacing with a client application to receive a plurality of data and a service identification, wherein the plurality of data and the service identification both correspond to business logic that has no relationship to the computing device;

accessing a database containing a list of available services;

correlating the received service identification with an available service from the list of available services;

utilizing the available service correlation to generate a list of table names,

(1) wherein each table name corresponds to a table that must be populated to instruct the computing device to perform the task, wherein the task relates to a change of at least one telecommunication service in a geographic area, and

(2) wherein the change impacts a plurality of subscribers of the telecommunications network;

sending the list of table names to a command factory, which stores a list of pointers to one or more command builder components,

receiving from the command factory, one or more pointers to one or more command builder components,

(1) wherein a pointer to a command builder component is received for each of the table names sent to the command factory, and

(2) wherein each command builder component generates one or more commands, wherein each generated command causes a record consisting of an ordered text string of fields to be created in an appropriate table when executed;

storing each command generated by each command builder component in a generated command list;

receiving an indication from the client application that every command in the generated command list should be executed; and

instructing each command builder component for which a pointer was received to execute it'"'"'s corresponding one or more generated commands, wherein upon execution of the one or more generated commands, the computing device is able to perform the task.

2. The computer readable medium of claim 1, wherein the computing device is a switch and wherein the plurality of data received from the client application relates to call routing criteria for a Metropolitan Statistical Area (MSA) of interest.

3. The computer readable medium of claim 2, wherein the plurality of data received from the client application includes one or more of dialing patterns, trunk groups, terminating end offices, and files used to differentiate between local and long distance calls.