PROCESSING DUPLICATE INSTANCES OF A SAME COLUMN EXPRESSION BY MEMORY REFERENCE WHEN EXECUTING A QUERY VIA A DATABASE SYSTEM

Abstract: a database system is operable to determine a query expression for execution indicating processing of a set of columns. multiple ones of the set of columns are defined via duplicate instances of a same column expression. a query corresponding to the query expression is executed based on processing a set of column streams corresponding to the set of columns. based on the multiple ones of the set of columns being defined via the duplicate instances of the same column expression, the set of column streams includes: a first column stream corresponding to a first one of the set of columns that includes a plurality of column values; and at least one additional column stream corresponding to other ones of the set of columns that includes at least one memory reference indicating at least one memory location of the first column stream.

Inventor(s): Andrew Park, Jason Arnold

CPC Classification: G06F16/24532 ({of parallel queries})

Search for rejections for patent application number 20250181577