Distributed management support system for software managers

• US 4,751,635 A
• Filed: 04/16/1986
• Issued: 06/14/1988
• Est. Priority Date: 04/16/1986
• Status: Expired due to Fees

• Current Assignee: Bell Communications Research, Inc. (Telefonaktiebolaget LM Ericsson)
• Original Assignee: Bell Communications Research, Inc. (Telefonaktiebolaget LM Ericsson)
• Inventors: Kret, Michael A.
• Primary Examiner(s): Zache, Raulfe B.
• Application Number:
  US06/852,622
• Time in Patent Office: 790 Days
• Field of Search: 364/200 MS File
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 8/20 Software design

Abstract

A management system utilizes a distributed network having a host computer connected to one or more computer based workstations. Separate, on-line softward support systems provide the execution environment for the system. Each support system provides data that reflects one or more aspects of a life cycle of a development project. This data is stored in separate databases associated with each support system. Periodically, the host computer extracts information from each of these support system databases to obtain data indicative of development activity for various phases of the life cycle of the software system. The extracted information is used to update a relational database. At any time, a manager situated at a workstation can formulate queries into the relational database. Thereafter, the workstation, through a workstation/host communications interface, initiates a host session and then loads the queries into the host computer. The host, in turn, executes these queries and downloads the query results into the workstation. Then the manager appropriately analyzes and interprets those query results at the workstation. The communications interface ensures that the host session remains substantially transparent to the manager. This advantageously frees the manager of any need to learn the host logon procedure and operating system, thereby minimizing the managerial time and effort required to obtain the desired information.

Claims

1. Apparatus for a management support system for providing desired information relating to a life cycle of a large scale software system, said apparatus comprising:

at least one software support system for colecting information relating to a corresponding phase of the life cycle to provide collected information and for storing the collected information into at least one software support system database;

a host computer for extracting pre-defined portions of the collected information sotred within said software support system database to provide extracted information and for updating a common database with the extracted information; and

at least one computer based workstation connected, via a workstation/host communications interface, to said host computer for formulating a request message to said host computer for execution thereat in order to access the desired information from said common database;

wherein said host computer comprises means, responsive to said request message, for initiating a host session for accessing the desired information from said common database and for transmitting to said workstation, via said interface, a response that includes the desired information; and

wherein said workstation comprises means for storing the desired information contained in said response.

2. The apparatus in claim 1 wherein said workstation/host communications interface comprises means for connecting said workstation to said host computer in a substantially transparent manner to a user situated at said workstation.

3. The apparatus in claim 1 wherein said workstation comprises:

means for locally formulating a query and for locally storing the query for subsequent inclusion into said request message;

means for selectably transmitting said query, via said workstation/host communications interface to said host computer;

means for locally analayzing, in a pre-defined manner, the desired information contained in said response from said host computer to provide analyzed data;

means for visually presenting said analyzed data in a user selectable format to generated selected data; and

means, responsive to said presenting means, for displaying said selected data, and an indication corresponding to said query.

4. The apparatus in claim 3 wherein said host computer further comprises:

means, responsive to said request, for establishing a host database management session;

means, operative during said database management session, for executing said query into said common database and for providing a query result therefrom as said desired information;

means for generating a status message indicative of status of the query execution means; and

means for including said status message and said query result into said response.

5. The apparatus in claim 4 wherein said workstation/host communicatioins interface further comprises:

means for allocating a pre-defined portion of memory residing at said host computer as at least one virtual diskette, said memory portion being accessible by a host database management program that manages said common database; and

means for establishing appropriate interfaces at said host computer and said workstation to enable said workstation to access said virtual diskette on a read/write basis whereby said workstation can transfer said query to said host computer for execution thereat and receive the response therefrom.

6. The apparatus in claim 5 wherein said workstation further comprises means for comparing said query result against a pre-defined threshold value to obtain a difference and for providing an index value indicative of the difference therebetween.

7. The apparatus in claim 6 wherein said host computer further comprises:

means for periodically extracting said information portions from said software support system database to produce extracted information portions; and

means, responsive to said extracted information portions, for updating a relational database to form said common database.

8. Apparatus for a management support system for providing desired information relating to a life cycle of a large scale software system, said apparatus comprising:

a plurality of workstations, wherein each of said workstations can be separately connected to a host computer, via a corresponding workstation/host communications interface, for establishing a substantially transparent corresponding host session,

a plurality of software support systems, each executing in a corresponding computer and having a corresponding software support system database associated therewith, for collecting information relating to substantially all phases of the life cycle for said large scale software system to provide separately collected information and for storing the separately collected information into a corresponding said software support system database;

means for periodically extracting different predefined portions of the information stored within each said software support system database to provide extracted information portions, and for periodically updating a relational database resident on the host computer with said extracted information portions;

a plurality of virtual diskettes located at the host computer; and

means for assigning at least a different corresponding one of said virtual diskettes to each corresponding one of said workstations in order to separately transfer a query from each of said workstations to said host computer and to separately transfer a corresponding response from said host computer to each of said workstations, each said response containing the desired information.

9. Apparatus for management support system for providing desired information relating to a life cycle of a large scale software system, said apparatus comprising:

at least one software support system for collecting information relating to a corresponding phase of the life cycle to provide collected information and for storing the collected information into at least one software support system database;

a host computer for extracting pre-defined portions of the information stored within said software support system database to provide extracted information and for updating a common database with said extracted information; and

at least one computer based workstation connected, via a workstation/host communications interface, to said host computer, in a substantially transparent manner to a user situated at said workstation, for formulating a request to said host computer for execution thereat in order to access the desired information from said common database;

wherein said host computer comprises;

means, responsive to said request, for establishing a host database management session;

means, operative during said host database management session, for executing a query into said common database and for providing a query result therefrom as said desired information;

means for generating a status message indicative of status of the means for executing a query; and

means for formualting said status message and said query result into a response; and

wherein said workstation comprises;

means for locally formulating said query and for locally storing said query for subsequent inclusion into said request;

means for selectably transmitting said query, via said workstation/host communications interface, to said host computer and for locally storing the query result contained in said response as a locally stored query result;

means for locally analyzing, in a predefined manner, the locally stored query result to produce an analyzed query result;

means for visually presenting said analyzed query result in a user selectable format to generate selected data; and

means, responsive to said presenting means, for displaying said selected data and an indication corresponding to said status message.

10. The apparatus in claim 9 wherein said workstation/host communications interface further comprises:

means for allocating a pre-defined portion of memory residing at said host computer as at least one virtual diskette, said memory portion being accessible by a host database management program that manages said common database; and

means for establishing aproppriate interfaces at said host and said workstation to enable said workstation to access said virtual diskette on a read/write basis whereby said workstation can transfer said query to said host for execution thereat and receive the response therefrom.

11. The apparatus in claim 10 wherein said workstation further comprises means for comparing said query result against a pre-defined threshold value to obtain a difference and for providing an index value indicative of the difference therebetween.

12. The apparatus in claim 11 wherein said host computer further comprises:

means for periodically extracting said information portions from said software support system database to obtain extracted information portions; and

means, responsive to said extracted information portions, for updating a relational database with said information portions to form said common database.

13. In a system comprising a host computer and at least one computer based workstation, a method for downloading to the workstation certain data accessible by the host computer, said method comprising the steps of:

formulating a request message at the workstation for execution by the host computer, said request message comprising a pre-defined sequence of host instruction and a query for selecting said certain data;

transmitting said request to the host computer via a workstation/host communications interface, said interface arranged to connect the workstation to the host computer in a substantially transparent fashion to a user situated at the workstation;

receiving said request message within the host computer and, in response to instructions, executable by the host computer, contained in the request message, initiating a database management session within the host computer to execute said query and access said certain data from host computer;

returning a response message to the workstation, said response message comprising said certain data; and

detecting said response message within said workstation and, in response thereto, storing said certain data contained within said response message.

14. The method in claim 13 further comprising the steps of:

allocating a pre-defined portion of memory, utilized by said host computer, as at least one virtual diskette, said memory portion being accessible by a host database management program that manages a common database situated at the host; and

establishing appropirate interfaces at said host computer and said workstation to enable said workstation to access said virtual diskette on a read/write basis whereby said workstation can transfer said query to said host computer for execution thereat and receive the response message therefrom.

15. The method in claim 14 further comprising the steps of:

periodically extracting current data from at least one database to produce extracted current data; and

updating, in response to said extracted current data, the common database which contains the data accessible by the host computer.