Virtual columns to expose row specific details for query execution in column store databases

A method comprising:

• accessing, by at least one processor, a database table in a column store database system, the database table comprising at least one virtual column, the column store database system storing data in a column-oriented structure;
• calculating, by the at least one processor, a value for the at least one virtual column based on at least one existing column of the database table, the calculated value mapped to a row identifier associated with a row of the database table, wherein calculating the value comprises:
• retrieving data values from a plurality of columns of the database table, the data values located in a same row of the database table, and
• mapping the row identifier of the same row to the data values from the plurality of columns;
• and
• providing, by the at least one processor and in response to a query, the calculated value to a user interface, the query associated with the row identifier.

A non-transitory computer readable medium storing instructions which, when executed by at least one processor, cause operations comprising:

• accessing a database table in a column store database system, the database table comprising at least one virtual column, the column store database system storing data in a column-oriented structure;
• calculating a value for the at least one virtual column based on at least one existing column of the database table, the calculated value mapped to a row identifier associated with a row of the database table, wherein calculating the value comprises:
• retrieving data values from a plurality of columns of the database table, the data values located in a same row of the database table, and
• mapping the row identifier of the same row to the data values from the plurality of columns;
• and
• providing, in response to a query, the calculated value to a user interface, the query associated with the row identifier.