Method and apparatus for producing sequenced queries

Details Method and apparatus for producing sequenced queries Method and apparatus for producing sequenced queries

1997-07-25

1999-12-07

Lintz, Paul R.

Data processing: database and file management or data structures

Database design

Data structure types

707 2, 707 3, 707 5, G06F 1730

Patent

active

059999241

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.

REFERENCES:
patent: 4748439 (1988-05-01), Robinson et al.
patent: 4924435 (1990-05-01), Brunvand et al.
patent: 4956774 (1990-09-01), Shibamiya et al.
patent: 5265065 (1993-11-01), Turtle
patent: 5418948 (1995-05-01), Turtle
patent: 5440730 (1995-08-01), Elmasri et al.
patent: 5495606 (1996-02-01), Borden et al.
patent: 5574900 (1996-11-01), Huang et al.
patent: 5600831 (1997-02-01), Levy et al.
patent: 5706495 (1998-01-01), Chadha et al.
patent: 5710916 (1998-01-01), Barbara et al.
patent: 5745899 (1998-04-01), Burrows
Elmasri, ramez et al., "Partitioning of Time Index for Optical Disks" 1992 IEEE pp. 574-583, Jul. 1992.
Schikuta, Erich et al., "A Knowledge Base for the Optimization of Parallel Query Execution Plan", 1997 IEEE pp. 331-337, Sep. 1997.
Wu, Chao-Hui et al., "Querying Multimedia Presentations" 1997 IEEE pp. 64-73, Jun. 1997.

Affiliated with

Also associated with

Rating

Method and apparatus for producing sequenced queries does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and apparatus for producing sequenced queries, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for producing sequenced queries will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-835898