Andrew M Witkowski, 44Newark, DE

6477525, Nov 5, 2002

Dec 28, 1998

09/221363

Randall Bello - Hampton NH
James Finnerty - Lexington MA
Mohamed Ziauddin - Fremont CA
Andrew Witkowski - Foster City CA

Oracle Corporation - Redwood Shores CA

G06F 1700

707 3, 707 4, 707200

A method and system are provided for processing queries. According to one aspect of the invention, a query that does not reference a particular materialized view is rewritten to reference the materialized view. In particular, upon receiving the query, it is determined whether the particular materialized view satisfies each condition in a set of conditions, where the set of conditions at least includes a condition that the materialized view reflects all rows that exist in a common section. The common section is a section of the query that is common to both the materialized view and the query. If the materialized view satisfies each condition in the set of conditions, then the query is rewritten to produce a rewritten query that references the materialized view. The materialized view may be a summary table that includes a summary column. The summary column contains values generated by aggregating values contained in rows produced by a one-to-many lossless join.

6496819, Dec 17, 2002

Dec 28, 1998

09/221641

Randall Bello - Hampton NH
James Finnerty - Lexington MA
Mohamed Ziauddin - Fremont CA
Andrew Witkowski - Foster City CA

Oracle Corporation - Redwood Shores CA

G06F 1700

707 3, 707 4, 707200

A method and system is provided for processing queries. Specifically, techniques are provided for handling a query that does not reference a particular materialized view, where the query requires access to values from a particular column not contained in the materialized view. A technique is also provided for processing a query that does not reference a particular materialized aggregate view, where the materialized aggregate view specifies an outer join between a child table and a parent table and the query specifies a particular type of join between the child table and the parent table, where the particular type of join is one of an inner join, an anti-join and a semi-join. The query is rewritten to produce a rewritten query that accesses the materialized aggregate view to produce data required by the query. A technique is also provided for processing a query that does not reference a particular materialized view and that specifies that results are to be grouped by a first set of one or more columns, where the materialized view reflects data that is grouped by a second set of one or more columns. If each column in the first set of columns either exactly matches a column in the second set of columns, is functionally dependent on another column in the first set of columns, or is functionally dependent on a column in the second set of columns, then the query is rewritten to produce a rewritten query that references the materialized view.

8001112, Aug 16, 2011

Jul 23, 2004

10/898304

Matthew Dombroski - Lancaster MA, US
Ekrem Soylemez - Arlington MA, US
Andrew Witkowski - Foster City CA, US

Oracle International Corporation - Redwood Shores CA

G06F 7/00

707718, 707760

Approaches are disclosed for using a multidimensional database as a surrogate for a run-time hash table in the context of processing a relational query. In an embodiment, an analytic workspace is used to store data, wherein the data is to be evaluated using a by a function in the processing of a MODEL clause. The approaches eliminate the need to use a hash table to store the data that is to be evaluated. The data may initially reside in the analytic workspace, or it may be loaded into the analytic workspace.

2021002, Jan 28, 2021

Jul 26, 2019

16/523872

- Redwood Shores CA, US
Randall Bello - Hampton NH, US
Andrew Witkowski - Foster City CA, US

G06F 16/248
G06F 16/2453
G06F 16/242

Definitions of material views are automatically generated. In general, Automated MV generation identifies a set of candidates MVs by examining a working set of query blocks. Once the candidates are formed, the candidate MVs are further evaluated to calculate a benefit to the candidate MVs. An improved approach for generating a candidate set of MVs is described herein. The improved approach is referred to as the extended covering subexpression technique (ECSE). Under ECSE, various relationships between join sets other than strict equivalence are used to generate new resultant join sets. Such relationships include subset, intersection, superset, and union, which shall be described in further detail below. In some cases, relationships among resultant join sets and initial join sets are considered to generate new resultant join sets. The final resultant join sets are then used to form a candidate set of MVs.