Quality assurance system for heterogeneous data sources

Brief

Main purpose of this system is to automate validation of data read from various sources (any JDBC compliant DBMS or flat files) and detection of erroneous transactions. Validity of a transaction is determined by executing a set of custom statements on each transaction and can be based on data of the current transaction, variables that keep aggregated data from this or any other available source. Upon detection of an invalid transaction it may perform one of several available actions. Validation can be performed in passive mode, where transactions are fed to the system via API, or in active mode, when the system fetches information about transactions from the sources. Custom statements are expressed in a UI-driven pseudo programming language.

Architecture

A desktop application accessing database hosted on either Oracle or SQL Server.