Discovery and Application of Check Constraints in DB2. - Jarek Gryz; K. Bernhard Schiefer; Jian Zheng; Calisto Zuzarte (ICDE, 2001)

Exploiting Constraint-Like Data Characterizations in Query Optimization. - Parke Godfrey; Jarek Gryz; Calisto Zuzarte (SIGMOD Conference, 2001)

Exploiting common subqueries for complex query optimization. - Yingying Tao; Qiang Zhu 001; Calisto Zuzarte (CASCON, 2002)

Optimizing large star-schema queries with snowflakes via heuristic-based query rewriting. - Yingying Tao; Qiang Zhu 001; Calisto Zuzarte; Wing Lau (CASCON, 2003)

Exploiting Similarity of Subqueries for Complex Query Optimization. - Yingying Tao; Qiang Zhu 001; Calisto Zuzarte (DEXA, 2003)

WinMagic : Subquery Elimination Using Window Aggregation. - Calisto Zuzarte; Hamid Pirahesh; Wenbin Ma; Qi Cheng; Linqi Liu; Kwai Wong (SIGMOD Conference, 2003)

Recommending Materialized Views and Indexes with IBM DB2 Design Advisor. - Daniel C. Zilio; Calisto Zuzarte; Sam Lightstone; Wenbin Ma; Guy M. Lohman; Roberta Cochrane; Hamid Pirahesh; Latha S. Colby; Jarek Gryz; Eric Alton; Dongming Liang; Gary Valentin (ICAC, 2004)

Characterization of the data access behavior for TPC-C traces. - R. Bonilla-Lucas; Peter Plachta; Aamer Sachedina; Daniel Jiménez-González; Calisto Zuzarte; Josep Lluís Larriba-Pey (ISPASS, 2004)

Query Sampling in DB2 Universal Database. - Jarek Gryz; Junjie Guo; Linqi Liu; Calisto Zuzarte (SIGMOD Conference, 2004)

Canonical Abstraction for Outerjoin Optimization. - Jun Rao; Hamid Pirahesh; Calisto Zuzarte (SIGMOD Conference, 2004)

Towards estimating the number of distinct value combinations for a set of attributes. - Xiaohui Yu 001; Calisto Zuzarte; Kenneth C. Sevcik (CIKM, 2005)

Ad Hoc Star Join Query Processing in Cluster Architectures. - Josep Aguilar-Saborit; Victor Muntés-Mulero; Calisto Zuzarte; Josep Lluís Larriba-Pey (DaWaK, 2005)

Optimizing complex queries based on similarities of subqueries. - Qiang Zhu 001; Yingying Tao; Calisto Zuzarte (Knowl. Inf. Syst., 2005)

Exchange, integration, and consistency of data: report on the ARISE/NISR workshop. - Leopoldo E. Bertossi; Jan Chomicki; Parke Godfrey; Phokion G. Kolaitis; Alex Thomo; Calisto Zuzarte (SIGMOD Rec., 2005)

Analyzing the Genetic Operations of an Evolutionary Query Optimizer. - Victor Muntés-Mulero; Josep Aguilar-Saborit; Calisto Zuzarte; Volker Markl; Josep Lluís Larriba-Pey (BNCOD, 2006)

Preprocessing for Fast Refreshing Materialized Views in DB2. - Wugang Xu; Calisto Zuzarte; Dimitri Theodoratos; Wenbin Ma (DaWaK, 2006)

Parameterizing a Genetic Optimizer. - Victor Muntés-Mulero; Marta Pérez-Casany; Josep Aguilar-Saborit; Calisto Zuzarte; Josep Lluís Larriba-Pey (DEXA, 2006)

Computing closest common subexpressions for view selection problems. - Wugang Xu; Dimitri Theodoratos; Calisto Zuzarte (DOLAP, 2006)

HASE: A Hybrid Approach to Selectivity Estimation for Conjunctive Predicates. - Xiaohui Yu 001; Nick Koudas; Calisto Zuzarte (EDBT, 2006)

CGO: A Sound Genetic Optimizer for Cyclic Query Graphs. - Victor Muntés-Mulero; Josep Aguilar-Saborit; Calisto Zuzarte; Josep Lluís Larriba-Pey (International Conference on Computational Science (1), 2006)

Load Balancing for Multi-tiered Database Systems through Autonomic Placement of Materialized Views. - Wen-Syan Li; Daniel C. Zilio; Vishal S. Batra; Mahadevan Subramanian; Calisto Zuzarte; Inderpal Narang (ICDE, 2006)

An inside analysis of a genetic-programming based optimizer. - Victor Muntés-Mulero; Josep Lluís Larriba-Pey; Josep Aguilar-Saborit; Calisto Zuzarte; Volker Markl (IDEAS, 2006)

Intensive Crossovers: Improving Convergence and Quality in a Genetic Query Optimizer. - Victor Muntés-Mulero; Josep Aguilar-Saborit; Calisto Zuzarte; Josep Lluís Larriba-Pey (JISBD, 2006)

Dynamic out of Core Join Processing in Symmetric Multiprocessors. - Josep Aguilar-Saborit; Victor Muntés-Mulero; Calisto Zuzarte; Adriana Zubiri; Josep Lluís Larriba-Pey (PDP, 2006)

Fast approximate computation of statistics on views. - Calisto Zuzarte; Xiaohui Yu 001 (SIGMOD Conference, 2006)

Window query processing for joining data streams with relations. - Kristine Towne; Qiang Zhu 001; Calisto Zuzarte; Wen-Chi Hou (CASCON, 2007)

A Dynamic View Materialization Scheme for Sequences of Query and Update Statements. - Wugang Xu; Dimitri Theodoratos; Calisto Zuzarte; Xiaoying Wu; Vincent Oria (DaWaK, 2007)

Collecting and Maintaining Just-in-Time Statistics. - Amr El-Helw; Ihab F. Ilyas; Wing Lau; Volker Markl; Calisto Zuzarte (ICDE, 2007)

Problem definition for effective workload management. - Adrian M. Teisanu; Sam Lightstone; Mariano P. Consens; Daniel C. Zilio; Mokhtar Kandil; Calisto Zuzarte (ICDE Workshops, 2007)

Star join revisited: Performance internals for cluster architectures. - Josep Aguilar-Saborit; Victor Muntés-Mulero; Calisto Zuzarte; Josep Lluís Larriba-Pey (Data Knowl. Eng., 2007)

Load balancing and data placement for multi-tiered database systems. - Wen-Syan Li; Daniel C. Zilio; Vishal S. Batra; Calisto Zuzarte; Inderpal Narang (Data Knowl. Eng., 2007)

Some rewrite optimizations of DB2 XQuery navigation. - Guangjun Xie; Qi Cheng; Jarek Gryz; Calisto Zuzarte (CIKM, 2008)

XML Index Recommendation with Tight Optimizer Coupling. - Iman Elghandour; Ashraf Aboulnaga; Daniel C. Zilio; Fei Chiang; Andrey Balmin; Kevin S. Beyer; Calisto Zuzarte (ICDE, 2008)

SQL Queries with CASE Expressions. - Jarek Gryz; Qiong Wang; Xiaoyan Qian; Calisto Zuzarte (ISMIS, 2008)

An xml index advisor for DB2. - Iman Elghandour; Ashraf Aboulnaga; Daniel C. Zilio; Fei Chiang; Andrey Balmin; Kevin S. Beyer; Calisto Zuzarte (SIGMOD Conference, 2008)

Generating targeted queries for database testing. - Chaitanya Mishra; Nick Koudas; Calisto Zuzarte (SIGMOD Conference, 2008)

Query Rewrites with Views for XML in DB2. - Parke Godfrey; Jarek Gryz; Andrzej Hoppe; Wenbin Ma; Calisto Zuzarte (ICDE, 2009)

Recommending XMLTable Views for XQuery Workloads. - Iman Elghandour; Ashraf Aboulnaga; Daniel C. Zilio; Calisto Zuzarte (XSym, 2009)

StatAdvisor: Recommending Statistical Views. - Amr El-Helw; Ihab F. Ilyas; Calisto Zuzarte (Proc. VLDB Endow., 2009)

Efficient processing of monotonic linear progressive queries via dynamic materialized views. - Chao Zhu 004; Qiang Zhu 001; Calisto Zuzarte (CASCON, 2010)

Online update of b-trees. - Marina Barsky; Alex Thomo; Zoltan Toth; Calisto Zuzarte (CIKM, 2010)

Hybrid In-Memory and On-Disk Tables for Speeding-Up Table Accesses. - Joan Guisado-Gámez; Antoni Wolski; Calisto Zuzarte; Josep Lluís Larriba-Pey; Victor Muntés-Mulero (DEXA (1), 2010)

Queries with CASE expressions. - Jarek Gryz; Qiong Wang; Xiaoyan Qian; Calisto Zuzarte (J. Intell. Inf. Syst., 2010)

Efficient evaluation of generalized tree-pattern queries on XML streams. - Xiaoying Wu; Dimitri Theodoratos; Calisto Zuzarte (VLDB J., 2010)

DB2 performance measurement and tuning hands on exercises. - Angela Yang; Calisto Zuzarte (CASCON, 2011)

A materialized-view based technique to optimize progressive queries via dependency analysis. - Chao Zhu 004; Qiang Zhu 001; Calisto Zuzarte; Wenbin Ma (CASCON, 2011)

Queries on dates: fast yet not blind. - Jaroslaw Szlichta; Parke Godfrey; Jarek Gryz; Wenbin Ma; Przemyslaw Pawluk; Calisto Zuzarte (EDBT, 2011)

DMVI: a dynamic materialized view index for efficiently discovering usable views for progressive queries. - Chao Zhu 004; Qiang Zhu 001; Calisto Zuzarte; Wenbin Ma (CASCON, 2012)

Alternative Query Optimization for Workload Management. - Zahid Abul-Basher; Yi Feng; Parke Godfrey; Xiaohui Yu 001; Mokhtar Kandil; Daniel C. Zilio; Calisto Zuzarte (DEXA (2), 2012)

Targeted genetic test SQL generation for the DB2 database. - Dominic Letarte; François Gauthier 001; Ettore Merlo; Nattavut Sutyanyong; Calisto Zuzarte (DBTest, 2012)

Axiomatic System for Order Dependencies. - Jaroslaw Szlichta; Parke Godfrey; Jarek Gryz; Calisto Zuzarte (AMW, 2013)

Developing a Dynamic Materialized View Index for Efficiently Discovering Usable Views for Progressive Queries. - Chao Zhu 004; Qiang Zhu 001; Calisto Zuzarte; Wenbin Ma (J. Inf. Process. Syst., 2013)

Expressiveness and Complexity of Order Dependencies. - Jaroslaw Szlichta; Parke Godfrey; Jarek Gryz; Calisto Zuzarte (Proc. VLDB Endow., 2013)

Recommending XML physical designs for XML databases. - Iman Elghandour; Ashraf Aboulnaga; Daniel C. Zilio; Calisto Zuzarte (VLDB J., 2013)

Accelerating analytic queries in OLTP environment using DB2 shadow tables. - Petrus Chan; Aruna De Silva; Calisto Zuzarte (CASCON, 2014)

Business-Intelligence Queries with Order Dependencies in DB2. - Jaroslaw Szlichta; Parke Godfrey; Jarek Gryz; Wenbin Ma; Weinan Qiu; Calisto Zuzarte (EDBT, 2014)

Optimization of Monotonic Linear Progressive Queries Based on Dynamic Materialized Views. - Chao Zhu 004; Qiang Zhu 001; Calisto Zuzarte (Comput. J., 2014)

Cardinality estimation using neural networks. - Henry Liu; Mingbin Xu; Ziting Yu; Vincent Corvinelli; Calisto Zuzarte (CASCON, 2015)

OptImatch: Semantic Web System with Knowledge Base for Query Performance Problem Determination. - Guilherme Damasio; Piotr Mierzejewski; Jaroslaw Szlichta; Calisto Zuzarte (CoRR, 2015)

Processing Analytical Workloads Incrementally. - Priyank Gupta; Nick Koudas; Europa Shang; Ryan Johnson 001; Calisto Zuzarte (CoRR, 2015)

Query Performance Problem Determination with Knowledge Base in Semantic Web System OptImatch. - Guilherme Damasio; Piotr Mierzejewski; Jaroslaw Szlichta; Calisto Zuzarte (EDBT, 2016)

OptImatch: Semantic web system for query problem determination. - Guilherme Damasio; Piotr Mierzejewski; Jaroslaw Szlichta; Calisto Zuzarte (ICDE, 2016)

Optimization of generic progressive queries based on dependency analysis and materialized views. - Chao Zhu 004; Qiang Zhu 001; Calisto Zuzarte; Wenbin Ma (Inf. Syst. Frontiers, 2016)

Quantifying duplication to improve data quality. - Yu Huang 019; Fei Chiang; Albert Maier; Martin Petitclerc; Yannick Saillet; Damir Spisic; Calisto Zuzarte (CASCON, 2017)

The New and Improved SQL: 2016 Standard. - Jan-Eike Michels; Keith W. Hare; Krishna G. Kulkarni; Calisto Zuzarte; Zhen Hua Liu; Beda Christoph Hammerschmidt; Fred Zemke (SIGMOD Rec., 2018)

GALO: Guided Automated Learning for re-Optimization. - Guilherme Damasio; Spencer Bryson; Vincent Corvinelli; Parke Godfrey; Piotr Mierzejewski; Jaroslaw Szlichta; Calisto Zuzarte (Proc. VLDB Endow., 2019)

Guided automated learning for query workload re-optimization. - Guilherme Damasio; Vincent Corvinelli; Parke Godfrey; Piotr Mierzejewski; Alexandar Mihaylov; Jaroslaw Szlichta; Calisto Zuzarte (Proc. VLDB Endow., 2019)

Pred-cache: a predictive caching method in database systems. - Omar El Zarif; Safwat Hassan; Ying Zou 001; Calisto Zuzarte; Vincent Corvinelli; Mohammed Alhamid (CASCON, 2020)

Emerging applications of machine learning in modern data management. - Amin Kamali; Calisto Zuzarte; Verena Kantere (CASCON, 2021)

Query predicate selectivity using machine learning in Db2®. - Waikeat Tan; Mohammed Alhamid; Mohamad Kalil; Ronghao Yang; Vincent Corvinelli; Calisto Zuzarte; Liam Finnie (CASCON, 2021)

Scalable Learning to Troubleshoot Query Performance Problems. - Alexandar Mihaylov; Vincent Corvinelli; Parke Godfrey; Piotr Mierzejewski; Jaroslaw Szlichta; Calisto Zuzarte (CIKM, 2021)

ML4DM: The second workshop on the emerging applications of machine learning in modern data management. - Amin Kamali; Jarek Szlichta; Calisto Zuzarte; Yueting Chen; Verena Kantere; Shaikh Quader (CASCON, 2022)

BLUTune: Query-informed Multi-stage IBM Db2 Tuning via ML. - Connor Henderson; Spencer Bryson; Vincent Corvinelli; Parke Godfrey; Piotr Mierzejewski; Jaroslaw Szlichta; Calisto Zuzarte (CIKM, 2022)

A Hybrid Cost Model for Evaluating Query Execution Plans. - Ning Wang; Amin Kamali; Verena Kantere; Calisto Zuzarte; Vincent Corvinelli; Brandon Frendo; Steve Donoghue (AIKE, 2023)

Compilation of SQL Queries for Efficient Distributed In-Memory Processing. - Sudip Chatterjee; Shubh Sharma; Nithin Ivan; Saumya Verma; Suprio Ray; Mark Stoodley; Calisto Zuzarte; Ian Finlay (CASCON, 2023)

ML4DM '23: The Third Workshop on the Emerging Applications of Machine Learning in Modern Data Management. - Amin Kamali; Calisto Zuzarte; Verena Kantere; Jaroslaw Szlichta; Yueting Chen; Xiaohui Yu 001; Ning Wang (CASCON, 2023)

BLUTune: Tuning Up IBM Db2 with ML. - Connor Henderson; Vincent Corvinelli; Parke Godfrey; Piotr Mierzejewski; Jaroslaw Szlichta; Calisto Zuzarte (ICDE, 2023)

A novel framework for join order selection based on reinforcement and representation learning. - Chang Liu; Amin Kamali; Verena Kantere; Calisto Zuzarte; Vincent Corvinelli (IEEE Big Data, 2024)

Robust Query Optimization in the Era of Machine Learning: State-of-the-Art and Future Directions. - Amin Kamali; Verena Kantere; Calisto Zuzarte (ICDE, 2024)

RobOpt: A Tool for Robust Workload Optimization Based on Uncertainty-Aware Machine Learning. - Amin Kamali; Verena Kantere; Calisto Zuzarte; Vincent Corvinelli (SIGMOD Conference Companion, 2024)

Roq: Robust Query Optimization Based on a Risk-aware Learned Cost Model. - Amin Kamali; Verena Kantere; Calisto Zuzarte; Vincent Corvinelli (CoRR, 2024)

A Novel Framework Using Deep Reinforcement Learning for Join Order Selection. - Chang Liu; Amin Kamali; Verena Kantere; Calisto Zuzarte; Vincent Corvinelli (CoRR, 2024)

Db2une: Tuning Under Pressure via Deep Learning. - Alexander Bianchi; Andrew Chai; Vincent Corvinelli; Parke Godfrey; Jarek Szlichta; Calisto Zuzarte (Proc. VLDB Endow., 2024)

Db2une: Tuning IBM Db2 with Deep Learning. - Alexander Bianchi; Rafael Dolores; Andrew Chai; Vincent Corvinelli; Parke Godfrey; Jarek Szlichta; Calisto Zuzarte (ICDE, 2025)

GEX: Guiding Expert Tuning with eXplainable AI. - Andrew Chai; Alexander Bianchi; Vincent Corvinelli; Parke Godfrey; Jarek Szlichta; Calisto Zuzarte (ICDE, 2025)

Robust Plan Evaluation based on Approximate Probabilistic Machine Learning. - Amin Kamali; Verena Kantere; Calisto Zuzarte; Vincent Corvinelli (Proc. VLDB Endow., 2025)

LearnedWMP: Workload Memory Prediction Using Distribution of Query Templates. - Shaikh Quader; Andres Jaramillo; Sumona Mukhopadhyay; Ghadeer Abuoda; Calisto Zuzarte; David Kalmuk; Marin Litoiu; Manos Papagelis (EDBT, 2026)