US5999924A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for producing sequenced queries
Assignee: Amazon Technologies Inc
•
Filing: 1997-07-25
•
Granted: 1999-12-07
•
Expires: 2017-07-25
Abstract
Abstract A method and apparatus converts an original query into a sequenced query that takes into account a range of values of a variable defined by a start and end point in performing the query. The start or end points are calculated if necessary and a query to collect all of the start and end points may be generated, and a query is generated that produces a constant set of start and end points defining consecutive periods, such that all the data in the tables related to the original query is constant over each of these periods. These two queries are merged into the original query to produce a sequenced query capable of execution on various database software and capable of taking into account the range of values of the variable in performing the original query.
Inventors
- 👤 John Bair
- 👤 Richard T Snodgrass
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-30 22:55
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/245; G06F16/2458; G06F16/2477; Y; Y10; Y10S; Y10S707/00; Y10S707/912; Y10S707/917; Y10S707/99931; Y10S707/99932; Y10S707/99933; Y10S707/99934; Y10S707/99935; Y10S707/99941; Y10S707/99943; Y10S707/99951; Y10S707/99952; Y10S707/99953
Claims Analysis
Total Claims: 33
Claim 1
Independent Claim
205 words
An apparatus for producing at least one sequenced query comprising: a query receiver having an input for receiving and storing a first query describing at least one set of a plurality of data comprising a plurality of start and end point data and comprising other data and having an output for providing the first query; a constant set query builder module having a first input coupled to the query receiver output for building and providing at an output at least one second query capable of producing a result defining a set of a plurality of beginning and end point pairs, each said pair defining a constant range of at least a part of the other data in the at least one set of a plurality of data described in the first query received by at the constant set query builder first input; and a query builder module having a first input coupled to the query receiver output and a second input coupled to the constant set query builder module output for building and providing at an output the at least one sequenced query responsive to the first query received by the query receiver and the second query built by the constant set query builder module.
Claim 2
Independent Claim
205 words
An apparatus for producing at least one sequenced query comprising: a query receiver having an input for receiving and storing a first query describing at least one set of a plurality of data comprising a plurality of start and end point data and comprising other data and having an output for providing the first query; a constant set query builder module having a first input coupled to the query receiver output for building and providing at an output at least one second query capable of producing a result defining a set of a plurality of beginning and end point pairs, each said pair defining a constant range of at least a part of the other data in the at least one set of a plurality of data described in the first query received by at the constant set query builder first input; and a query builder module having a first input coupled to the query receiver output and a second input coupled to the constant set query builder module output for building and providing at an output the at least one sequenced query responsive to the first query received by the query receiver and the second query built by the constant set query builder module.
Claim 3
Dependent Claim
84 words
The apparatus of claim 1 additionally comprising a start and end point data query builder module having a first input coupled to the query receiver output, the start and end point data query builder for building and providing at an output at least one third query capable of producing a result comprising at least a plurality of the start and end point data in the at least one set of the plurality of data described in the first query received by the query receiver.
Claim 4
Dependent Claim
46 words
The apparatus of claim 2 wherein the constant set query builder additionally comprises a second input coupled to the start and end point data builder output and builds the second query responsive to the third query built by the start and end point data query builder.
Claim 5
Dependent Claim
29 words
The apparatus of claim 3 wherein the constant set query builder builds the second query comprising the third query built by the start and end point data query builder.
Claim 6
Dependent Claim
82 words
The apparatus of claim 2 wherein: the start and end point data query builder module builds the third query comprising a command to select at least a plurality of the start and end point data; and the constant set query builder module builds the second query comprising a command to select less than all of the at least the plurality selected from the start and end point data described by the command built by the start and end point data query builder.
Claim 7
Dependent Claim
52 words
The apparatus of claim 5 wherein the start and end point data query builder module builds the third query comprising a command to calculate from the start and end point data at least one data selected from a start point and an end point implied by the start and end point data.
Claim 8
Dependent Claim
66 words
The apparatus of claim 5 wherein the start and end point data query builder builds the third query comprising a command to add a unit to at least one of an end points comprising at least a portion of the start and end point data in the at least one set of the plurality of data described in the first query stored by the query receiver.
Claim 9
Dependent Claim
42 words
The apparatus of claim 5 wherein the first, second and third queries comprise text, and the query builder module builds a query comprising: the text of the first query; the text of the second query; and the text of the third query.
Claim 10
Dependent Claim
73 words
The apparatus of claim 1 additionally comprising a normalizer module having an input coupled to the query receiver output and an output coupled to the constant set query builder module first input, the normalizer module for modifying at least a portion of the start and end point data in at least one of the at least one set of the plurality of data described in the first query received by the query receiver.
Claim 11
Dependent Claim
90 words
The apparatus of claim 9 wherein the normalizer module modifies at least a portion of the start and end point data in at least one of the at least one set of the plurality of data described in the first query received by the query receiver to cause said start and end point data to conform to a measurement of a remainder of the start and end point data in the at least one set of the plurality of data described in the first query received by the query receiver.
Claim 12
Independent Claim
109 words
A method of building a sequenced query, comprising: receiving a first query describing at least one set of a plurality of data comprising start and end point data and comprising other data; storing the query received; building a second query capable of producing a result defining a set of a plurality of start and end point pairs, each said pair defining a constant range of at least a part of the start and end point data in the at least one set of the plurality of data described in the first query received; and building the sequenced query responsive to the first query received and the second query built.
Claim 13
Independent Claim
109 words
A method of building a sequenced query, comprising: receiving a first query describing at least one set of a plurality of data comprising start and end point data and comprising other data; storing the query received; building a second query capable of producing a result defining a set of a plurality of start and end point pairs, each said pair defining a constant range of at least a part of the start and end point data in the at least one set of the plurality of data described in the first query received; and building the sequenced query responsive to the first query received and the second query built.
Claim 14
Dependent Claim
50 words
The method of claim 11 comprising the additional step of building at least one third query capable of producing a result comprising at least a portion of the start and end point data in the at least one set of the plurality of data described in the first query received.
Claim 15
Dependent Claim
21 words
The method of claim 12 wherein building the second query comprises building the second query responsive to the third query built.
Claim 16
Dependent Claim
25 words
The method of claim 13 wherein building the second query responsive to the third query comprises building the second query comprising the third query built.
Claim 17
Dependent Claim
58 words
The method of claim 12 wherein: the third query comprises a command to select at least a plurality of the start and end point data; and the second query comprises a command to select less than all of the at least the plurality of the start and end point data selected by the command comprising the third query.
Claim 18
Dependent Claim
47 words
The method of claim 15 wherein the third query comprises a command to calculate from the start and end point data at least one data selected from a start point and an end point implied by at least a portion of the start and end point data.
Claim 19
Dependent Claim
51 words
The method of claim 15 wherein the third query comprises a command to add a unit to at least one end points comprising at least a portion of the start and end point data in the at least one set of the plurality of data described in the first query stored.
Claim 20
Dependent Claim
42 words
The method of claim 15 wherein the first, second and third queries comprise text, and the building the sequenced query comprises assembling together: the text of the first query; the text of the second query; and the text of the third query.
Claim 21
Dependent Claim
43 words
The method of claim 11 comprising the additional step of modifying at least a portion of the start and end point data in at least one of the at least one set of the plurality of data described in the first query stored.
Claim 22
Dependent Claim
87 words
The method of claim 19 wherein the modifying step comprises modifying at least a portion of the start and end point data in at least one of the at least one set of the plurality of data described in the first query stored by the query receiver to cause said start and end point data to conform to a measurement of a remainder of the start and end point data in the at least one set of the plurality of data described in the first query stored.
Claim 23
Dependent Claim
171 words
A computer program product having a computer useable medium having computer readable program code embodied therein for building a sequenced query, the computer program product comprising: computer readable program code devices configured to cause a computer to receive a first query describing at least one set of a plurality of data comprising start and end point data and comprising other data; computer readable program code devices configured to cause a computer to store the query received; computer readable program code devices configured to cause a computer to build a second query capable of producing a result defining a set of a plurality of start and end point pairs, each said pair defining a constant range of at least a part of the start and end point data in the at least one set of the plurality of data described in the first query received; and computer readable program code devices configured to cause a computer to build the sequenced query responsive to the first query received and the second query built.
Claim 24
Dependent Claim
171 words
A computer program product having a computer useable medium having computer readable program code embodied therein for building a sequenced query, the computer program product comprising: computer readable program code devices configured to cause a computer to receive a first query describing at least one set of a plurality of data comprising start and end point data and comprising other data; computer readable program code devices configured to cause a computer to store the query received; computer readable program code devices configured to cause a computer to build a second query capable of producing a result defining a set of a plurality of start and end point pairs, each said pair defining a constant range of at least a part of the start and end point data in the at least one set of the plurality of data described in the first query received; and computer readable program code devices configured to cause a computer to build the sequenced query responsive to the first query received and the second query built.
Claim 25
Dependent Claim
60 words
The computer program product of claim 21 additionally comprising computer readable program code devices configured to cause a computer to build at least one third query capable of producing a result comprising at least a portion of the start and end point data in the at least one set of the plurality of data described in the first query received.
Claim 26
Dependent Claim
46 words
The computer program product of claim 22 wherein the computer readable program code devices configured to cause a computer to build the second query comprise computer readable program code devices configured to cause a computer to build the second query responsive to the third query built.
Claim 27
Dependent Claim
50 words
The computer program product of claim 23 wherein the computer readable program code devices configured to cause a computer to build the second query responsive to the third query comprise computer readable program code devices configured to cause a computer to build the second query comprising the third query built.
Claim 28
Dependent Claim
60 words
The computer program product of claim 22 wherein: the third query comprises a command to select at least a plurality of the start and end point data; and the second query comprises a command to select less than all of the at least the plurality of the start and end point data selected by the command comprising the third query.
Claim 29
Dependent Claim
49 words
The computer program product of claim 25 wherein the third query comprises a command to calculate from the start and end point data at least one data selected from a start point and an end point implied by at least a portion of the start and end point data.
Claim 30
Dependent Claim
53 words
The computer program product of claim 25 wherein the third query comprises a command to add a unit to at least one end points comprising at least a portion of the start and end point data in the at least one set of the plurality of data described in the first query stored.
Claim 31
Dependent Claim
66 words
The computer program product of claim 25 wherein the first, second and third queries comprise text, and the computer readable program code devices configured to cause a computer to build the sequenced query comprises computer readable program code devices configured to cause a computer to assemble together: the text of the first query; the text of the second query; and the text of the third query.
Claim 32
Dependent Claim
53 words
The computer program product of claim 21 additionally comprising computer readable program code devices configured to cause a computer to modify at least a portion of the start and end point data in at least one of the at least one set of the plurality of data described in the first query stored.
Claim 33
Dependent Claim
142 words
The computer program product of claim 29 wherein the computer readable program code devices configured to cause a computer to modify at least a portion of the start and end point data in at least one of the at least one set of the plurality of data described in the first query stored comprise computer readable program code devices configured to cause a computer to modify at least a portion of the start and end point data in at least one of the at least one set of the plurality of data described in the first query stored by the query receiver to cause said start and end point data to conform to a measurement of a remainder of the start and end point data in the at least one set of the plurality of data described in the first query stored.
References Cited (Backward Citations)
US4748439A
Cited
US4924435A
Cited
US4956774A
Cited
US5440730A
Cited
US5265065A
Cited
US5418948A
Cited
US5495606A
Cited
US5574900A
Cited
US5600831A
Cited
US5710916A
Cited
US5706495A
Cited
US5745899A
Cited
EP0855656A2
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-12-06 | 2003-06-07 | 2003-12-07 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-12-06 | 2007-06-07 | 2007-12-07 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-12-06 | 2011-06-07 | 2011-12-07 | $7700.00 | Window Closed / Lapsed |