3 papers
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…
cs.DB1999
Efficient and Extensible Algorithms for Multi Query Optimization
Prasan Roy, S. Seshadri, S. Sudarshan +1
Complex queries are becoming commonplace, with the growing use of decision support systems. These complex queries often have a lot of common sub-expressions, either within a single…