Answering Queries Using Views, Second Edition

Foto N. Afrati is a professor in the Electrical and Computing Engineering Department of the NTUA, Greece. She received a B.S. degree from the Mechanical and Electrical Engineering Department of National Technical University of Athens (NTUA) and a Ph.D. from Imperial College of the University of London. She is a Fellow of ACM. She has received the ACM Recognition for Service Award in 2005 and the best-paper award in ICDT 2009. She has been the program-committee chair for the Conference on Principles of Databases (PODS) 2005, and for the International Conference on Database Theory (ICDT) 1997, for which she was the organizing committee chair as well. She currently serves as associate editor of the IEEE TKDE journal. In 2012-2013, she spent her sabbatical leave visiting Google at Mountain View. She has published over 100 papers in the areas of databases, algorithms, and distributed computing. Her research interests are in the area of database theory, recent research interests are mainly in the area of big data, including query optimization for MapReduce and other distributed platforms.Rada Y. Chirkova is an associate professor of Computer Science at North Carolina State University. She has received a B.Sc. and a M.Sc., both in Applied Mathematics, from Moscow State University (Moscow, Russia), and an M.Sc. and a Ph.D., both in Computer Science, from Stanford University. She is a senior member of the Association for Computing Machinery, and served in 2017 as General Co-Chair of the ACM International Conference on Management of Data (SIGMOD). She is associate editor of the SIGMOD Record journal and of The Computer Journal (Oxford). She has co-authored 3 books (including this book), and has over 60 peer-reviewed publications on topics ranging from query containment and equivalence, query processing, view-based reformulation of data and queries, information security and leakage, to applications of policies to agent behaviors. She has received the National Science Foundation (NSF) CAREER Award, as well as numerous IBM Faculty and University Partnership Program Awards. Her research interests span information and knowledge management, algorithms and theory of computation, and data sciences and analytics, with applications including data wrangling, cyber security, and healthcare information technology.

Preface to the First Edition.- Preface to the Second Edition.- Acknowledgments.- Queries and Views.- Query Containment and Equivalence.- Finding Equivalent Rewritings.- Maximally Contained Rewritings (MCRs).- Answering Queries in Presence of Dependencies.- Answering Queries in Data Exchange.- Answering Queries Using Views.- XPath Queries and Views.- Tree-Structured Records Queried with SQL Dialect.- Bibliographical Notes for Chapters 1--7.- Conclusion for Chapters 1--7.- Bibliography.- Authors' Biographies.