| System and method for optimizing queries on views defined by conditional expressions having mutually exclusive conditions I Finlay, C Zuzarte US Patent App. 10/427,311, 2004 | 171 | 2004 |
| Recommending materialized views and indexes with the IBM DB2 design advisor DC Zilio, C Zuzarte, S Lightstone, W Ma, GM Lohman, RJ Cochrane, ... International Conference on Autonomic Computing, 2004. Proceedings., 180-187, 2004 | 156 | 2004 |
| Query optimization by transparently altering properties of relational tables using materialized views RJ Cochrane, G Lapis, TY Leung, MH Pirahesh, MS Urata, RS Sidle, ... US Patent 6,339,769, 2002 | 145 | 2002 |
| System and method for selective incremental deferred constraint processing after bulk loading data PKC Chan, RJ Cochrane, SS Lightstone, MH Pirahesh, RS Sidle, ... US Patent 6,453,314, 2002 | 140 | 2002 |
| System and method for transforming queries using window aggregation Q Cheng, L Liu, W Ma, MH Pirahesh, CP Zuzarte US Patent 7,275,056, 2007 | 127 | 2007 |
| System and method for constraint checking bulk data in a database RJ Cochrane, MH Pirahesh, RS Sidle, CP Zuzarte US Patent 5,706,494, 1998 | 121 | 1998 |
| Cardinality estimation using neural networks H Liu, M Xu, Z Yu, V Corvinelli, C Zuzarte Proceedings of the 25th Annual International Conference on Computer Science …, 2015 | 116 | 2015 |
| Canonical abstraction for outerjoin optimization MH Pirahesh, J Rao, C Zuzarte US Patent 7,478,080, 2009 | 109 | 2009 |
| Method for recommending indexes and materialized views for a database workload DC Zilio, GG Valentin, GM Lohman, CP Zuzarte, RJ Cochrane, ... US Patent 7,007,006, 2006 | 100 | 2006 |
| Self tuning database retrieval optimization using regression functions M Keller, CP Zuzarte US Patent 7,136,850, 2006 | 86 | 2006 |
| Generating targeted queries for database testing C Mishra, N Koudas, C Zuzarte Proceedings of the 2008 ACM SIGMOD international conference on Management of …, 2008 | 81 | 2008 |
| Generating statistical views in a database system Q Cheng, JF Hornibrook, TY Leung, X Wu, DC Zilio, CP Zuzarte US Patent 9,727,608, 2017 | 71 | 2017 |
| System and method for multiple distinct aggregate queries JA Saborit, MA Flasza, M Kandil, SP Rielau, DC Sharpe, CP Zuzarte US Patent 8,005,868, 2011 | 71 | 2011 |
| System and process for evaluating the performance of a database system JF Hornibrook, JE Lumby, W Rjaibi, CP Zuzarte US Patent 6,615,222, 2003 | 70 | 2003 |
| Method, system, and program for query optimization with algebraic rules Q Cheng, MH Pirahesh, Y Sun, CP Zuzarte US Patent 7,240,078, 2007 | 58 | 2007 |
| Method, system and program for joining source table rows with target table rows JL Lariba-Pey, V Muntés-Mulero, HW Pereyra, J Aguilar-Saborit, ... US Patent 7,512,625, 2009 | 57 | 2009 |
| Method to estimate the number of distinct value combinations for a set of attributes in a database system CP Zuzarte, X Yu US Patent 8,572,067, 2013 | 55 | 2013 |
| Method, system, and program for executing a query having a union all operator and data modifying operations L Liu, RP Neugebauer, DC Sharpe, N Sutyanyong, CP Zuzarte US Patent 7,533,087, 2009 | 54 | 2009 |
| Query optimization method for incrementally estimating the cardinality of a derived relation when statistically correlated predicates are applied JC Freytag, GM Lohman, DE Simmen, CP Zuzarte US Patent 6,738,755, 2004 | 51 | 2004 |
| Method, system and program for executing a query having a UNION operator BG Lindsay, L Liu, RP Neugebauer, MH Pirahesh, DC Sharpe, ... US Patent 7,409,385, 2008 | 49 | 2008 |
