Faster database queries could revolutionize data-driven decision making for businesses.
Materialized views of databases can help speed up query processing by storing pre-computed data. This study introduces a new method to make better use of these views, especially for queries with group-by and aggregation functions. By expanding the types of relationships between views and queries, more views can be considered, even if they don't directly match the query. The study outlines conditions and algorithms to determine when a view can be used to improve query performance, making materialized views more practical and effective in query processing.