WWW client server interactive system method with Java (.TM.)

• US 5,974,441 A
• Filed: 12/06/1996
• Issued: 10/26/1999
• Est. Priority Date: 06/07/1995
• Status: Expired due to Term

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: International Business Machines Corporation
• Inventors: Lagarde, Konrad Charles, Rogers, Richard Michael
• Primary Examiner(s): Matar, Ahmad F.
• Assistant Examiner(s): Patru, Daniel
• Application Number:
  US08/761,684
• Time in Patent Office: 1,054 Days
• Field of Search: 707/1, 707/3, 707/513, 395/200.3, 395/200.32, 395/200.48, 395/200.59, 709/200, 709/202, 709/218, 709/229, 709/1
• US Class Current: 709/200
• CPC Class Codes: G06F 16/958 Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
• CPC Class Codes: Y10S 707/99931 Database or file accessing

Abstract

A World Wide Web browser makes requests to web servers on a network which receive and fulfill requests as an agent of the browser client, organizing distributed sub-agents as distributed integration solution (DIS) servers on an intranet network supporting the web server which also has an access agent servers accessible over the Internet. DIS servers execute selected capsule objects which perform programmable functions upon a received command from a web server control program agent for retrieving, from a database gateway coupled to a plurality of database resources upon a single request made from a Hypertext document, requested information from multiple data bases located at different types of databases geographically dispersed, performing calculations, formatting, and other services prior to reporting to the web browser or to other locations, in a selected format, as in a display, fax, printer, and to customer installations or to TV video subscribers, with account tracking. Intrepretive language based programs or applets are downloaded from the web server to the client and executed on the client machine for online analytical processing from a web browser. The Web client accesses a web server and downloads HTML and a Java applet(s). This enables use of multiple databases of different types using a single request from a client for Online Analytical Processing (OLAP) from a web browser.

Claims

1. A method of fulfilling requests of a web browser client, comprising:

displaying a document to said web browser;

invoking a control program agent;

receiving data entered by the user from the document and passing said user entered data to said control program agent upon invocation as input parameters to said control program agent that were returned from said document;

using an API set for invoking executable commands accessible via an associated command file object, provided as user entered data for supplying to said control program agent values selected by a user to control the processes of fulfilling a Web request and for determining the nature of a resultant fulfillment of the request from information resources supplied from the World Wide Web.

2. A method of fulfilling requests according to claim 1 wherein said input parameters contain path environment data from the document that referred to said control program agent.

3. A method of fulfilling requests according to claim 1 wherein said step of receiving data entered by the user from the document and passing said user entered data to said control program agent upon invocation as input parameters to said control program agent that were returned from said document includes environment variables comprising an identification of a command file to call, the name of the file containing the statements to use when building a document that reports results requested by the request, and the type of report file that is requested, as well as query data from the document that referred to said control program agent.

4. A method of fulfilling requests according to claim 1 wherein said step of passing data from the document that referred to said control program agent, includes passing variable information data which contains values selected by the user and/or default values selected by a document designer set in said command file prior to its execution, all of which variable information data is stored in a buffer environment, and accessible by said command file and/or said control program agent and used by said control program agent to set variables for said command file.

5. A method of fulfilling requests according to claim 4 wherein the steps further comprise:

with the variable information now stored in a buffer, retrieving, with the control program agent from a store, command files and environment variables comprising an identification of a command file to call, the name of the file containing the statements to use when building a document that reports results requested by the request, and the type of report file that is requested, as well as query data from the document that referred to said control program agent which a request has specified as associated with each command file for the Web request and loading from said buffer environment into memory associated with the control program agent the command file names available and the environment variables associated with each command file.

6. A method of fulfilling requests according to claim 5 wherein the steps further comprise:

subsequent to the step of claim 5 initiating with the control program agent a connection between said control program agent and said API.

7. A method of fulfilling requests according to claim 6 wherein the steps further comprise after the performance of the step of claim 6

if required for control by a decision support system environment for said command file, logging onto a port or desktop for the assigned user by said control program agent.

8. A method of fulfilling requests according to claim 7 wherein the steps further comprise:

once a command file is loaded into memory for said control program agent, the control program agent retrieves from its memory the command file environment variables associated with a command file passed to the control program agent once the control program agent is invoked.

9. A method of fulfilling requests according to claim 8 wherein the steps further comprise:

subsequently, creating with said control program agent a data array stored in the control program memory containing the command file environment variables and said variable information data for them that were passed to the control program agent during initial data retrieval steps in order to match command file variable names of said environment variables with the data that was passed to the control program agent as variable information data values.

10. A method of fulfilling requests according to claim 9 wherein the steps further comprise:

subsequently, in preparation for a report, creating with said program command agent a unique filename which may include data originated by the document'"'"'s variables stored in said buffer as a data array to pass to the command file as a command file environment variable for use in naming the report which will be created by the command file, which as a result the command file will create that file with the unique file name during its process.

11. A method of fulfilling requests according to claim 10 wherein the steps further comprise:

subsequently, for a user query using the API to set the command file variable values in anticipation of command file execution, the values of environment variables used by the command file are obtained from said data array in the control program memory containing command file variable names of said environment variables as well as user defined values of said information variable data for said user query that were passed to the control program agent as parameters for query data from the document that referred to said control program agent which contains values selected by the user and/or default values selected by a document designer set in a command file program prior to its execution.

12. A method of fulfilling requests according to claim 11 wherein the steps further comprise:

subsequently, using an API to query and determine the size of a queue of jobs being requested, and comparing whether the size has exceeded a predetermined threshold number of jobs being requested, and if so, then entering a wait state loop to wait and reiteratively comparing whether the size still has exceeded said predetermined threshold number of jobs being requested until the queue size is reduced to below said threshold level, and then at that point using said API to submit a command file having said command file variable values for execution by a sub-agent.

13. A method of fulfilling requests according to claim 12 wherein the steps further comprise:

after the API has submitted said command file having said command file variable values for execution by a sub-agent, said control program agent enters a state of awaiting execution of said command file by said sub-agent.

14. A method of fulfilling requests according to claim 13 wherein the steps further comprise:

during a state of awaiting execution of said command file, processing other requests by the control program agent as a pipe so that the control program agent continually advances requests through the system.

15. A method of fulfilling requests according to claim 14 wherein the steps further comprise:

during the state awaiting execution of a command file, using said API to look for a completion signal of execution of said command file, and when that completion signal is received, said control program agent reads the file identified by the name passed to the control program agent in the preceding step that contains the statements which are to be presented with the command file report of results.

16. A method of fulfilling requests according to claim 15 wherein the steps further comprise:

while the control program agent reads the file identified by the name passed to the control program agent in the preceding step that contains the statements which are to be presented with the command file report of results, it dynamically creates new statements for a report of results according to a request of the web browser.

17. A method of fulfilling requests according to claim 16 wherein the steps further comprise:

retrieving with said new statement information retrieved from the file identified by the name passed to the control program agent so that it can be provided with the results of a command file report.

18. A method of fulfilling requests according to claim 17 wherein the steps further comprise:

retrieving with said new statement information retrieved from said identified file so that it can be displayed as a header accompanying the requested report to be displayed according to the user defined report type, along with the filename of said unique filename.

19. A method of fulfilling requests according to claim 1 wherein the input parameters include data entered by said user including variables identifying the type of file to create as a report to be created as a result of said web request and user identified applicable output parameters as to where a result is to be directed, and said steps further comprise:

testing with said control program agent for the type of report file to be created by obtaining information from stored variables and said testing further identifies said user identified applicable output parameters, and branching to the sequence applicable to the type of report file to be created.

20. A method of fulfilling requests according to claim 1 wherein the input parameters include data entered by said user including variables identifying the type of file to create as a report to be created as a result of said web request and user identified applicable output parameters identifying where a result is to be routed, and said steps further comprise:

if the output is to be routed user identified Web server, then routing said output to the user identified Web server.

21. A method of fulfilling requests according to claim 1 wherein the said associated command file object is a DIS capsule for creating a text file report, and said steps further comprise:

when a text file report is created by the DIS capsule, that determines that a text display is to be reported and the control program agent reads the file created by the DIS capsule and dynamically creates statements to display the data lines to the Web browser as a text display according to a user desired form of presentation.

22. A method of fulfilling requests according to claim 1 wherein the said associated command file object is a DIS capsule for creating a graphics file report, and said steps further comprise:

when a graphics file is created by the DIS capsule, that determines that a graphics display is to be reported and the control program dynamically creates the statement to display the graphics file to the Web browser is a display with graphics included as a presentation of results according to a user specified form of presentation.

23. A method of fulfilling requests according to claim 1 wherein the steps further comprise:

wherein the control program agent allows alternative output direction, and said input parameters include data entered by said user including variables identifying the type of file to create as a report to be created as a result of said web request and user identified applicable alternative output direction output parameters identifying where a result is to be routed as a requester user selected alternative output destination, and upon receipt of said alternative output direction and a command file completion signal, the result is routed to said alternative output destination.

24. A method of fulfilling requests according to claim 23 wherein the steps further comprise:

wherein an output is routed to a requestor user selected alternative output destination selected from a group of possible output units, comprising facsimile, printer, retail and banking installations, or provided as a series of full motion videos or still frames which are transmitted to display devices, including television units under control of end users with a set-top box cable control.

25. A method of fulfilling requests according to claim 24 wherein the steps further comprise:

wherein an output is routed to a requester user selected alternative output destination via a server having a CPU, network I/F bus, disks, modems, and data switching controls providing hardware to route the output to a user selected alternative output destination selection from a variety of output devices, including a facsimile, printer, retail terminal, banking machines, TV or cable customers via the server, with full motion and still video supplied with MPEG 2 and MPEG 1 protocol images respectively to subscribers.

26. A method of fulfilling requests according to claim 1 wherein the process of fulfilling said Web request creates an output, including a result file with a file name entered by the user from said document, and said steps further comprise:

coupling the output to an auxiliary function including back-up storage and accounting processes which allow for charging for system utilization and service charges for services and items requested.

27. A method of fulfilling requests according to claim 26 wherein the process of fulfilling said Web request creates an output making use of user entered data, and of hidden variables associated with the request including authorization charge variables, including credit card numbers and passwords, and of a file name entered by the user from said document, and said steps further comprise:

passing said output and said hidden variables to auxiliary functions which make use of hidden variables associated with the request including authorization charge variables, including credit card numbers and passwords.

28. A method of fulfilling requests according to claim 27 wherein the credit card number is encrypted with an encryption utility, and this encrypted credit card number along with access authorization variables, allows access to sensitive databases which reside behind firewalls.

29. A method of fulfilling requests according to claim 1 wherein the steps further comprise:

if selected data according to the Web browser request is permitted to be accessed by the request as an authorized user access at the location of said selected data inside or outside the Internet, the said selected data can be included in a combined report of results of said Web browser request including a combination of data selected for said user by said system as a result of data entered by said user as a combined report reported by the system to the Web browser user.

34. A method of fulfilling requests according to claim 1 wherein programs or applets are downloaded from the web server to the client, and wherein said web browser when interpreting the programs will foster the execution of the program/applet program on the client machine.

35. A method of fulfilling requests according to claim 1 including means for accessing multiple databases of different types using a single request from a client for Online Analytical Processing (OLAP) from a web browser.

36. A method of fulfilling requests according to claim 1 wherein interpretive language based programs or applets are downloaded from the web server to the client and executed on the client machine.

37. A method of fulfilling requests according to claim 1 wherein a Web client accesses a web server and downloads a document and identifies by document content interpretive language based programs or applets and the identified interpretive language based program or applet'"'"'s execution is initiated by execution of a web browser originated command that can interpret the interpretive language based programs or applets.

38. A method of fulfilling requests according to claim 1 wherein an applet communicates via TCP/IP sockets to said a control program agent that executes on the web server.

39. A method of fulfilling requests according to claim 38 wherein the control program agent provides the communication vehicle from the Web client to a data interpretation system (DIS), via an Open DIS Access Server (ODAS) providing a data interpretation system that allows programs to initiate DIS functions, such as invoking DIS capsules.

40. A method of fulfilling requests according to claim 38 wherein requests for database data and/or database description data are invoked from an interpretive applet via a TCP/IP sockets interface to the control program agent and ODAS.

30. A method for fulfilling requests of a web browser client;

comprising the steps of;

invoking a control program agent; and

via a Web client accessing a web server and downloading a document and an interpretive language based applet in the form of a command, applet or program from said Web client to initiate from said Web browser that can interpret the interpretive language based applet execution of said applet.

31. A method for fulfilling requests of a web browser client according to claim 30, further comprising the steps of:

receiving data entered by the user from a document and a user denominated interpretive program or applet and passing said user entered data and program or applet to said control program agent upon invocation as input parameters to said control program agent that were returned from said document; and

storing said input parameters in a buffer;

retrieving with the control program agent from a store command files and the variable names associated with each command files and loading into memory associated with the control program the command file names available and the variable names associated with each command file;

initiating with the control program agent a connection between said control program agent and an API;

once a command file is loaded into memory for said control program agent, retrieving with said control program agent from its memory the command file variable names associated with a command file name passed to the control program agent once the control program agent is invoked;

subsequently, creating with said control program agent a a data array stored in the control program memory containing the command file variable names and the values for them that were passed to the control program agent during initial data retrieval steps in order to match command file variable names with the data that was passed to the control program agent with said environment variables step;

subsequently, in preparation for a command file report, creating with said program command agent a unique filename which may include data originated by the document'"'"'s variables stored in said buffer to pass to the command file as a command file variable for use in naming the report which will be created by the command file, which as a result the command file will create that file with the unique file name during its process;

subsequently, using the API to set the command file variable values in anticipation of command file execution, obtaining the values of variables used by the command file from the data array in the control program memory containing the command file variable names and the values for them that were passed to the control program agent as input parameters to said control program agent as query data from the document that referred to said control program agent which contains values selected by the user and/or default values selected by a document designer set in a command file program prior to its execution, and

subsequently, using an API to query and determine the size of a queue of jobs being requested, and comparing whether the size has exceeded a predetermined threshold number of jobs being requested, and if so, then entering a wait state loop to wait and reiteratively comparing whether the size still has exceeded said predetermined threshold number of jobs being requested until the queue size is reduced to below said threshold level, and then at that point using said API to submit a command file for execution by a sub-agent to create a resulting file identified by said unique filename;

after the API has submitted said command file for execution by a sub-agent, said control program agent enters a state of awaiting execution of said command file by said sub-agent;

and wherein after execution by said sub-agent, thereafter the control program agent reads the resulting file identified by said unique filename and dynamically creates new statements to report results according to a request of the web browser with said unique filename identified.

32. A method of fulfilling requests according to claim 31 wherein the steps further comprise:

retrieving with said new statement information user requested data contained in said resulting file identified by said unique filename so that said user requested data can be provided with the results as a completed command file report.

33. A method of fulfilling requests according to claim 32 wherein the steps further comprise:

testing with said control program agent for the kind of report to be created by obtaining information from stored variables and identifies output parameters, and branching to the sequence applicable to the type of report to be created in the process of completing said command file report.