2013 IEEE 29th International Conference on Data Engineering Workshops (ICDEW) (2012)
Arlington, VA, USA USA
Apr. 1, 2012 to Apr. 5, 2012
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ICDEW.2012.39
With rapidly increasing datasets and more dynamic workloads, adaptive partial indexing becomes an important way to keep indexing efficiently. During times of changing workloads, the query performance suffers from inefficient tables scans while the index tuning mechanism adapts the partial index. In this paper we present the Adaptive Index Buffer. The Adaptive Index Buffer reduces the cost of table scans by quickly indexing tuples in memory until the partial index has adapted to the workload again. We explain the basic operating mode of an Index Buffer and discuss how it adapts to changing workload situations. Further, we present three experiments that show the Index Buffer at work.
Hannes Voigt, Tobias Jaekel, Thomas Kissinger, Wolfgang Lehner, "Adaptive Index Buffer", 2013 IEEE 29th International Conference on Data Engineering Workshops (ICDEW), vol. 00, no. , pp. 308-314, 2012, doi:10.1109/ICDEW.2012.39