Testing SQL Server’s Query Optimizer: Challenges, Techniques and Experiences (2009)
Leo Giakoumakis, Cesar Galindo-legaria
Query optimization is an inherently complex problem, and validating the correctness and effectiveness of a query optimizer can be a task of comparable complexity. The overall process of measuring...
Database Change Notifications: Primitives for Efficient Database Query Result Caching (2008)
Cesar Galindo-legaria, Torsten Grabs, Christian Kleinerman, Florian Waas
Many database applications implement caching of data from a back-end database server to avoid repeated round trips to the back-end and to improve response times for end-user requests. For example,...
Extending Locking Techniques to Improve Concurrent Database Access (2007)
Cesar Galindo-Legaria, Gianni Mainetto, Fausto Rabitti
Although the general concepts provided by the standard concurrency control theory (e. g. [BHG87]) remain a solid guide for systems behavior and design, a look at implementation-driven research (e. g....
Counting, enumerating, and sampling of execution plans in a cost-based query optimizer (2000)
F. Waas, Florian Waas, Cesar Galindo-legaria
Centrum voor Wiskunde en Informatica Counting, enumerating and sampling of execution plans in a cost-based query optimizer
Extending Locking Techniques to Improve Concurrent Database Access (1995)
Cesar Galindo-Legaria, Fausto Rabitti
Although the general concepts provided by the standard concurrency control theory (e. g. [BHG87]) remain a solid guide for systems behavior and design, a look at implementation-driven research (e. g....