US5752028A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Object-oriented query mechanism
Assignee: Transparency Systems Inc
•
Filing: 1996-04-03
•
Granted: 1998-05-12
•
Expires: 2016-04-03
Abstract
Abstract The invention is a method for making joins and retrieving joined data during query processing in a database. An object sends a message with join criteria to one or more other objects or classes of objects. Objects receiving the message forward the data which they have or data which may potentially be useful to a receiving object, then stop processing, without waiting for a reply. Messages for a particular object are processed in a queue without reference to messages for other objects.
Inventors
- 👤 Bruce Arthur Ellacott
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-04 23:18
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/289; G06F16/24; G06F16/245; G06F16/2455; G06F16/24553; G06F16/24558; G06F16/2456; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99941; Y10S707/99944
Claims Analysis
Total Claims: 12
Claim 1
Independent Claim
178 words
A method of query processing in a database wherein data is sought to be retrieved and combined using at least two objects, which comprises; (A) sending at least one message from a first object to at least one second object within the database, said message specifying criteria for a join, (B) said message being acted upon by the method of the second object to form at least one output from each second object which has some of the data sought or other potentially relevant data, each such output containing some of the data sought or data which is related or potentially related to the data sought or a pointer to such data, (C) each said output proceeding independently either to another object so said output can be acted upon by the method of such other object to form a further output or to a results object which stores final or intermediate results, and (D) each object which has sent an output not awaiting replies from other objects to which its output has been sent before finishing its processing.
Claim 2
Independent Claim
178 words
A method of query processing in a database wherein data is sought to be retrieved and combined using at least two objects, which comprises; (A) sending at least one message from a first object to at least one second object within the database, said message specifying criteria for a join, (B) said message being acted upon by the method of the second object to form at least one output from each second object which has some of the data sought or other potentially relevant data, each such output containing some of the data sought or data which is related or potentially related to the data sought or a pointer to such data, (C) each said output proceeding independently either to another object so said output can be acted upon by the method of such other object to form a further output or to a results object which stores final or intermediate results, and (D) each object which has sent an output not awaiting replies from other objects to which its output has been sent before finishing its processing.
Claim 3
Dependent Claim
26 words
A method as claimed in claim 1 in which data which is related or potentially related to the data sought is sent to a results object.
Claim 4
Dependent Claim
52 words
A method as claimed in claim 1, in which an object having data which is related or potentially related to the query sends a pointer to the results object, whereby the results object can locate the object with the potentially useful data should the data be required to respond to the query.
Claim 5
Dependent Claim
28 words
A method as claimed in claim 1, in which a message is sent out in step (A) of claim 1 to all objects within a class of objects.
Claim 6
Dependent Claim
58 words
A method as claimed in claim 1, in which a plurality of messages is sent out during step (A) of claim 1, and some such messages are sent to individual objects and, others are sent to groups of objects, and each said second object which receives both types of messages processes both types of messages from a queue.
Claim 7
Dependent Claim
34 words
A message as claimed in claim 5, in which the messages are accorded different priorities for processing according to whether they are messages to a group of objects or to said individual second object.
Claim 8
Dependent Claim
37 words
A method as claimed in claim 1, in which some messages as set out in step (A) of claim 1 are accorded different priorities, and such priorities are used to order messages in a queue for processing.
Claim 9
Dependent Claim
103 words
A method as claimed in claim 1 including the step of coordinating the processing of messages directed to groups of objects with the processing of messages directed to individual objects so that an individual second object is retrieved from physical storage to be processed by a thread, all messages directed to that individual object and directed to the groups of objects which include that object are processed as they relate to that object, and one or more output messages are generated by that object as set out in step (B) of claim 1 prior to processing of another second object by the thread.
Claim 10
Dependent Claim
40 words
A method as set out in claim 1 which includes the additional step of maintaining counts of unprocessed outstanding messages generated in steps (A), through (D) and reporting that the query has been completed when such counts are all zero.
Claim 11
Dependent Claim
210 words
In a distributed database having network nodes, the improvement in query processing which comprises A) sending at least one message from an object on a first node to at least one object on a second node within the database, B) said message being acted upon by the method of the second object to form at least one message from each second object which has some of the data sought or other potentially relevant data, each such output containing some of the data sought or data which is related or potentially related to the data sought or a pointer to such data, (C) each said output proceeding independently either to another object so said output can be acted upon by the method of such other object to form a further output or to a results object which stores final or intermediate results, and (D) each object which has sent an output not awaiting replies from other objects to which its output has been sent before finishing its processing, (E) maintaining a message count of unprocessed outstanding messages generated in steps (A) through (C) at each node which receives such messages, and (F) causing such node to notify all other nodes which have sent it messages when its local processing is complete.
Claim 12
Dependent Claim
210 words
In a distributed database having network nodes, the improvement in query processing which comprises A) sending at least one message from an object on a first node to at least one object on a second node within the database, B) said message being acted upon by the method of the second object to form at least one message from each second object which has some of the data sought or other potentially relevant data, each such output containing some of the data sought or data which is related or potentially related to the data sought or a pointer to such data, (C) each said output proceeding independently either to another object so said output can be acted upon by the method of such other object to form a further output or to a results object which stores final or intermediate results, and (D) each object which has sent an output not awaiting replies from other objects to which its output has been sent before finishing its processing, (E) maintaining a message count of unprocessed outstanding messages generated in steps (A) through (C) at each node which receives such messages, and (F) causing such node to notify all other nodes which have sent it messages when its local processing is complete.
References Cited (Backward Citations)
US5471629A
Cited
US5564119A
Cited
US5313629A
Cited
US5619713A
Cited
US5652882A
Cited
US5437027A
Cited
US5291583A
Cited
US5212787A
Cited
US5542078A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-05-11 | 2001-11-10 | 2002-05-12 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-05-11 | 2005-11-10 | 2006-05-12 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-05-11 | 2009-11-10 | 2010-05-12 | $7700.00 | Window Closed / Lapsed |