Dynamically generating aggregate tables

Abstract

A method and system dynamically create aggregate tables. An aggregate table manager is instantiated that receives a plurality of aggregate table definitions, and generates aggregate tables based on the received aggregate table definitions. The aggregate table manager creates a view corresponding to each of the aggregate tables. The aggregate table manager creates and updates data entries in the aggregate tables based on their corresponding aggregate table definitions and data extracted from web site log files.

1 - 25 . (canceled) 
     
     
         26 . A method for providing a view of web analytics data, the method comprising:
 providing a user interface, wherein the user interface is configured to receive a user selection of a view of web analytics data;   receiving a user selection of a view of web analytics data from a user via the user interface, wherein the selected view includes a subset of the web analytics data selected for viewing;   determining whether the selected view of the web analytics data includes data stored in one or more aggregate tables;   in response to a determination that the selected view includes data stored in at least one of the one or more aggregate tables, retrieving data from at least one of the aggregate tables;   in response to a determination that the selected view includes data not stored in any of the one or more aggregate tables, retrieving data from a hits table; and   presenting the retrieved data for viewing in the selected view.   
     
     
         27 . The method of  claim 26 , wherein the user interface is configured to receive a selection of a user-defined view of the web analytics data;
 wherein receiving a user selection of a view of web analytics data comprises receiving a user-defined view including a user-defined subset of the web analytics data.   
     
     
         28 . The method of  claim 26 , wherein retrieving data from the hits table comprises:
 executing a query in the hits table; and   retrieving data from the hits table in response to the query   
     
     
         29 . The method of  claim 26 , further comprising:
 populating and updating data entries in the one or more aggregate tables using data stored in the hits table.   
     
     
         30 . The method of  claim 29 , further comprising:
 receiving a selection of a web site; and   storing hits data associated with the selected web site in the hits table.   
     
     
         31 . The method of  claim 30 , wherein populating and updating the data entries in the one or more aggregate tables comprises:
 identifying the hits data associated with the selected web site in the hits table; and   populating and updating the data entries in the one or more aggregate tables using the identified hits data.   
     
     
         32 . The method of  claim 26 , further comprising:
 receiving a plurality of aggregate table definitions; and   generating at least one of the one or more aggregate tables using the aggregate table definitions.   
     
     
         33 . The method of  claim 32 , wherein the plurality of aggregate table definitions include one or more pre-defined aggregate table definitions and one or more user-defined aggregate table definitions. 
     
     
         34 . A system for providing a view of web analytics data, the system comprising:
 a processing circuit comprising one or more processors and one or more memory devices, wherein the processing circuit is configured to:
 provide a user interface to a client device, wherein the user interface is configured to receive a user selection of a view of web analytics data; 
 receive a user selection of a view of web analytics data from a user via the user interface, wherein the selected view includes a subset of the web analytics data selected for viewing; 
 determine whether the selected view of the web analytics data includes data stored in one or more aggregate tables; 
 in response to a determination that the selected view includes data stored in at least one of the one or more aggregate tables, retrieve data from at least one of the aggregate tables; 
 in response to a determination that the selected view includes data not stored in any of the one or more aggregate tables, retrieve data from a hits table; and 
 present the retrieved data for viewing in the selected view. 
   
     
     
         35 . The system of  claim 34 , wherein the user interface is configured to receive a selection of a user-defined view of the web analytics data;
 wherein receiving a user selection of a view of web analytics data comprises receiving a user-defined view including a user-defined subset of the web analytics data.   
     
     
         36 . The system of  claim 34 , wherein retrieving data from the hits table comprises:
 executing a query in the hits table; and   retrieving data from the hits table in response to the query   
     
     
         37 . The system of  claim 34 , wherein the processing circuit is further configured to:
 populate and update data entries in the one or more aggregate tables using data stored in the hits table.   
     
     
         38 . The system of  claim 37 , wherein the processing circuit is further configured to:
 receive a selection of a web site; and   store hits data associated with the selected web site in the hits table.   
     
     
         39 . The system of  claim 38 , wherein populating and updating the data entries in the one or more aggregate tables comprises:
 identifying the hits data associated with the selected web site in the hits table; and   populating and updating the data entries in the one or more aggregate tables using the identified hits data.   
     
     
         40 . The system of  claim 34 , wherein the processing circuit is further configured to:
 receive a plurality of aggregate table definitions; and   generate at least one of the one or more aggregate tables using the aggregate table definitions.   
     
     
         41 . The system of  claim 40 , wherein the plurality of aggregate table definitions include one or more pre-defined aggregate table definitions and one or more user-defined aggregate table definitions. 
     
     
         42 . A method for providing a view of web analytics data, the method comprising:
 providing, by a computer system, a user interface for selection of a view of web analytics data;   receiving, at the computer system, a view selection from a user utilizing the user interface;   determining, by the computer system, whether the selected view includes data in one or more aggregate tables;   when the selected view includes data in at least one aggregate table:
 retrieving data from the at least one aggregate table; and 
 returning the data to the user in a respective view; and 
   when the selected view includes data that is not stored in any aggregate table:
 executing a corresponding query in a hits table; 
 retrieving the data from the hits table in response to the query; and 
 returning the data to the user in a respective view. 
   
     
     
         43 . The method of  claim 42 , further comprising:
 receiving an aggregate table definition from a user, the aggregate table definition including a description of metrics and dimensions to be included in the one or more aggregate tables; and   building an executable class definition for the one or more aggregate tables based on the aggregate table definition.   
     
     
         44 . The method of  claim 43 , wherein the class definition comprises:
 retriever modules configured to extract data for respective dimensions and metrics from the hit table and to populate the aggregate table with the extracted data; and   generator modules configured to generate views for an end user corresponding to the data in the aggregate table.   
     
     
         45 . The method of  claim 43 , further comprising:
 executing a class corresponding to the executable class definition; and   generating and populating an aggregate table according to the aggregate table definition.