DEFERRING DATA RECORD CHANGES USING QUERY REWRITING

摘要

Staging data record changes from a faster storage medium to a slower storage medium using data query rewriting is provided. In response to receiving a data query corresponding to a particular data record, it is determined whether the data query is one of a transactional data query or an analytical data query. In response to determining that the data query is a transactional data query, the transactional data query is rewritten to apply transactional delta changes to the particular data record on a storage-class memory of a computer. In response to determining that the data query is an analytical data query, the analytical data query is rewritten to select and reconcile each data record corresponding to the particular data record stored on the storage-class memory with the particular data record stored on a persistent data storage device of the computer.

主权项

1. A computer system for staging data record changes from a faster storage medium to a slower storage medium using data query rewriting, the computer system comprising:
a bus system; a storage device connected to the bus system, wherein the storage device stores computer readable program code; and a processor unit connected to the bus system, wherein the processor unit executes the computer readable program code to determine whether a data query corresponding to a particular data record is one of a transactional data query or an analytical data query in response to receiving the data query; rewrite the transactional data query to apply transactional delta changes to the particular data record on a storage-class memory of the computer system in response to determining that the data query is a transactional data query; and rewrite the analytical data query to select and reconcile each data record corresponding to the particular data record stored on the storage-class memory with the particular data record stored on a persistent data storage device of the computer system in response to determining that the data query is an analytical data query.