Transactional storage system for healthcare information
View Patent ↗Managing healthcare information data includes, on a computer, representing a state of a system based on the healthcare information, receiving a transaction representing a change to the system, changing the representation of the state of the system according to the transaction, and storing the transaction.
1. A computer-implemented method of managing healthcare data relating to a clinical trial, the method comprising:
storing, in a first storage component, a data model having elements and associated values;
receiving, by a controller module, a transaction;
generating a revised data model by implementing the received transaction and storing the revised data model in the first storage component; storing the transaction and information regarding an order in which the transaction was implemented to each of a plurality of sequences of transactions in at least one second storage component;
determining whether the transaction and the information regarding the order is successfully stored to each of the plurality of sequences of transactions;
when the transaction and the information regarding the order is not successfully stored to one of the plurality of sequences of transactions, identifying the one of the plurality of sequences of transactions as invalid;
identifying from at least one of the plurality of sequences of transactions not identified as invalid a set of transactions implemented between an empty state of the data model containing no elements and prior to implementing the received transaction; and
applying the identified set of transactions to an empty data model containing no elements to reconstruct the data model prior to implementing the received transaction.
2. A system for managing healthcare data relating to a clinical trial, the system comprising:
a computer including non-volatile memory storing a controller module;
the controller module configured to:
store a data model having a plurality of elements and associated values in a first storage component;
receive a transaction from the controller module;
generate a revised data model by implementing the received the transaction; store the revised data model in the first storage component;
store the transaction and information regarding an order of the transaction to a first sequence of transactions in a second storage component and store the transaction and the information regarding the order to a second sequence of transactions in a third storage component;
receive from a user a selection of at least one of the plurality of elements and a requested historical point in time;
identify from the at least one sequence of transactions a set of transactions associated with only the selected at least one element and implemented between an empty state of the data model containing no elements and the requested historical point in time;
apply the identified set of transactions to an empty data model containing no elements to construct a reduced data model including only data relevant to the selected at least one element; and
provide the reduced data model to the user.
3. The system of claim 2 , wherein the transaction is stored in parallel with generating the revised data model.
4. The system of claim 2 , wherein the controller module is further configured to:
determine whether the transaction and the information regarding the order is successfully stored to the first sequence of transactions and the second sequence of transactions; and
when the transaction and the information regarding the order is not successfully stored to one of the first sequence of transactions and the second sequence of transactions, identify the one of the first sequence of transactions and the second sequence of transactions as invalid.