Andrew Witkowski
71Patents
26h-index
63Co-inventors
91Inventor score
Filing activity: Dec 28, 1995 → Mar 29, 2024
Most-cited inventions
| Patent | Title | Area | Cited by | Status |
|---|---|---|---|---|
| US6496819B1 | Rewriting a query in terms of a summary based on functional dependencies and join backs, and based on join derivability | Emerging Cross-Sectional Technologies | 624 | Expired |
| US7171427B2 | Methods of navigating a cube that is implemented as a relational object | Emerging Cross-Sectional Technologies | 263 | Expired |
| US6775682B1 | Evaluation of rollups with distinct aggregates by using sequence of sorts and partitioning by measures | Emerging Cross-Sectional Technologies | 115 | Expired |
| US6622138B1 | Method and apparatus for optimizing computation of OLAP ranking functions | Emerging Cross-Sectional Technologies | 111 | Expired |
| US6487546B1 | Apparatus and method for aggregate indexes | Emerging Cross-Sectional Technologies | 99 | Expired |
| US6985895B2 | Performing spreadsheet-like calculations in a database system | Emerging Cross-Sectional Technologies | 95 | Expired |
| US6775681B1 | Evaluation of grouping sets by reduction to group-by clause, with or without a rollup operator, using temporary tables | Emerging Cross-Sectional Technologies | 80 | Expired |
| US6134543A | Incremental maintenance of materialized views containing one-to-one lossless joins | Emerging Cross-Sectional Technologies | 70 | Expired |
| US6353828B1 | Concurrency control for transactions that update base tables of a materialized view using different types of locks | Emerging Cross-Sectional Technologies | 65 | Expired |
| US6125360A | Incremental maintenance of materialized views containing one-to-N lossless joins | Emerging Cross-Sectional Technologies | 64 | Expired |
| US5870752A | Incremental maintenance of an approximate histogram in a database system | Emerging Cross-Sectional Technologies | 64 | Expired |
| US6370524B1 | System and method for processing queries having an inner query block containing a grouping operator | Emerging Cross-Sectional Technologies | 62 | Expired |
| US6477525B1 | Rewriting a query in terms of a summary based on one-to-one and one-to-many losslessness of joins | Emerging Cross-Sectional Technologies | 58 | Expired |
| US7177855B2 | Compile-time optimizations of queries with SQL spreadsheet | Emerging Cross-Sectional Technologies | 48 | Expired |
| US7111020B1 | 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 | Emerging Cross-Sectional Technologies | 44 | Expired |
| US6615206B1 | Techniques for eliminating database table joins based on a join index | Emerging Cross-Sectional Technologies | 39 | Expired |
| US6457000B1 | Method and apparatus for accessing previous rows of data in a table | Emerging Cross-Sectional Technologies | 38 | Expired |
| US7761403B2 | Run-time optimizations of queries with SQL spreadsheet | Emerging Cross-Sectional Technologies | 35 | Active |
| US6449605B1 | Using a materialized view to process a related query containing a one to many lossless join | Emerging Cross-Sectional Technologies | 33 | Expired |
| US6345272B1 | Rewriting queries to access materialized views that group along an ordered dimension | Emerging Cross-Sectional Technologies | 30 | Expired |
| US8996544B2 | Pruning disk blocks of a clustered table in a relational database management system | Physics | 30 | Active |
| US7035843B1 | Evaluation of database hierarchical cubes by nesting rollup operators associated with multiple groupings | Emerging Cross-Sectional Technologies | 30 | Expired |
| US6775662B1 | Group pruning from cube, rollup, and grouping sets | Emerging Cross-Sectional Technologies | 29 | Expired |
| US7299223B2 | Spreadsheet to SQL translation | Emerging Cross-Sectional Technologies | 28 | Expired |
| US6449609B1 | Using materialized view to process a related query containing a one to many lossless join | Emerging Cross-Sectional Technologies | 28 | Expired |
Source: USPTO / EPO open patent data. Inventor disambiguation is heuristic; counts are objective bibliographic measures.