Combined Row and Columnar Storage for In-Memory Databases for OLTP and Analytics Workloads

A method, said method comprising steps of:

• storing rows in a table in a database, wherein storing rows in said table comprises storing one or more column-major columns of said rows in column-major format and storing one or more row-major columns of said rows in row-major format;
• wherein storing rows in said table further comprises:
• storing said one or more row-major columns in a row partition comprising row pages;
• storing said one or more column-major columns in one or more column partitions, each column partition of said one or more column partitions comprising column pages;
• executing a database transaction, wherein executing said database transaction comprises updating in said database said column-major column in-place to a new value;
• committing said database transaction;
• and
• wherein said updating comprises storing said new value in a column page of said one or more column partitions before committing said database transaction.