PROCESSING OF COLUMNAR DATA
A system includes reception of a calculation, identification of operands of the calculation, and a source column of a table including values associated with the operands and used in the calculation, creation, for each operand, creation of a column including the value associated with that operand in a row of the column associated with that operand, column-wise aggregation of the values of the created columns into a single row, execution of the calculation using the values of the single row and create a result column including a result of the calculation, and addition of the result column as a row of the table.
1 . A system comprising:
a data storage device storing a table comprising rows;
a computing device comprising:
a memory storing processor-executable program code; and
a processor to execute the processor-executable program code in order to cause the computing device to:
receive a calculation;
identify operands of the calculation, and a source column of a table including values associated with the operands and used in the calculation;
for each operand, create a column including the value associated with that operand in a row of the column associated with that operand;
column-wise aggregate the values of the created columns into a single row;
execute the calculation using the values of the single row and create a result column including a result of the calculation; and
add the result column as a row of the table.
2 . A system according to claim 1 , wherein receipt of the calculation comprises receipt of a MultiDimensional eXpressions query.
3 . A system according to claim 1 , wherein the creation of the columns, aggregation of the values, and execution of the calculation comprise generation of an execution plan.
4 . A system according to claim 3 , the processor to further execute the processor-executable program code in order to cause the computing device to transmit the execution plan to a relational database system.
5 . A system according to claim 4 , the processor to further execute the processor-executable program code in order to cause the computing device to receive the result of the calculation from the relational database system.
6 . A system according to claim 1 , wherein the identified operands are located in different respective rows of the table.
7 . A non-transitory computer-readable medium storing program code, the program code executable by a processor of a computing system to cause the computing system to:
receive a calculation;
identify operands of the calculation, and a source column of a table including values associated with the operands and used in the calculation;
for each operand, create a column including the value associated with that operand in a row of the column associated with that operand;
column-wise aggregate the values of the created columns into a single row;
execute the calculation using the values of the single row and create a result column including a result of the calculation; and
add the result column as a row of the table.
8 . A medium according to claim 7 , wherein receipt of the calculation comprises receipt of a MultiDimensional eXpressions query.
9 . A medium according to claim 7 , wherein the creation of the columns, aggregation of the values, and execution of the calculation comprise generation of an execution plan.
10 . A medium according to claim 9 , the program code further executable by the processor of the computing system to cause the computing system to transmit the execution plan to a relational database system.
11 . A medium according to claim 10 , the program code further executable by the processor of the computing system to cause the computing system to receive the result of the calculation from the relational database system.
12 . A medium according to claim 7 , wherein the identified operands are located in different respective rows of the table.
13 . A computer-implemented method comprising:
receiving a calculation;
identifying operands of the calculation, and a source column of a table including values associated with the operands and used in the calculation;
for each operand, creating a column including the value associated with that operand in a row of the column associated with that operand;
column-wise aggregating the values of the created columns into a single row;
executing the calculation using the values of the single row and create a result column including a result of the calculation; and
adding the result column as a row of the table.
14 . A method according to claim 13 , wherein receipt of the calculation comprises receipt of a MultiDimensional eXpressions query.
15 . A method according to claim 13 , wherein the creation of the columns, aggregation of the values, and execution of the calculation comprise generation of an execution plan.
16 . A method according to claim 15 , further comprising:
transmitting the execution plan to a relational database system.
17 . A method according to claim 16 , further comprising:
receiving the result of the calculation from the relational database system.
18 . A method according to claim 13 , wherein the identified operands are located in different respective rows of the table.