US 12,066,919 B2
Systems and methods for validating data
Miguel Lara, Zapopan (MX); David Alberto Lopez Apodaca, Zapopan (MX); Jorge Ernesto Diaz Verdin, Guadalajara (MX); and Anil Verma, San Ramon, CA (US)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Sep. 13, 2021, as Appl. No. 17/473,625.
Prior Publication US 2023/0083221 A1, Mar. 16, 2023
Int. Cl. G06F 9/44 (2018.01); G06F 8/70 (2018.01); G06F 11/36 (2006.01)
CPC G06F 11/3612 (2013.01) [G06F 8/70 (2013.01); G06F 11/3692 (2013.01)] 20 Claims
OG exemplary drawing
 
1. One or more non-transitory computer-readable media storing instructions, which when executed by one or more hardware processors, cause:
receiving registration data for a plurality of queries to run a validation test within a database during at least one data entry period, wherein the registration data associates a subsystem of a plurality of subsystems subject to the validation test that have access to the database with at least a first query of the plurality of queries, wherein the first query accesses a set of data in the database to monitor during the data entry period, wherein the data entry period corresponds to a window of time when a plurality of users that share the database are permitted to modify data within the database, wherein the registration data indicates whether each query of the plurality of queries is an informational query or a comparison query;
determining a schedule for executing the plurality of queries within the data entry period based on a start time when the plurality of users that share the database are permitted to modify data within the database, wherein comparison queries are scheduled to execute more frequently than informational queries during the data entry period;
executing the first query a first time to generate a first query result;
executing the first query at least a second time during the data entry period based on the schedule to generate a second query result;
aggregating validation results for the plurality of subsystems subject to the validation test based on results of executing the plurality of queries, wherein a validation result for the subsystem is determined, based on a comparison of the first query result and the second query result and the subsystem with which the first query is registered, that the subsystem has failed the validation test generating a set of one or more notifications based on which subsystems of the plurality of subsystems have failed the validation test according to the validation results, wherein execution scheduling, validation results, and notifications for each query are generated based at least in part on whether the query is an informational query or a comparison query; and
generating a set of one or more notifications based on which subsystems of the plurality of subsystems have failed the validation test according to the validation results, wherein execution scheduling, validation results, and notifications for each query are generated based at least in part on whether the query is an informational query or a comparison query.