Abstract: An Internet gateway server for dynamically loading a database with data extracted from selected header fields and the body of inbound and outbound HTTP messages exchanged between one or more servers and the Web browsers which connect with those servers. The gateway server or “WebJacket” is interposed in the communications pathway between the server(s) and client(s) receiving each of inbound messages from a client and forwarding the received inbound messages to the server(s). The WebJacket extracts a first selected set of data contained in predetermined ones of said inbound messages and storing this incoming message data in predetermined locations in a relational database. The WebJacket further receives, stores and forwards each outbound message from the server(s) and extracts a second selected set of data from the outbound messages.
Type:
Grant
Filed:
April 24, 2001
Date of Patent:
November 1, 2005
Assignee:
Oracle International Corp.
Inventors:
John Louis Janosik, Jr., David Lane Diamond, Michael Rubino
Abstract: A method for aggregating sparse data in a multidimensional array by using a composite join hierarchy created by segmenting the data so that each segment of the hierarchy processed is smaller and more likely to fit in memory. The method employs a recursive sub-cubing mechanism wherein an n-dimensional cube is broken into a number of (n−1)-dimensional cubes and each of those cubes are solved as (n−2)-dimensional cubes etc. Within each division, the processing is segmented by hierarchy level so a dimension with three hierarchy levels (for example, month-quarter-year) would form three separate subcubes with one less dimension. This algorithm produces one ‘worklist’ for every combination of hierarchy levels in the cube. Each of these worklists is represented as a bitmap of the cells contained within it and may be used as a basis of generating more aggregate worklists.
Type:
Grant
Filed:
May 30, 2001
Date of Patent:
August 12, 2003
Assignee:
Oracle International Corp.
Inventors:
Albert A. Hopeman, Caleb E. Welton, Grant E. Hicks
Abstract: A shareable application program interface (API) infrastructure which is used in combination with a relational database to provide data storage and processing functions for location-aware objects, including particularly mobile objects whose current position is periodically updated by a position determining system. Client and service tables in the relational database are used to store the current point location, and other data, representing virtual objects, including mobile objects. A region table stores that describing the geometry and characteristics of geographical regions having defined boundaries within which the client and service objects reside. For each client, the set of services used by that client is recorded in a client profile database table. The services available on the system which are position-dependent have a geographical location associated with them. The API makes available an assortment of location dependent processing functions which may be used by location aware applications.
Abstract: A Web agent software interface between a relational database and Web-based application programs employs stored SQL procedures to store, update and retrieve multimedia objects. Web based applications manipulate the data in the relational database table by using URLs consisting of an alphanumeric designation of the host computer and port, the Web agent program associated with the database, the database agent configuration information associated with the database, specific stored SQL procedure for performing the desired data manipulation, and additional parameter data needed to specify and manipulate a particular multimedia object.
Type:
Grant
Filed:
November 5, 1999
Date of Patent:
July 8, 2003
Assignee:
Oracle International Corp.
Inventors:
David Lane Diamond, John Louis Janosik, Jr., Simon John Oxbury, Michael Rubino