Andrew Witkowski

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

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

Method and apparatus for optimizing computation of OLAP ranking functions

Compile-time optimizations of queries with SQL spreadsheet

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

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

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

Techniques for eliminating database table joins based on a join index

Spreadsheet to SQL translation

Run-time optimizations of queries with SQL spreadsheet