2009 · 76 citations · 22 references
ComputingComputer EngineeringComputer ScienceData ManagementDatabasesStorage SystemsCachingDatabase ManagementQuery OptimizationQuery ProcessingRelational AlgebraStream ProcessingCache-aware Query OptimizationData Pipeline ProcessingMaterialized ViewsQuery Performance OptimizationQuery Turnaround TimeScalable Database DesignScalable Database Systems
Automatically recycling (intermediate) results is a grand challenge for state-of-the-art databases to improve both query response time and throughput. Tuples are loaded and streamed through a tuple-at-a-time processing pipeline avoiding materialization of intermediates as much as possible. This limits the opportunities for reuse of overlapping computations to DBA-defined materialized views and function/result cache tuning.
22
Super-Scalar RAM-CPU Cache Compression
Marcin Żukowski, Sándor Héman, Niels Nes et al. · 2006 · 478 citations
Efficient and extensible algorithms for multi query optimization
Prasan Roy, S. Seshadri, S. Sudarshan et al. · ACM SIGMOD Record · 2000 · 409 citations
Optimizing queries using materialized views
Jonathan Goldstein, Per-Åke Larson · 2001 · 257 citations