Accessing network databases

Details Accessing network databases Accessing network databases

2000-08-31

2004-10-19

Meky, Moustafa M. (Department: 2157)

Electrical computers and digital processing systems: multicomput

Remote data accessing

Accessing a remote server

C709S203000, C709S217000, C709S224000

Reexamination Certificate

active

06807572

ABSTRACT:

BACKGROUND
This invention relates generally to accessing relational databases on networks to provide cached information to a client browser.
Increasingly, data is cached on a server and accessed by clients over the Internet. This decreases the resource requirements on the client while providing ready access to the information with a sufficiently high speed Internet connection. Conventionally, when the client needs information (such as the address of a web site that has been bookmarked), the browser resident on the client formulates a request and transmits it over the Internet to a hypertext transfer protocol (HTTP) server. The server then transmits the request to a relational database management server over a common gateway interface (CGI) program. Each time the relational database management server is accessed, a new connection and a new session to that server must be established.
Referring to
FIG. 3
, the establishment of such a connection and a session is somewhat time consuming and needlessly bogs down the processing of the relational database management server. The request from the browser must be decoded as indicated in block
48
. Then, a Structured Query Language (SQL) query must be parsed from other information such as the HTTP server's uniform resource locator (URL) (block
50
). The relational database management server then must bind the program variables as indicated in block
52
. The relational database management server executes the query as indicated in block,
54
. Thereafter, the relational database management server must fetch the results as indicated in block
56
.
Generally, access by the browser is stateless. The term “stateless” refers to a process that participates in an activity without monitoring all the details of its state and particularly is not aware of the context of a given process. Because of the stateless character of the browser's request, it is difficult to maintain any type of caching mechanism on the server side.
Therefore, there is a need for a more efficient way to handle stateless accesses to a relational database management server from an Internet browser.


REFERENCES:
patent: 5778372 (1998-07-01), Cordell et al.
patent: 6138120 (2000-10-01), Gongwer et al.
patent: 6212565 (2001-04-01), Gupta
patent: 6282652 (2001-08-01), Scheifler
patent: 6338089 (2002-01-01), Quinlan et al.
patent: 6389462 (2002-05-01), Cohen et al.
patent: 6427161 (2002-07-01), Livecchi
patent: 6434543 (2002-08-01), Goldberg et al.
patent: 6438597 (2002-08-01), Mosberger et al.
patent: 6457054 (2002-09-01), Bakshi
patent: 6606645 (2003-08-01), Cohen et al.
“Tuxedomain the independent information hubs for leading middleware professionals from middleAware—not middleware—dot com TUXEDO's FAQ”, Hegetor Ltd., 1998.
“MTSense the independent information hub for Microsoft MTS/DCOM professionals from middleAware—not middleware—dot com COM Bites, MTS Flags”, Hegetor Ltd, 1998.
“Microsoft Transaction Service—Transactional Component Services, A guide to Reviewiing Microsoft Transaction Server Release 2.0—The Best Technology for Developing and Deploying Applications on Windows NT”, Microsoft Corporation, 2000.

Affiliated with

Also associated with

Rating

Accessing network databases does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Accessing network databases, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Accessing network databases will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3280381