Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2001-10-26
2009-11-17
Wong, Leslie (Department: 2164)
Data processing: database and file management or data structures
Database design
Data structure types
C707SE17017
Reexamination Certificate
active
07620615
ABSTRACT:
A database system includes object relational tables having at least one complex attribute. The database system also includes an optimizer module that selects a join plan for a given query that specifies a join of multiple tables. If the query includes a function selected from the group consisting of a selection predicate applied on a complex attribute, a projection applied on a complex attribute, and a user-defined data type method, then a join path for the join query is determined based in part on a cost associated with application of the function. Application of the function is performed on one of a base table and a join table depending on which has a lower cardinality. The join table is a result of a join of the base table and another table.
REFERENCES:
patent: 5608904 (1997-03-01), Chaudhuri et al.
patent: 5640584 (1997-06-01), Kandasamy et al.
patent: 5864842 (1999-01-01), Pederson et al.
patent: 5872904 (1999-02-01), McMillen et al.
patent: 5884299 (1999-03-01), Ramesh et al.
patent: 5956706 (1999-09-01), Carey et al.
patent: 6026390 (2000-02-01), Ross et al.
patent: 6138111 (2000-10-01), Krishna
patent: 6275818 (2001-08-01), Subramanian et al.
patent: 6338056 (2002-01-01), Dessloch et al.
patent: 6341281 (2002-01-01), MacNicol et al.
patent: 6351742 (2002-02-01), Agarwal et al.
patent: 6370522 (2002-04-01), Agarwal et al.
patent: 6377943 (2002-04-01), Jakobsson
patent: 6516310 (2003-02-01), Paulley
patent: 6763359 (2004-07-01), Lohman et al.
patent: 6947934 (2005-09-01), Chen et al.
patent: 7062481 (2006-06-01), Pham et al.
patent: 2006/0230016 (2006-10-01), Cunningham et al.
Peter Gulutzan&Trudy Pelzer, “SQL-99 Complete, Really,” pp. 30-33, 517-539 (1999).
Teradata , US Inc.
Trop Pruner & Hu P.C.
Wong Leslie
LandOfFree
Joins of relations in an object relational database system does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Joins of relations in an object relational database system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Joins of relations in an object relational database system will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4061403