Ensuring data integrity in reporting database query responses

A method of ensuring data integrity in reporting database query responses, the method comprising:

• updating a schema at a reporting engine to add a dirty-data bit/attribute per record of one or more reporting databases, wherein the dirty-data bit/attribute is inserted as a last attribute of each record of the one or more reporting databases;
• receiving a first query from a reporting client at the reporting engine;
• determining, at the reporting engine, a record in a first reporting database of the one or more reporting databases has the dirty-data bit/attribute set and is part of a result set for the first query;
• enhancing the first query to identify the record with the dirty-data bit/attribute set;
• communicating the enhanced query to a second reporting database of the one or more reporting databases;
• retrieving a synchronized record from the second reporting database;
• replacing the record with the dirty-data bit/attributed set from the first reporting database with the synchronized record from the second reporting database;
• and
• communicating a complete result set to the reporting client, the complete result set including the synchronized record from the second reporting database.

A system for ensuring data integrity in reporting database query responses, the system comprising:

• one or more reporting databases;
• a reporting engine in communication with the one or more reporting databases, wherein the reporting engine is configured to:
• update a schema at a reporting engine to add a dirty-data bit/attribute per record of one or more reporting databases, wherein the dirty-data bit/attribute is inserted as a last attribute of each record of the one or more reporting databases;
• receive a first query from a reporting client at the reporting engine;
• retrieve by the reporting engine a result set from a first reporting database of the one or more reporting databases, wherein a record in a first reporting database of the one or more reporting databases has the dirty-data bit/attribute set and is part of a result set for the first query;
• and
• (1) communicate the result set to the reporting client, the result set including the record and the dirty-data bit/attribute indicating stale data is present;
• or
• (2) enhance the first query to identify the record with the dirty-data bit/attribute set;
• communicate the enhanced query to a second reporting database of the one or more reporting databases;
• retrieve a synchronized record from the second reporting database;
• replace the record with the dirty-data bit/attributed set from the first reporting database with the synchronized record from the second reporting database;
• and communicate a complete result set to the reporting client, the complete result set including the synchronized record from the second reporting database.