Method and apparatus for accessing data sources in a three tier environment

• US 6,209,029 B1
• Filed: 05/12/1998
• Issued: 03/27/2001
• Est. Priority Date: 05/12/1998
• Status: Expired due to Term

• Current Assignee: Apple Inc.
• Original Assignee: SilverStream Software, Inc. (Open Text Corporation)
• Inventors: Chiu, John, Allen, Larry W., Epstein, Arny
• Primary Examiner(s): VU, VIET DUY
• Application Number:
  US09/076,924
• Time in Patent Office: 1,050 Days
• Field of Search: 709/203, 709/204, 709/205, 709/202, 709/221, 709/217, 709/219, 709/223, 709/224, 709/225, 709/313, 709/315, 709/319, 709/328, 709/329
• US Class Current: 709/219
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation

Abstract

The present invention provides a three tier environment with improved data access capabilities. A browser can obtain data from a data source by interacting with that data source through an application server. The application server consists of a web server portion and a data server portion. Instead of CGI scripts interacting with a data source through a CGI interface, the present invention uses applets and objects to interact directly with a data source. A web page requested by a browser includes a “presentation” which is applet code that accesses data from a data source. When the application server receives a request for a page that is to contain data from a data source, the application server identifies a page that includes a reference to a presentation. The non-data portion of the page emits itself to the browser while at the same time the presentation undertakes the data retrieval. The browser receives the page, which contains an applet tag. The applet class is sent to the browser. The applet requests a URL that represents the data that is being retrieved for the page. The data is downloaded to the applet from the application server and displayed in the previously forwarded page. The presentation in the page working in conjunction with the data source takes the place of CGI scripting.

Claims

1. A method for providing access to a data source from a browser comprising the steps of:

sending a request for a page from a browser to a server having a page server portion and a data server portion;

said page server retrieving said page, wherein said page is type encoded to signify additional processing may be required, said page comprising a reference to a presentation;

creating said presentation in said page wherein said presentation is coupled to said data server portion of said server;

said page server portion providing a non-data bearing portion of said page to said browser;

said data server portion retrieving appropriate data from said data source using said presentation; and

said data server portion providing said appropriate data from said data source to a data bearing portion of said page for display at said browser.

2. The method of claim 1 wherein said step of retrieving appropriate data form said data source is accomplished by the steps of:

said presentation creating a download object;

said download object generating a data request;

initiating said data request to said data source;

retrieving said appropriate data from said data source.

3. The method of claim 2 wherein said page when transmitted to said browser includes a reference to said download object that initiates retrieval of said appropriate data from said download object.

4. The method of claim 3 wherein said step of retrieval of said appropriate data from said download object comprises the steps of:

retrieving an executable file from said server;

executing said executable file on said browser;

said executable file requesting said appropriate data from said download object using said reference;

said executable file receiving said appropriate data from said download object.

5. The method of claim 4 wherein said presentation comprises executable code.

6. The method of claim 5 wherein said reference to said appropriate data comprises a universal resource locator (URL).

7. The method of claim 6 wherein said executable file comprises a browser independent executable file.

8. The method of claim 7 wherein said browser independent executable file comprises a Java™

browser independent executable file.

17. The method of claim 1 wherein said additional processing comprises encapsulating an applet in the processing of said page.

9. A computer program product comprising:

a computer usable medium having computer readable program code embodied therein configured to provide access to a data source from a browser, said computer program product comprising;

computer readable program code configured to cause a computer to send a request for a page from a browser to a server having a page server portion and a data server portion;

computer readable program code configured to cause a computer to retrieve said page via the page server portion, said page being encoded to signify additional processing may be required, said page comprising a reference to a presentation;

computer readable program code configured to cause a computer to create said presentation in said page wherein said presentation is coupled to said data server portion of said server;

computer readable program code configured to cause said page server portion to provide a non-data bearing portion of said page to said browser;

computer readable program code configured to cause said data server portion to retrieve appropriate data from said data source using said presentation;

computer readable program code configured to cause said data server portion to provide said appropriate data from said data source to a data bearing portion of said page for display at said browser.

10. The computer program product of claim 9 wherein retrieving appropriate data from said data source is accomplished by:

computer readable program code configured to cause a computer to create a download object using said presentation;

computer readable program code configured to cause a computer to generate a data request using said download object;

computer readable program code configured to cause a computer to initiate said data request to said data source;

computer readable program code configured to cause a computer to retrieve said appropriate data from said data source.

11. The computer program product of claim 10 wherein said page when transmitted to said browser includes a reference to said download object that initiates retrieval of said appropriate data from said download object.

12. The computer program product of claim 11 wherein said retrieval of said appropriate data from said download object comprises:

computer readable program code configured to cause a computer to retrieve an executable file from said server;

computer readable program code configured to cause a computer to execute said executable file on said browser;

computer readable program code configured to cause said executable file to request said appropriate data from said download object using said reference;

computer readable program code configured to cause said executable file to receive said appropriate data from said download object.

13. The computer program product of claim 12 wherein said presentation comprises executable code.

14. The computer program product of claim 13 wherein said reference to said appropriate data comprises a universal resource locator (URL).

15. The computer program product of claim 14 wherein said executable file comprises a browser independent executable file.

16. The computer program product of claim 15 wherein said browser independent executable file comprises a Java™

browser independent executable file.

18. The computer program product of claim 9 wherein said additional processing comprises encapsulating an applet in the processing of said page.

19. An apparatus for providing access to a data source from a browser comprising:

a client comprising a browser and a virtual machine;

an application server having a page server portion and a data server portion, said browser coupled to said page server portion over a communication network;

a plurality of data sources coupled to said data server portion, access to said plurality of data sources from said browser comprising;

said browser sending a request to said application server for a page containing data from said plurality of data sources;

said page server retrieving said page, wherein said page is type encoded to signify additional processing, said page comprising a reference to a presentation;

said page creating said presentation in said browser using said virtual machine, said presentation being coupled to said data server portion of said application server;

said page server portion providing the non-data bearing portion of said page to said browser;

said data server portion retrieving appropriate data from said plurality of data sources using said presentation; and

said data server portion providing said appropriate data from said plurality of data sources to the data bearing portion of said page for display at said browser.

20. The apparatus of claim 19 wherein said retrieving appropriate data from said plurality of data sources comprises:

said presentation creating a download object;

said download object generating a request for data;

said download object sending said request to said plurality of data sources;

said download object receiving said data from said plurality of data sources.