Using databases for both transactions and analysis
AssigneeMiosoft Corporation
InventorsMark D. A. van Gulik, Todd Lyle Smith, Jordan Paul Barrette, Albert B. Barabas, Ernst M. Siepmann
Life of this patent
Estimating the term…
Abstract
Among other things, requests are received for tasks to be performed in a database. The tasks include tasks that will cause changes in data of the database and other tasks that must be executed on data in the database that is consistent time-wise. At least some of the data that will be changed by the change-causing tasks comprises data that must remain time-wise consistent for the other tasks. The other tasks are executed in the database while the change-causing tasks are also being executed in the database, without requiring a replication or reconfiguration of the database.
Claims12
A computer-implemented method comprising
- executing analytical tasks on data of a database that is expressed according to a schema that is natively suited to online transaction processing,
- the analytical tasks being executed without requiring any transformation of the schema according to which the data is expressed.
A computer-implemented method comprising
- executing an analytical task using data of a database,
- the data to be used by the analytical task being subject to changes made by transactional tasks to be performed after the beginning of the executing of the analytical task and before the completion of the executing of the analytical task, and
- guaranteeing time-wise consistency of the data used by the analytical task in executing the database notwithstanding the changes made by the transactional tasks.
A computer-implemented method comprising
- if at least part of a relatively shorter latency operation is in contention with at least part of a relatively longer latency operation for access to data stored persistently at a node of a distributed database, temporarily suspending the longer latency operation while at least the part of the shorter latency operation proceeds, the longer latency operation requiring access to the data in its state as of a particular moment in time,
- if data in its state as of the particular moment in time is to be changed by the shorter latency operation while the longer latency operation is suspended, then storing the changed data as a new version persistently at the node, without making the unchanged data inaccessible to the longer latency operation, and
- permitting the longer latency operation to resume and to access the unchanged data in its state as of the particular moment in time.
Dependencies are inferred from the claim text.