Database access using active server pages

• US 6,363,398 B1
• Filed: 07/12/1999
• Issued: 03/26/2002
• Est. Priority Date: 11/25/1997
• Status: Expired due to Term

• Current Assignee: Web.com Group, Inc.
• Original Assignee: Micro Electronics Incorporated
• Inventors: Andersen, Todd
• Primary Examiner(s): Alam, Hosain T.
• Assistant Examiner(s): Kindred, Alford W.
• Application Number:
  US09/351,927
• Time in Patent Office: 988 Days
• Field of Search: 707/100-104, 707/1-6, 707/10
• US Class Current: 1/1
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: Y10S 707/917 Text
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A method and system for accessing a database management system running on a server computer from within a JAVA applet running on a client computer. The JAVA applet prepares a URL to address an active server page on the server computer, embedding a database query within the URL. The JAVA applet then accesses the active server page using the prepared URL. The server computer, upon receiving a request for access to the active server page, executes a script stored within the active server page that receives the database query embedded within the URL, passes the query to the database management system, receives from the database management system the query results, creates a HTML document, and stores the query results in the HTML document. The server computer then returns the HTML document to the client computer, where the JAVA applet reads the query results from the HTML document.

Claims

1. A program storage device containing computer code that enables a client computer system to:

construct a uniform resource locator that identifies an active server page on a server computer, the uniform resource locator including a database query encoded as an argument;

send to the server computer a request to access the active server page identified by the uniform resource locator, the sending of the request causing the server to invoke a script within the active server page that causes the database query to be executed and that packages results from the database query execution into a hypertext markup language document and causing the server computer to return the hypertext markup language document containing the results from the database query execution to the client computer; and

receive the returned hypertext markup language document from the server computer and read from the hypertext markup language document the results of the database query execution.

2. The program storage device of claim 1 wherein the computer code contains at least computer code of a JAVA applet.

3. A personal computer configured to access a database management system running on a server computer, the personal computer comprising circuitry configured to:

construct a uniform resource locator that identifies an active server page on the server computer, the uniform resource locator including a database query encoded as an argument;

send to the server computer a request to access the active server page identified by the uniform resource locator, the sending of the request causing the server to invoke a script within the active server page that causes the database query to be executed and that packages results from the database query execution into a hypertext markup language document and causing the server computer to return the hypertext markup language document containing the results from the database query execution to the program; and

receive the returned hypertext markup language document from the server computer and read from the hypertext markup language document the results of the database query execution.

4. The personal computer of claim 3 wherein the personal computer is running a JAVA applet.