State management for a step architecture

• US 7,099,868 B1
• Filed: 03/30/2001
• Issued: 08/29/2006
• Est. Priority Date: 03/30/2001
• Status: Active Grant

• Current Assignee: Charles A Johnson Unisys Corporation
• Original Assignee: Unisys Corporation
• Inventors: Brassil, J. Mark, Turba, Thomas N.
• Primary Examiner(s): Wong, Don
• Assistant Examiner(s): NGUYEN, MERILYN P
• Application Number:
  US09/821,952
• Time in Patent Office: 1,978 Days
• Field of Search: 707 1- 10, 707/102, 707/104.1, 707/103.R, 707/101, 707/203, 709/200, 709/201, 709/225, 709/227, 709/229, 709/202, 715/503, 715/511
• US Class Current: 1/1
• CPC Class Codes: G06F 21/6227 where protection concerns the structure of data, e.g. records, types, queries
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

An apparatus for and method of utilizing an Internet terminal to interface with an existing proprietary database management system by permitting a developer to create a web based service that produces a table result. The table may appear either as an HTML table or a graph. The service is defined as a plurality of ordered, discreet, and independent steps. Each step may be created and/or edited independently of all other steps. To assist the service developer, the system presents a choice of available steps to be added into the sequence at any particular point. The only steps so presented are valid for the position within the sequence. Invalid steps are not presented. During the development process, each selected step has a corresponding state report associated therewith. Each state report indicates the computational state resulting from the associated step to the next succeeding step in the sequence.

Claims

1. In a data processing system having a user terminal operated by a user which builds a component for accessing a data base management system which responds to said component by execution of a sequence of command language script responsively coupled to said user terminal via a publicly accessible digital data communication network, the improvement comprising:

a. a Data Wizard which permits said user to specify said component as a composite table corresponding to an ordered sequence of discreet and independent sub-tables and which presents a plurality of valid sub-tables as choices for addition at each position in said ordered sequence of discreet and independent sub-tables and wherein each of said ordered sequence of discreet and independent sub-tables defines a unique portion of said sequence of command language script; and

b. a plurality of state reports wherein a different one of said plurality of state reports corresponds to each sub-table in said plurality of said ordered sequence of discreet and independent sub-tables, wherein each of said plurality of state reports conveys state information including output state resulting from execution by said data base management system of said unique portion of said sequence of command language script corresponding to a given one of said ordered sequence of discreet and independent sub-tables to a subsequent one of said ordered sequence of discreet and independent sub-tables.

2. The improvement according to claim 1 wherein said publicly accessible digital data communication network further comprises the Internet.

3. The improvement according to claim 2 wherein said user terminal further comprises an industry compatible personal computer having a commercially available browser.

4. The improvement according to claim 3 wherein each of said plurality of state reports further comprises a development environment statement that defines output information from a given step to a subsequent step in said ordered sequence of discreet and independent sub-tables.

5. The improvement according to claim 4 wherein said data base management system is a commercially available data base management system.

6. An apparatus comprising:

a. a user terminal which generates a service request;

b. a data base management system which honors said service request by executing a sequence of command language statements coupled to said user terminal via a publicly accessible digital data communication network; and

c. a Data Wizard coupled to said user terminal and said data base management system which permits said service request to be defined from said user terminal as a composite table in accordance with an ordered sequence of discreet and independent sub-tables wherein each of said ordered sequence of discreet and independent sub-tables defines a different portion of said sequence of command language statements and which provides a state report specifying output state resulting from execution by said data base management system of said different portion of said sequence of command language statements to each one of said ordered sequence of discreet and independent sub-tables which corresponds to the previous one of said ordered sequence of discreet and independent sub-tables.

7. The apparatus of claim 6 wherein said publicly accessible digital data communication network further comprises the Internet.

8. The apparatus of claim 7 wherein each of said state reports further comprises a state update code.

9. The apparatus of claim 8 wherein said user terminal further comprises an industry compatible personal computer containing a web browser.

10. The apparatus of claim 9 wherein said data base management system further comprises a commercially available data base management system.

11. A method of dynamically building a software component defining a service request from a user terminal coupled via a publicly accessible digital data network to a remote data base management system having a component building process wherein said data base management system responds to a service request by executing a sequence of command language script comprising:

a. presenting a first plurality of sub-tables which are valid for a first position in a composite table having an ordered sequence of sub-tables which define said software component;

b. inserting a chosen one of said first plurality of sub-tables which defines a first portion of said sequence of command language script into said composite table having said ordered sequence of sub-tables;

c. associating a first state report which describes results of execution of said first portion of said sequence of command language script by said data base management system with said chosen one of said first plurality of sub-tables;

d. presenting a second plurality of sub-tables which are valid for a next position in said composite table having said ordered sequence of sub-tables;

e. inserting a chosen one of said second plurality of sub-tables defining a second portion of said sequence of command language script into said composite table having said ordered sequence of sub-tables;

f. associating a second state report which describes results of execution of said first portion of said sequence of command language script by said data base management system with said chosen one of said second plurality of sub-tables; and

g. repeating steps c, d, e, and f until said component is completed.

12. A method according to claim 11 further wherein each of said state reports further comprises a state update code.

13. A method according to claim 12 wherein said publicly accessible digital data communication network further comprises the world wide web.

14. A method according to claim 13 wherein said user terminal further comprises an industry compatible personal computer.

15. A method according to claim 14 wherein said remote data base management system further comprises a commercially available data base management system.

16. An apparatus comprising:

a. permitting means for permitting a user to access a publicly accessible digital data communication network which generates a service request;

b. providing means coupled to said permitting means via said publicly accessible digital data communication network for providing data base management services which honors said service request by executing an ordered sequence of command language script;

c. designing means coupled to said permitting means and said providing means for designing a software component corresponding to said service request through specification of a composite table containing an ordered plurality of discreet and independent sub-tables wherein each of said ordered plurality of discreet and independent sub-tables defines a different portion of said ordered sequence of command language script; and

d. associating means coupled to said designing means for associating a state report with each of said ordered plurality of discreet and independent sub-tables which indicates output state resulting from said data base management system executing said different portion of said ordered sequence of command language script.

17. An apparatus according to claim 16 wherein said state report further comprises a state development environment report.

18. An apparatus according to claim 17 wherein said publicly accessible digital data communication network further comprises the Internet.

19. An apparatus according to claim 18 wherein said providing means further comprises a commercially available data base management system.

20. An apparatus according to claim 19 wherein said permitting means further comprises an industry standard personal computer.