Systems and methods for extracting data sets from an online relational database into a data warehouse

A computer system for providing data sets to a data warehouse, comprising:

• a posting system comprising an internal clock and at least one server;
• a computer;
• a timestamping component computer program module for use on the computer, the timestamping component computer program module using the internal clock for timestamping of data sets being entered in the posting system;
• an online relational database comprising one or more tables each configured to store a plurality of the timestamped data sets;
• a data query generator generating a query of the online relational database executed to obtain a subset of the data sets having timestamps subsequent to a first reference time, the first reference time being the time of the previous database query (t1) minus a time interval (delta), wherein the time interval is equal to or greater than a maximum latency time between time stamping and storage in database;
• and
• a network for sending the subset of the data sets having timestamps subsequent to the first reference time to the data warehouse.