Structured indexes on results of function applications over...

Data processing: database and file management or data structures – Database design – Data structure types

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07340445

ABSTRACT:
Indexed views or materialized views are used as a secondary index on a base table with multi-valued attributes. This provides for using the index to search in the nested data. Moreover, indexing is provided on the result of an unnest operation. Indexing a view on the result of an unnesting operation provides the ability to index the contents of a nested collection. One such unnesting operation is “cross apply unnest”. This provides additional options for a query execution plan, leading to a more optimized query. A back-join is provided from the indexed view to the base table to allow fields from the base table that are not present in the indexed view to be included in a result of a query on the table which is processed using the indexed view as an access path. This provides a means of including columns in the query result that are not in the indexed view but are in the base table. The back-join is supported from a single-table indexed view to the base table via a unique clustering key which acts as a logical row locator. Thus, the system can back-join to the base table from an indexed view via the unique clustering key. These features allow the use of indexed views to index a table on the contents of multi-set or multi-valued attributes.

REFERENCES:
patent: 5991754 (1999-11-01), Raitto et al.
patent: 6289334 (2001-09-01), Reiner et al.
patent: 6418448 (2002-07-01), Sarkar
patent: 6496819 (2002-12-01), Bello et al.
patent: 6505189 (2003-01-01), On Au et al.
patent: 6513029 (2003-01-01), Agrawal et al.
patent: 6618719 (2003-09-01), Andrei
patent: 6636870 (2003-10-01), Roccaforte
patent: 6708186 (2004-03-01), Claborn et al.
patent: 6785673 (2004-08-01), Fernandez et al.
patent: 6799184 (2004-09-01), Bhatt et al.
patent: 6912538 (2005-06-01), Stapel et al.
patent: 6934712 (2005-08-01), Kiernan et al.
patent: 7103590 (2006-09-01), Murthy et al.
patent: 2001/0047372 (2001-11-01), Gorelik et al.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Structured indexes on results of function applications over... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Structured indexes on results of function applications over..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Structured indexes on results of function applications over... will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-3963238

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.