Timestamp normalized counter data

A network system comprising:

• a counter providing a network resource to at least one subscriber of the network system;
• a data warehouse;
• a collector collecting, from the counter, counter data corresponding to usage of the network resource, wherein the counter data includes timestamp data;
• and
• a mediator comprising at least one processor executing instructions stored in a memory to convert the counter data into timestamp normalized counter data, and storing the timestamped normalized counter data in the data warehouse, wherein the conversion of the counter data includes dividing the counter data among a plurality of buckets according to the timestamp data of the counter data and enforcing a time-range-framing over the timestamp data of the counter data by converting a stop timestamp of the counter data to a stop timestamp of a respective one of the buckets containing the counter data, wherein different portions of the timestamp normalized counter data are placed in different buckets of the plurality of buckets, and wherein at least one individual occurrence of the counter data overlapping at least a first bucket and a second bucket of the plurality of buckets is divided into a plurality of occurrences of the timestamp normalized counter data placed in at least said first and second buckets with the stop timestamps of the occurrences converted to the stop timestamps of the respective buckets, the timestamp normalized counter data supporting database queries,
• wherein the collector and the mediator are disposed between the counter and the data warehouse.

An article of manufacture comprising a computer program product for timestamp normalizing counter data, the computer program product comprising:

• a computer-readable recordable storage medium storing non-transitory computer readable program code, the computer readable program code comprising:
• computer readable program code executed by at least one processor to collect, over a time period, counter data corresponding to usage of a network resource, wherein the counter data includes timestamp data, and wherein the collection of the counter data is performed by a counter device at irregular intervals;
• computer readable program code executed by at least one processor to divide the time period into a plurality of buckets, each of the buckets having a stop timestamp;
• and
• computer readable program code executed by the at least one processor to convert the counter data into timestamp normalized counter data by dividing the counter data among the plurality of buckets according to the timestamp data of the counter data and enforcing a time-range-framing over the timestamp data of the counter data by converting a stop timestamp of the counter data to the stop timestamp of a respective one of the buckets containing the counter data, wherein different portions of the timestamp normalized counter data are placed in different buckets of the plurality of buckets, and wherein at least one individual occurrence of the counter data overlapping at least a first bucket and a second bucket of the plurality of buckets is divided into a plurality of occurrences of the timestamp normalized counter data placed in at least said first and second buckets with the stop timestamps of the occurrences converted to the stop timestamps of the respective buckets.