Showing cs.DBShow all
2 papers · 1 filter
cs.DB2000
Materialized View Selection and Maintenance Using Multi-Query Optimization
Hoshi Mistry, Prasan Roy, Krithi Ramamritham +1
Because the presence of views enhances query performance, materialized views are increasingly being supported by commercial database/data warehouse systems. Whenever the data wareh…
cs.DB2000
Don't Trash your Intermediate Results, Cache 'em
Prasan Roy, Krithi Ramamritham, S. Seshadri +2
In data warehouse and data mart systems, queries often take a long time to execute due to their complex nature. Query response times can be greatly improved by caching final/interm…