Inventor

WITKOWSKI ANDREW

US71 patents

⚠️ This page may combine multiple inventors who share the name “WITKOWSKI ANDREW”. Patents are grouped by organization below to help distinguish them — per-person disambiguation is on the roadmap.

WITKOWSKI ANDREW

ORACLE INT CORP

Evaluation of rollups with distinct aggregates by using sequence of sorts and partitioning by measures

Method and apparatus for optimizing computation of OLAP ranking functions

Methods of navigating a cube that is implemented as a relational object

Incremental refresh of materialized views containing rank function, and rewrite of queries containing rank or rownumber or min/max aggregate functions using such a materialized view

Evaluation of grouping sets by reduction to group-by clause, with or without a rollup operator, using temporary tables

Compile-time optimizations of queries with SQL spreadsheet

Performing spreadsheet-like calculations in a database system

Techniques for eliminating database table joins based on a join index

Sort-merge band join optimization

Pruning disk blocks of a clustered table in a relational database management system

Rewrite of queries containing rank or rownumber or Min/Max aggregate functions using a materialized view

Using estimated cost to schedule an order for refreshing a set of materialized views (MVS)

Compile-time optimizations of queries with SQL spreadsheet

Run-time optimizations of queries with SQL spreadsheet

Choosing whether to use a delayed index maintenance depending on the portion of the materialized view (MV) changed

Union all rewrite for aggregate queries with grouping sets

Spreadsheet to SQL translation

Evaluation of database hierarchical cubes by nesting rollup operators associated with multiple groupings

Group pruning from cube, rollup, and grouping sets

Using multidimensional access as surrogate for run-time hash table

Clustering a table in a relational database management system

Adaptive selection of a distribution method during execution of parallel join operations

In-memory cursor duration temp tables

Using temporary tables to store graph algorithm results for a relational database management system

Efficient SQL-based graph random walk

Efficient compilation of graph queries involving long graph query patterns on top of SQL based relational engine

Bitmap-based count distinct query rewrite in a relational SQL algebra

Parallel execution of queries with a recursive clause

Function semantic based partition-wise SQL execution and partition pruning

ORACLE CORP

Apparatus and method for aggregate indexes

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

System and method for processing queries having an inner query block containing a grouping operator

Concurrency control for transactions that update base tables of a materialized view using different types of locks

Incremental maintenance of materialized views containing one-to-one lossless joins

Incremental maintenance of materialized views containing one-to-N lossless joins

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

Using materialized view to process a related query containing a one to many lossless join

Rewriting queries to access materialized views that group along an ordered dimension

Techniques for handling function-defined hierarchical dimensions

Method and apparatus for accessing previous rows of data in a table

Using a materialized view to process a related query containing an antijoin

Using a materialized view to process a related query containing a one to many lossless join

Method and article for processing queries that define outer joined views

LUCENT TECHNOLOGIES INC

Incremental maintenance of an approximate histogram in a database system

Method for maintaining information in a database used to generate high biased histograms using a probability function, counter and threshold values

FOLKERT NATHANIEL KEITH

Using estimated cost to refresh a set of materialized views (MVS)

Using join dependencies for refresh

GUPTA ABHINAV

Rewrite of queries containing rank or rownumber or min/max aggregate functions using a materialized view

WITKOWSKI ANDREW

Using relational structures to create and support a cube within a relational database system

BOZKAYA TOLGA

Analytic enhancements to model clause in structured query language (SQL)