Patent ID: 7908243

Claim:
A system comprising: a plurality of application databases, with each of said plurality of application databases recording a plurality of transactions; a data-warehouse receiving and storing said plurality of transactions, wherein transactions are received and stored in said data-warehouse at a first set of pre-determined time instances such that a first set of transactions of said plurality of transactions are stored in said data-warehouse before a first time instance, said data-warehouse containing a plurality of columns and a plurality of rows, each row corresponding to one of said plurality of transactions and having a corresponding value for each of said plurality of columns; an intermediary storage receiving transient data from said plurality of application databases, wherein said transient data comprises data corresponding to a set of transient transactions not yet stored in said data-warehouse after each of said first set of pre-determined time instances such that a second set of transactions of said set of transient transactions are in said intermediate storage, but not yet stored in said data-warehouse at a second time instance, wherein said transient data contains values for at least some of said plurality of columns corresponding to said set of transient transactions, wherein said second time instance is after said first time instance; and a reports server generating a single report based on the values contained in both of said plurality of transactions stored in said data-warehouse and said set of transient transactions stored in said intermediary storage at said second time instance, wherein the values of said transient transactions used in generating said single report are all later stored in said data-warehouse at a third time instance after said single report is generated, wherein said third time instance is after said second time instance.