System and method for processing, maintaining, and verifying data

摘要

In an exemplary embodiment, a system includes a database, a parsing module, a batching module, a comparison module, and a reporting module. The parsing module is operable to receive a first data file and a plurality of instructions for processing the data. The parsing module is operable to store at least a portion of data from the first data file in the database based at least in part on the plurality of instructions. The batching module can retrieve database queries from a second data file, receive a first indication that at least one database query is selected, and execute the at least one database query in the database. The comparison module is operable to retrieve a first data set from the database and retrieve a second data set, wherein the second data set is expected data, and determine whether the first data set matches the second data set.

主权项

1. A system comprising:
a first database; a parsing module operable to:
receive a first data file;facilitate the display of data retrieved from the first data file;receive a plurality of instructions from a user for processing the data retrieved from the first data file in response to facilitating the display of the data retrieved from the first data file; andstore at least a portion of data from the first data file in the first database based at least in part on the plurality of instructions received from the user; a batching module operable to:
retrieve a first plurality of database queries from a second data file, wherein the second data file comprises the first plurality of database queries;facilitate the display of the first plurality of database queries;receive a first indication that at least one database query of the plurality of database queries is selected; andexecute the at least one database query in the first database; a comparison module operable to:
retrieve a first data set from the first database;retrieve a second data set from a second database, wherein the second data set is correct data; andfacilitate display of one or more comparison structured query language (SQL) queries to the user;receive, from the user, a selection of the one or more comparison SQL queries;execute the selected one or more comparison SQL queries to determine whether the first data set matches the second data set;store a result of determining whether the first data set matches the second data set; and a data update and verification module operable to:
receive, from the user, a selection of a portion of data in the second database to update;receive, from the user, data to replace the portion of data, wherein the data to replace the portion of data is a selected one of expected results data and new data;when the data to replace the portion of data is new data, store the new data in an external file;when the data to replace the portion of data is expected results data, store the expected results data in the second database.