Aggregation of data from disparate sources into an efficiently accessible format

摘要

Methods and apparatus are presented for aggregating data from disparate sources into an efficiently accessible format. For example, an aggregation tool may receive attribute-based data from one source and metrics-based data from another source. Given this data, the aggregation tool may store attribute data from the attribute-based data into a data object, where the data object includes multiple time slots corresponding to defined time ranges. The aggregation tool may then determine from the metrics-based data, respective metrics data for each of the multiple time slots of the data object, where each time slot is associated with the attribute data. The aggregation tool may store the respective metrics data into each of the multiple time slots of the data object. In this way, the data object may serve to efficiently provide an answer to a query requiring data from multiple data sources.

主权项

1. A computer implemented method, comprising:
aggregating data from at least two different data sources, the aggregating comprising:
receiving attribute-based data from a transactional data source;receiving analytics data from an analytics data source, the analytics data being organized according to time and comprising metrics data associated with interaction with a web site;storing attribute data from the received attribute-based data in a data object-comprising a plurality of time slots, each time slot corresponding to a defined time range;determining, based on the received analytics data, respective metrics data for each of the plurality of time slots of the data object, each time slot of the plurality of time slots being associated with the attribute data; andstoring the respective metrics data into respective ones of the plurality of time slots of the data object; receiving a query, wherein data satisfying the query is stored in the transactional data source, the analytics data source, and the data object; and generating a query response based on:
the attribute data of the data object; andmetrics data from one time slot of the plurality of time slots of the data object.