Smart Query Acceleration Using Summaries

Consider a business scenario in which a user wants to determine the sales per month at a product level, and the filter conditions vary for different cases and across different users (So it would require multiple ad hoc queries). If the sales and product data are located in different data sources and the sales data is comprised of millions of rows, then every time the required data is fetched by querying sales data, since it would require a join with the appropriate table, joining product data, and then aggregating the data, it would result in a huge amount of data being transferred over the network and a much slower query, which would consume a lot of resources and impact overall performance.

To avoid these kinds of scenarios and improve query performance by reducing the amount of data transferred over the network and avoided the repeated querying of big tables, Denodo Platform 8 offers a new feature called Summary view.

Read more in https://www.datavirtualizationblog.com. Originally published on November 4, 2021