DYNAMICALLY GENERATING AGGREGATE TABLES

• US 20140006963A1
• Filed: 08/29/2013
• Published: 01/02/2014
• Est. Priority Date: 05/26/2009
• Status: Abandoned Application

• Current Assignee: Google Inc. (Alphabet Inc.)
• Original Assignee: Google Inc. (Alphabet Inc.)
• Inventors: Nandy, Sagnik, Damm, Kevin, White, David
• Application Number:
  US14/013,664
• Publication Number:
  US 20140006963A1
• Time in Patent Office: Days
• US Class Current: 715/738
• CPC Class Codes: G06F 16/958 Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
• CPC Class Codes: G06F 3/0484 for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range

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.

Claims

1-25. -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.