CPC G06F 16/211 (2019.01) [G06F 16/21 (2019.01); G06F 16/278 (2019.01)] | 18 Claims |
1. A method, said method comprising steps of:
a database server receiving a data definition language (DDL) statement that declares a table in a database and table columns of said table;
wherein said database includes a database dictionary that defines database objects of said database;
wherein said DDL statement declares:
one or more column-major columns of said table columns, and
row-major columns of said table columns;
in response to receiving said DDL statement, creating said table by at least generating metadata in said database dictionary that defines:
said table,
said one or more column-major columns of said table, and
said row-major columns of said table;
storing rows in said table, wherein storing rows in said table comprises storing said one or more column-major columns of said rows in column-major format and storing said row-major columns of said rows in row-major format;
receiving a data manipulation language (DML) statement requesting to update a column value of a column-major column of said one or more column-major columns; and
in response to receiving said DML statement, updating in said database said column-major column in-place to a new value.
|