Systems and methods for quarantine preservation of data integrity in data management systems
A computer-implemented method for quarantine preservation of outcome assessment data integrity in data management systems. The data management system receives an outcome assessment successfully completing a first set of client-side validations, wherein the first set of client-side validations include a series of validations checking for required fields and format checks. A second set of server-side validations is executed including a series of validations checking for uniqueness constraints, complex business rules, cross-referencing with other database records, and consistency. When one server-side validation in the second set of server-side validations fails, the outcome assessment successfully completing the first set of client side validations in a quarantine repository is stored and updated to quarantined state. The outcome assessment is modified to correct the failed server-side validation and subsequently validated a second time.
1 . A computer-implemented method for quarantine preservation of outcome assessment data integrity in data management systems, the computer-implemented method comprising:
receiving, by the data management system, an outcome assessment collecting data on patient reported outcomes that successfully complete a first set of client-side validations, wherein the first set of client-side validations include a series of validations checking for required fields and format checks;
executing, by the data management system, a second set of server-side validations including a series of validations checking for uniqueness constraints, complex business rules, cross-referencing with other database records, and consistency;
when one server-side validation in the second set of server-side validations fails, storing the outcome assessment successfully completing the first set of client side validations in a quarantine repository;
updating the outcome assessment status to quarantined state;
modifying, by the data management system, the outcome assessment to correct the failed server-side validation;
subsequently executing, by the data management system, the second set of server-side validations a second time; and
when the second set of server-side validations completes with no errors, updating the outcome assessment status and storing the modified outcome assessment.
2 . The computer-implemented method of claim 1 above, wherein the patient reported outcomes include symptoms, quality of life, or treatment experiences via questionnaires, pain scales, or mood assessments.
3 . The computer-implemented method of claim 1 above, wherein the outcome assessment collects data on clinician reported outcomes.
4 . The computer-implemented method of claim 3 , above, wherein the clinician reported outcomes include observations or assessments using standardized scales.
5 . The computer-implemented method of claim 1 above, wherein the outcome assessment collects data on observer reported outcomes, wherein the observer includes caregivers or family members of a patient.
6 . The computer-implemented method of claim 5 , above, wherein the observer reported outcome includes data on the patient's condition when the patient cannot report themselves because of impairment.
7 . The computer-implemented method of claim 1 above, wherein the outcome assessment collects data on performance outcomes in clinical trials.
8 . The computer implemented method of claim 7 , above, wherein the performance outcomes in the clinical trials include patient abilities, physical tasks, and cognitive tasks measured using electronic tools.
9 . The computer-implemented method of claim 1 above, further comprising:
receiving, by the data management system, a second outcome assessment successfully completing the first set of client-side validations, wherein the first set of client-side validations include a series of validations checking for required fields and format checks;
executing, by the data management system, the second set of server-side validations including a series of validations checking for uniqueness constraints, complex business rules, cross-referencing with other database records, and consistency;
when one server-side validation in the second set of server-side validations fails, storing the second outcome assessment successfully completing the first set of client side validations in a quarantine repository;
updating the second outcome assessment status to quarantined state;
modifying, by the data management system, the second outcome assessment to correct the failed server-side validation;
subsequently executing, by the data management system, the second set of server-side validations for the second outcome assessment a second time; and
when the second set of server-side validations completes with no errors, updating the second outcome assessment status and storing the modified outcome assessment.
10 . A data management system for quarantine preservation of outcome assessment data integrity, the data management system comprising:
a quarantine repository for storing one or more outcome assessments;
a production repository for storing one or more outcome assessments;
a network interface configured to facilitate data communication via a network; and
a processing circuit comprising a processor and a memory, the processing circuit configured to:
receiving an outcome assessment collecting data on patient reported outcomes that successfully completes a first set of client-side validations, wherein the first set of client-side validations include a series of validations checking for required fields and format checks;
executing a second set of server-side validations including a series of validations checking for uniqueness constraints, complex business rules, cross-referencing with other database records, and consistency;
when one server-side validation in the second set of server-side validations fails, storing the outcome assessment successfully completing the first set of client side validations in the quarantine repository;
updating the outcome assessment status to quarantined state;
modifying the outcome assessment to correct the failed server-side validation;
subsequently executing the second set of server-side validations a second time; and
when the second set of server-side validations completes with no errors, updating the outcome assessment status and storing the modified outcome assessment.
11 . A non-transitory computer-readable medium including instructions that, when executed by one or more processors, cause the one or more processors to perform the steps of:
receiving an outcome assessment collecting data on patient reported outcomes that successfully completes first set of client-side validations, wherein the first set of client-side validations include a series of validations checking for required fields and format checks;
executing a second set of server-side validations including a series of validations checking for uniqueness constraints, complex business rules, cross-referencing with other database records, and consistency;
when one server-side validation in the second set of server-side validations fails, storing the outcome assessment successfully completing the first set of client side validations in a quarantine repository;
updating the outcome assessment status to quarantined state;
modifying the outcome assessment to correct the failed server-side validation;
subsequently executing the second set of server-side validations a second time; and
when the second set of server-side validations completes with no errors, updating the outcome assessment status and storing the modified outcome assessment.