Speaker: Dr. Anisoara Nica
SQL Anywhere Research & Development
University of Waterloo
Title: Query Optimization in Relational Database Management Systems: Theory and Practice
Query optimization in relational database systems (RDBMS) has been a constant topic of database research for more than thirty years. However, many aspects of the design of modern query optimizers still present open research problems, especially with regard to self-adapting, performance, and robustness of the query optimization process. This talk will provide an overview of the state-of-the-art in query optimization, with emphasis on how industrial query optimizers are built. As a case study, I will discuss the architecture of the SQL Anywhere Optimizer, including semantic transformations, the search space generation process, and the support of materialized views in SQL Anywhere, the Sybase's self-managing RDBMS. The talk will conclude by outlining some open research problems related to challenges that are brought by new types of environments where database systems are used.
Dr. Nica holds a Ph.D. in Computer Science and Engineering from the University of Michigan, Ann Arbor, USA, 1999, with the dissertation in the areas of information integration systems and data warehousing. She is currently Distinguished Engineer in the SQL Anywhere Research and Development team of Sybase, An SAP Company, in Waterloo, Canada. Her research interests and expertise are focused on database management systems, in particular query processing and query optimization, data warehousing, distributed, mobile, and parallel databases. Her work experience includes Lawrence Berkeley National Laboratory and International Computer Science Institute in Berkeley. Dr. Nica holds seven patents and has several other patents pending. She has published more than 20 research articles in journals, book chapters, conferences and workshops.