Inventor

FINNERTY JAMES

US4 patents

Patents

4 patents

US6496819B1Dec 17, 2002

Rewriting a query in terms of a summary based on functional dependencies and join backs, and based on join derivability

ORACLE CORP715 citations98

US6205451B1Mar 20, 2001

Method and apparatus for incremental refresh of summary tables in a database system

ORACLE CORP151 citations97

US5991754ANov 23, 1999

Rewriting a query in terms of a summary based on aggregate computability and canonical format, and when a dimension table is on the child side of an outer join

ORACLE CORP239 citations97

US6477525B1Nov 5, 2002

Rewriting a query in terms of a summary based on one-to-one and one-to-many losslessness of joins

ORACLE CORP98 citations96