Abstract: A computer system, method, and non-transitory computer-readable medium are provided. A request including unauthenticated data is created and securely transmitted to a remote device, metadata corresponding to the request is updated to indicate successful validation, a response file is validated, and a discrepancy is detected between the unauthenticated data and the authenticated data. Correction data is obtained, and a transaction based on the request and the correction data is executed. A second processor of the remote device verifies that an unauthorized user has not modified the authenticated data, generates a database table based on one or more fields of the authenticated data, extracts one or more predetermined data values from the authenticated data and the database table, and validates the unauthenticated data in the request based on comparing the one or more predetermined data values from the authenticated data and the database table to the unauthenticated data in the request.

Abstract: Techniques for database and file management herein include a processor and a memory device storing instructions that cause the processor to perform operations comprising creating a request based on an extensible markup language (XML) or an interpreted scripting language object, wherein the request comprises unauthenticated data for validation. The operations can also include transmitting the request to a remote device), updating metadata corresponding to the request to indicate the successful validation by the remote device, validating a response file, and detecting a discrepancy between the unauthenticated data and the authenticated data accessible by the remote device. Additionally, the operations include obtaining correction data to resolve the discrepancy, and executing a transaction based on the request and the correction data.

Abstract: A system and a method for keeping two versions of a mirrored database in sync is provided. A connection is monitored between a primary database and a secondary database. When a loss of the connection between the primary database and the secondary database is detected, the primary database is monitored for changes. When a modification is detected to at least one row in the primary database, a value of a change indicator is changed for the corresponding row indicating that the row was modified. Once the connection between the primary and the secondary databases is restored, the primary database is queried for the value of the change indicator indicating the corresponding row was modified to obtain a current value for data in the corresponding row of the primary database, and the corresponding row in the secondary database is updated with the current value for the corresponding row.

Abstract: An operating system on a source computer system includes a filtered remote journal mechanism that generates a target map of a remote journal to specify where in the remote journal entries will be stored, then generates a vector array that represents the data of interest in the database journal based on specified selection criteria and the target map. The vector array and location information from the target map is then sent to a communication manager, which sends the data indicated in the vector array to the target computer system. On the target computer system, the communication manager reads the data sent from the source computer system and writes the data to the remote journal. The filtered remote journal mechanism may operate on an existing database journal, or may operate iteratively as journal entries are written on the source computer system.

Abstract: An operating system on a source computer system includes a filtered remote journal mechanism that generates a target map of a remote journal to specify where in the remote journal entries will be stored, then generates a vector array that represents the data of interest in the database journal based on specified selection criteria and the target map. The vector array and location information from the target map is then sent to a communication manager, which sends the data indicated in the vector array to the target computer system. On the target computer system, the communication manager reads the data sent from the source computer system and writes the data to the remote journal. The filtered remote journal mechanism may operate on an existing database journal, or may operate iteratively as journal entries are written on the source computer system.