1. A computer-implemented method of transactional caching, comprising: configuring a transactional cache associated with a database, wherein the database comprises a column-based database with a column architecture; receiving a write operation with a partial key; mapping the partial key to one or more primary keys, wherein a primary key uniquely identifies one row in the transactional cache, wherein the partial key is non-unique and identified by a subset of a string representing the primary key; applying a write-through-DB policy for order-sensitive query operations, wherein the write-through-DB policy executes the order-sensitive query operations directly on the database; delaying execution of the write operation other than the order-sensitive query operations on the database until a flush is determined to be necessary, wherein the write operation is delayed by performing the write operation on the identified one row in the transactional cache; and invoking the flush by performing a bulk operation that updates the database based on the transactional cache.