Inventor · disambiguated record
Andrew Witkowski
Also filed as: WITKOWSKI ANDREW · WITKOWSKI ANDREW S C
71 granted patents·8 pending applications·3,438 citations·filing 1995–2025
99Inventor score
Files withORACLE INT CORP56ORACLE CORP14BOZKAYA TOLGA3FOLKERT NATHANIEL KEITH2LUCENT TECHNOLOGIES INC2
Top patents by PatentIndex Score
79 records- 0198US6496819B1Rewriting a query in terms of a summary based on functional dependencies and join backs, and based on join derivabilityORACLE CORP·Filed 1998·Granted Dec 17, 2002·715 cites·30 claims
- 0296US10635671B2Sort-merge band join optimizationORACLE INT CORP·Filed 2017·Granted Apr 28, 2020·22 cites·28 claims
- 0396US8996544B2Pruning disk blocks of a clustered table in a relational database management systemORACLE INT CORP·Filed 2012·Granted Mar 31, 2015·34 cites·18 claims
- 0496US7171427B2Methods of navigating a cube that is implemented as a relational objectORACLE INT CORP·Filed 2003·Granted Jan 30, 2007·305 cites·27 claims
- 0596US6775682B1Evaluation of rollups with distinct aggregates by using sequence of sorts and partitioning by measuresORACLE INT CORP·Filed 2002·Granted Aug 10, 2004·150 cites·28 claims
- 0694US12124448B2Using temporary tables to store graph algorithm results for a relational database management systemORACLE INT CORP·Filed 2022·Granted Oct 22, 2024·4 cites·34 claims
- 0794US6622138B1Method and apparatus for optimizing computation of OLAP ranking functionsORACLE INT CORP·Filed 2000·Granted Sep 16, 2003·151 cites·26 claims
- 0893US6775681B1Evaluation of grouping sets by reduction to group-by clause, with or without a rollup operator, using temporary tablesORACLE INT CORP·Filed 2002·Granted Aug 10, 2004·113 cites·27 claims
- 0992US9659039B2Maintaining staleness information for aggregate dataORACLE INT CORP·Filed 2013·Granted May 23, 2017·21 cites·38 claims
- 1092US8103689B2Rewrite of queries containing rank or rownumber or min/max aggregate functions using a materialized viewGUPTA ABHINAV·Filed 2011·Granted Jan 24, 2012·18 cites·6 claims
- 1191US7890497B2Using estimated cost to schedule an order for refreshing a set of materialized views (MVS)ORACLE INT CORP·Filed 2005·Granted Feb 15, 2011·36 cites·38 claims
- 1291US7734602B2Choosing whether to use a delayed index maintenance depending on the portion of the materialized view (MV) changedORACLE INT CORP·Filed 2005·Granted Jun 8, 2010·33 cites·16 claims
- 1391US7177855B2Compile-time optimizations of queries with SQL spreadsheetORACLE INT CORP·Filed 2003·Granted Feb 13, 2007·71 cites·6 claims
- 1491US7111020B1Incremental refresh of materialized views containing rank function, and rewrite of queries containing rank or rownumber or min/max aggregate functions using such a materialized viewORACLE INT CORP·Filed 2002·Granted Sep 19, 2006·74 cites·32 claims
- 1590US6985895B2Performing spreadsheet-like calculations in a database systemORACLE INT CORP·Filed 2001·Granted Jan 10, 2006·118 cites·36 claims
- 1689US7809712B2Compile-time optimizations of queries with SQL spreadsheetORACLE INT CORP·Filed 2006·Granted Oct 5, 2010·31 cites·38 claims
- 1788US9430550B2Clustering a table in a relational database management systemORACLE INT CORP·Filed 2012·Granted Aug 30, 2016·11 cites·18 claims
- 1888US7035843B1Evaluation of database hierarchical cubes by nesting rollup operators associated with multiple groupingsORACLE INT CORP·Filed 2002·Granted Apr 25, 2006·53 cites·28 claims
- 1988US6487546B1Apparatus and method for aggregate indexesORACLE CORP·Filed 1998·Granted Nov 26, 2002·142 cites·74 claims
- 2088US6370524B1System and method for processing queries having an inner query block containing a grouping operatorORACLE CORP·Filed 1999·Granted Apr 9, 2002·102 cites·30 claims
- 2188US6353828B1Concurrency control for transactions that update base tables of a materialized view using different types of locksORACLE CORP·Filed 1999·Granted Mar 5, 2002·97 cites·20 claims
- 2287US11507579B2Efficient compilation of graph queries involving long graph query patterns on top of SQL based relational engineORACLE INT CORP·Filed 2020·Granted Nov 22, 2022·2 cites·20 claims
- 2387US11379476B2Bitmap-based count distinct query rewrite in a relational SQL algebraORACLE INT CORP·Filed 2019·Granted Jul 5, 2022·5 cites·28 claims
- 2486US10452655B2In-memory cursor duration temp tablesORACLE INT CORP·Filed 2016·Granted Oct 22, 2019·7 cites·14 claims
- 2586US6775662B1Group pruning from cube, rollup, and grouping setsORACLE INT CORP·Filed 2001·Granted Aug 10, 2004·47 cites·24 claims
- 2686US6493708B1Techniques for handling function-defined hierarchical dimensionsORACLE CORP·Filed 2000·Granted Dec 10, 2002·47 cites·18 claims
- 2785US10019481B2Adaptive selection of a distribution method during execution of parallel join operationsORACLE INT CORP·Filed 2013·Granted Jul 10, 2018·11 cites·21 claims
- 2885US6615206B1Techniques for eliminating database table joins based on a join indexORACLE INT CORP·Filed 2002·Granted Sep 2, 2003·61 cites·18 claims
- 2984US11334567B2Efficient SQL-based graph random walkORACLE INT CORP·Filed 2019·Granted May 17, 2022·3 cites·24 claims
- 3084US7761403B2Run-time optimizations of queries with SQL spreadsheetORACLE INT CORP·Filed 2003·Granted Jul 20, 2010·41 cites·50 claims
- 3184US5870752AIncremental maintenance of an approximate histogram in a database systemLUCENT TECHNOLOGIES INC·Filed 1997·Granted Feb 9, 1999·113 cites·26 claims
- 3283US7912834B2Rewrite of queries containing rank or rownumber or Min/Max aggregate functions using a materialized viewORACLE INT CORP·Filed 2006·Granted Mar 22, 2011·16 cites·6 claims
- 3383US6134543AIncremental maintenance of materialized views containing one-to-one lossless joinsORACLE CORP·Filed 1998·Granted Oct 17, 2000·110 cites·21 claims
- 3483US6125360AIncremental maintenance of materialized views containing one-to-N lossless joinsORACLE CORP·Filed 1998·Granted Sep 26, 2000·110 cites·32 claims
- 3582US7299223B2Spreadsheet to SQL translationORACLE INT CORP·Filed 2004·Granted Nov 20, 2007·36 cites·20 claims
- 3681US6477525B1Rewriting a query in terms of a summary based on one-to-one and one-to-many losslessness of joinsORACLE CORP·Filed 1998·Granted Nov 5, 2002·98 cites·26 claims
- 3780US8156145B2Analytic enhancements to model clause in structured query language (SQL)BOZKAYA TOLGA·Filed 2011·Granted Apr 10, 2012·5 cites·10 claims
- 3879US10678792B2Parallel execution of queries with a recursive clauseORACLE INT CORP·Filed 2016·Granted Jun 9, 2020·3 cites·22 claims
- 3977US8478742B2Using estimated cost to refresh a set of materialized views (MVS)FOLKERT NATHANIEL KEITH·Filed 2005·Granted Jul 2, 2013·10 cites·14 claims
- 4077US6449609B1Using materialized view to process a related query containing a one to many lossless joinORACLE CORP·Filed 1998·Granted Sep 10, 2002·54 cites·24 claims
- 4177US6449605B1Using a materialized view to process a related query containing a one to many lossless joinORACLE CORP·Filed 1998·Granted Sep 10, 2002·54 cites·20 claims
- 4276US8868544B2Using relational structures to create and support a cube within a relational database systemWITKOWSKI ANDREW·Filed 2003·Granted Oct 21, 2014·30 cites·15 claims
- 4376US8001112B2Using multidimensional access as surrogate for run-time hash tableORACLE INT CORP·Filed 2004·Granted Aug 16, 2011·24 cites·19 claims
- 4474US12450255B2Automatic, online and space efficient clustering and compression of very large database objectsORACLE INT CORP·Filed 2023·Granted Oct 21, 2025·0 cites·20 claims
- 4573US2025307249A1Out-Of-Core BFS For Shortest Path Graph QueriesORACLE INT CORP·Filed 2025·Application pending·0 cites
- 4672US12326866B1Out-of-core BFS for shortest path graph queriesORACLE INT CORP·Filed 2024·Granted Jun 10, 2025·0 cites·20 claims
- 4772US11442933B2Function semantic based partition-wise SQL execution and partition pruningORACLE INT CORP·Filed 2017·Granted Sep 13, 2022·2 cites·46 claims
- 4872US6449606B1Using a materialized view to process a related query containing an antijoinORACLE CORP·Filed 1998·Granted Sep 10, 2002·43 cites·28 claims
- 4972US6345272B1Rewriting queries to access materialized views that group along an ordered dimensionORACLE CORP·Filed 1999·Granted Feb 5, 2002·61 cites·20 claims
- 5071US11086868B2Materialized view rewrite technique for one-sided outer-join queriesORACLE INT CORP·Filed 2019·Granted Aug 10, 2021·1 cites·22 claims
Showing the top 50 of 79 patent records by PatentIndex Score.
Identity basis: PatentsView inventor disambiguation (2025Q4-odp release). How scoring works →