Database Architecture with Row and Column Stores
Operational reporting differs from informational reporting in that its scope is on day-to-day operations and thus requires data on the detail of individual transactions. It is often not desirable to maintain data on such detailed level in the data warehouse and the update frequency required for operational reports. Therefore, a Hybrid Row-Column database architecture is proposed. An OLTP database architecture that serves the conventional OLTP load out of a row-store database and serves operational reporting queries out of a column-store database which holds the subset of the data in the row store required for operational reports. The column-store is updated within the transaction of the row database; hence OLTP changes are directly reflected in operational reports.