Patent ID: 6449605
Filing Date: 2002-09-10
Classification: G06F,Y10S

Abstract:
A method of transforming a first query, the method comprising the steps of:receiving the first query; determining whether a common section is shared between a view and said first query, wherein: said view is a join view that combines data from a plurality of base tables, a view definition for said view includes a join between said common section and a materialized view delta of said view, said plurality of base tables are not constrained such that said join between said common section and said materialized view delta is one-to-one with respect to said common section; determining whether said join between said common section and said materialized view delta is lossless with respect to said common section; and if said join between said common section and said materialized view delta is lossless with respect to said common section, then transforming said first query into a second query that accesses data through said view, said second query returning the set of data specified by said first query.