Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2007-09-18
2007-09-18
Wong, Don (Department: 2163)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000
Reexamination Certificate
active
11096149
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: 6334128 (2001-12-01), Norcott et al.
patent: 6356920 (2002-03-01), Vandersluis
patent: 6477525 (2002-11-01), Bello et al.
patent: 6493708 (2002-12-01), Ziauddin et al.
patent: 6496819 (2002-12-01), Bello et al.
patent: 6505189 (2003-01-01), On Au et al.
patent: 6643636 (2003-11-01), Au et al.
patent: 6708186 (2004-03-01), Claborn et al.
patent: 6785673 (2004-08-01), Fernandez et al.
patent: 6850933 (2005-02-01), Larson et al.
patent: 6934712 (2005-08-01), Kiernan et al.
patent: 7043499 (2006-05-01), Nelson et al.
patent: 7120645 (2006-10-01), Manikutty et al.
patent: 7127469 (2006-10-01), Lindblad et al.
patent: 2001/0047372 (2001-11-01), Gorelik et al.
patent: 2003/0154189 (2003-08-01), Egilsson et al.
patent: 2004/0122804 (2004-06-01), Zhang et al.
patent: 2005/0097084 (2005-05-01), Balmin et al.
patent: 2005/0114307 (2005-05-01), Le et al.
Cunningham Conor J.
Galindo-Legaria Cesar A.
Hanson Eric N.
Joshi Milind M.
Waas Florian M.
Dang Thanh-Ha
Wong Don
Woodcock & Washburn LLP
LandOfFree
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.
Profile ID: LFUS-PAI-O-3751629