Hardware implementation of the aggregation/group by operation: filter method

作者: II Robert David Hopkins , Justin Schauer , Philip Amberg

DOI:

关键词:

摘要: Techniques are described for performing grouping and aggregation operations. In an embodiment, a request is received to aggregate data grouped by first column. response receiving the request, values loaded from column into input cache. The include values, column, set of rows. A filter unit programmed with logic perform comparison between particular value, row, in plurality rows, Based on comparison, predicate result generated that identifies within have valued matches value. An value second aggregating each rows identified result.

参考文章(48)
II Robert David Hopkins, Justin Schauer, Jon Lexau, Philip Amberg, Hardware implementation of the filter/project operations ,(2012)
Calisto Paul Zuzarte, Dieu Quang La, John F. Hornibrook, Gust Branish Ii Edward, Aggregate query optimization ,(2007)
Jeffrey W. Tenner, Robert J. Bestgen, Thomas J. Eggebraaten, Encoded matrix index ,(2008)
Atul Chadha, Ashish Gupta, Venkatesh Harinarayan, Piyush Goel, Balakrishna Raghavendra Iyer, Encoded-vector indices for decision support and warehousing ,(1996)
Roger MacNicol, Vikram Kapoor, Jesse Kamp, Kam Shergill, Vineet Marwah, Amit Ganesh, Sachin Kulkami, Query and exadata support for hybrid columnar compressed data ,(2010)
Patrick M. Malone, Randy M. Nakagawa, Thomas A. Beavin, Jerry Mukai, Optimization of SQL queries using filtering predicates ,(2000)
Cedric Florimond, Georgios Giannikis, Dietmar Fauser, Gustavo Alonso, Jeremy Meyer, Donald Kossmann, Philipp Unterbrunner, Continuous full scan data store table and distributed data store featuring predictable answer time for unpredictable workload ,(2010)