Hardware implementation of the filter/project operations

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

DOI:

关键词:

摘要: Techniques are described for performing filter and project operations. In an embodiment, a set of predicates that specify criteria filtering results to query is received. Based on particular predicate the predicates, result at least one portion column generated. The identifies rows within first satisfy predicate. Rows selected returned as based in part result. bitvector where each bit corresponds row identify whether satisfies

参考文章(47)
II Robert David Hopkins, Justin Schauer, Philip Amberg, Hardware implementation of the aggregation/group by operation: filter method ,(2013)
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)