Database lock
Inventors
Lee, Angela • Samala, Padma • DaCosta, Shameka • Agarwal, Indra • Dong, Fugui • Gottipati, Srikanth
Assignees
Interested in licensing this patent?
MTEC can help explore whether this patent might be available for licensing for your application.
Publication Number
US-11940974-B2
Publication Date
2024-03-26
Expiration Date
Abstract
Methods, systems, and apparatus, including computer programs encoded on a storage device, for monitoring the status of a database prior to locking the database. In one aspect, the method comprises receiving a request to generate a mock database, accessing a set of database lock readiness metrics, wherein the set of database lock readiness metrics include one or more attribute values that each specify a value of an attribute of database data that must be satisfied for the database to be locked, correlating information that includes (i) the set of database lock readiness metrics and (ii) database data of the database, and generating a database lock readiness report structure, based on a mock database lock representing a snapshot of the database at a particular point in time, that indicates whether each of the one or more attribute values specified by the set of database lock readiness metrics have been satisfied.
Core Innovation
The invention concerns monitoring the status of a database prior to locking the database by generating a mock database lock before the database is locked. A request is received to generate the mock database lock for the database at a point in time before the database is locked, and responsive to the request, a snapshot of the database is generated at a particular point in time, representing a proposed lock state without performing the actual locking.
The mock database lock is generated using a data structure stored in a first data source that structures data describing a set of database lock readiness metrics. The set of database lock readiness metrics includes one or more attribute values that specify a value of an attribute of database data that must be satisfied for the database to be locked, and the method correlates the stored readiness metric data with database data stored by a second data source, including respective values corresponding to the set of database lock readiness metrics.
The snapshot includes a data structure that stores the set of database lock readiness metrics, the respective values corresponding to the database lock readiness metrics at the particular point in time, and indications of readiness status. The snapshot stores at least a first indication that a first respective attribute value has been satisfied and is ready for locking, and at least a second indication that a second respective attribute value has not been satisfied and is not ready for locking.
The documented embodiments further relate the database data to a clinical trial database by using database attributes describing features of a clinical trial database. In an implementation, the invention includes a mobile/workflow architecture that manages readiness metrics, triggers generation of mock database lock snapshots, and produces a readiness report, including alerts/notifications and instructions when the database is not ready.
Claims Coverage
The independent claims cover three claim categories—method, system, and computer-readable storage device—each centered on generating a mock database lock snapshot at a specified point in time before locking. The inventive core uses database lock readiness metrics defined by attribute values, correlates those metrics with database data, and generates a snapshot that includes indications of satisfied versus not satisfied readiness attribute values.
Request to generate a mock database lock prior to locking
A method, system, and computer-readable storage device receive a request to generate a mock database lock for the database at a point in time before the database is locked, and generate the mock database lock in response to the request.
Database lock readiness metrics defined by attribute values
The invention accesses a data structure stored in a first data source with fields structuring data describing a set of database lock readiness metrics, where the set includes one or more attribute values specifying a value of an attribute of database data that must be satisfied for the database to be locked.
Correlating readiness metrics with database data
The invention correlates information including the data structured by the fields describing the set of database lock readiness metrics and the database data stored by a second data source, where the database data includes respective values corresponding to the set of database lock readiness metrics.
Snapshot-based mock database lock with satisfied and not satisfied indications
The invention generates, based on the correlated information, a mock database lock representing a snapshot of the database at a particular point in time, where the snapshot data structure stores the set of database lock readiness metrics, the respective values at the particular point in time, and at least a first indication that a first respective attribute value has been satisfied and is ready for locking plus at least a second indication that a second respective attribute value has not been satisfied and is not ready for locking.
Clinical trial database attributes
The invention includes database data where the database data includes database attributes describing features of a clinical trial database.
Overall, the independent claims provide coverage for producing a mock database lock snapshot prior to database lock by structuring database lock readiness metrics from attribute values, correlating those metrics with database data, and generating a snapshot that explicitly indicates which readiness metric attribute values are satisfied versus not satisfied for locking, with additional narrowing to clinical trial database attributes.
Stated Advantages
Reduced time to completion of tasks.
Reduced risk.
Improved transparency.
Documented Applications
A clinical-trial-focused monitoring workflow that generates readiness reports from mock database lock snapshots prior to database lock.
A mobile/workflow application architecture that triggers mock lock creation, manages readiness metric management, and produces alerts/notifications, including instructions when not ready, in a readiness monitoring process for a database prior to locking.
Interested in licensing this patent?