Patent ID: 8296336

Claim:
A method for loading data into a partitioned table, the method comprising: executing by a scheduler executed by the computer system one or more tasks at predetermined intervals; collecting by a first data collector executed by a computer system and based on the tasks executed by the scheduler data from a first set of one or more data sources, the first data collector associated with the first set of one or more data sources; storing by the computer system the data from the first set of one or more data sources in a first swap table, the first swap table associated with the first data collector, wherein prior to storing the data from the first set of one or more data sources the first swap table contains no data and a high water mark of the first swap table has been reset to reflect that the first swap table contains no data and after storing the data from the first set of one or more data sources the high water mark of the first swap table indicates an actual amount of data in the first swap table; swapping by the computer system and based on the tasks executed by the scheduler the first swap table with a first partition of the partitioned table; truncating by the computer system and based on the tasks executed by the scheduler the first swap table to reset the high water mark for the first swap table after swapping the first swap table with the first partition of the partitioned table; collecting by a second data collector executed by the computer system and based on the tasks executed by the scheduler data from a second set of one or more data sources, the second data collector associated with the second set of one or more data sources and separate from the first data collector; storing by the computer system the data from the second set of one or more data sources in a second swap table, the second swap table associated with the second data collector and separate from the first swap table, wherein prior to storing the data from the second set of one or more data sources the second swap table contains no data and a high water mark of the second swap table has been reset to reflect that the second swap table contains no data and after storing the data from the second set of one or more data sources the high water mark of the second swap table indicates an actual amount of data in the second swap table; swapping by the computer system and based on the tasks executed by the scheduler the second swap table with a second partition of the partitioned table; and truncating by the computer system and based on the tasks executed by the scheduler the second swap table to reset the high water mark for the second swap table after swapping the second swap table with the second partition of the partitioned table.