From Cooperative Scans to Predictive Buffer Management
In analytical applications, database systems often need to sustain workloads with multiple concurrent scans hitting the same table. The Cooperative Scans (CScans) framework, which introduces an Active Buffer Manager (ABM) component into the database architecture, has been the most effective and elaborates response to this problem, and was initially developed in the X100 research prototype. The authors now report on the experiences of integrating Cooperative Scans into its industrial-strength successor, the Vectorwise database product. During this implementation they invented a simpler optimization of concurrent scan buffer management, called Predictive Buffer Management (PBM).