公开(公告)号：US09430519B1

公开(公告)日：2016-08-30

申请号：US13951770

申请日：2013-07-26

Applicant: Google Inc.

Inventor： Chao Cai ,  Eric W. Ewald ,  Cameron M. Tangney ,  Sagnik Nandy

IPC: G06F17/30

CPC classification number: G06F17/30386 ,  G06F17/30457 ,  G06F17/30489 ,  G06F17/3053

Abstract: Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for dynamically generating and configuring pre-aggregated datasets optimized for responding to particular types of data requests made against a large sub-optimal multidimensional dataset are disclosed. A dynamic aggregator monitors the query types and response latencies associated with queries made against the large multidimensional dataset. The dynamic aggregator defines pre-aggregated datasets based on the types of queries received from users and calculates a respective benefit score for each pre-aggregated dataset. The benefit score of each pre-aggregated dataset can be based on the recorded latencies and query count for the pre-aggregated dataset. The dynamic aggregator can decide whether to generate and/or maintain particular pre-aggregated datasets based on the current values of the benefit scores associated with the particular pre-aggregated datasets.

公开(公告)号：US20160034498A1

公开(公告)日：2016-02-04

申请号：US13926300

申请日：2013-06-25

Applicant: Google Inc.

Inventor： Jieyan Fan ,  Cedric Ho ,  Yuan Zhuge ,  Sagnik Nandy

IPC: G06F17/30

CPC classification number: G06F17/30292 ,  G06F17/30297

Abstract: Systems and methods for retroactively performing dimension widening on a data element are provided. A described method includes receiving a set of data elements from a database and a set of dimension widening rules. The method further includes identifying one or more of the data elements to which any of the dimension widening rules are applicable. The method further includes processing the identified data elements by applying the applicable dimension widening rules to the identified data elements. A dimension widening delta is generated for each data element, and the dimension widening deltas may be stored. The method further includes merging one or more of the data elements with one or more of the dimension widening deltas in response to a query.

Abstract translation: 提供了在数据元素上追溯性地进行尺寸加宽的系统和方法。 所描述的方法包括从数据库接收一组数据元素和一组维度扩大规则。 该方法还包括识别适用于任何维度扩大规则的一个或多个数据元素。 该方法还包括通过将适用的维度扩大规则应用到所识别的数据元素来处理所识别的数据元素。 为每个数据元素生成维度加宽增量，并且可以存储维度加宽三角形。 该方法还包括响应于查询而将一个或多个数据元素与一个或多个维度加宽三角形合并。

公开(公告)号：US20130297778A1

公开(公告)日：2013-11-07

申请号：US13841781

申请日：2013-03-15

Applicant: Google Inc.

Inventor： Jerry Hong ,  Paul Muret ,  Sagnik Nandy ,  Evan S. Huang ,  Madhu Kallazhi Vasu ,  James Lee Wogulis ,  Bradley David Townsend ,  Neil Rhodes ,  Naomi Ben-Ayoun ,  Stella Marie Laurenzo ,  Lucas Paul Hansen ,  Avi Mehta ,  Nick Mihailovski ,  Ashok Babu Amara

IPC: G06F15/173

CPC classification number: G06F16/245 ,  G06F16/958 ,  G06Q30/0201 ,  H04L43/04 ,  H04L43/0876 ,  H04L43/10

Abstract: The subject technology provides a session associated with web site or application traffic data. An analytics tracking data communication is received. The subject technology determines analytics tracking data from the received analytics tracking data communication in which the analytics tracking data includes data for tracking an activity associated with a web site or application and includes visitor information. A new session associated with the analytics tracking data is created if it is determined that the activity is associated with an initial visit of a unique visitor corresponding to the visitor information. The subject technology determines campaign information for populating the new session associated with the analytics tracking data. The analytics tracking data including the determined campaign information is then stored.

Abstract translation: 主题技术提供与网站或应用交通数据相关联的会话。 接收到分析跟踪数据通信。 主题技术确定来自接收到的分析跟踪数据通信的分析跟踪数据，其中分析跟踪数据包括用于跟踪与网站或应用相关联的活动的数据，并且包括访问者信息。 如果确定活动与访问者信息对应的唯一访问者的初次访问相关联，则创建与分析跟踪数据相关联的新会话。 主题技术确定用于填充与分析跟踪数据相关联的新会话的活动信息。 然后存储包括所确定的活动信息的分析跟踪数据。

公开(公告)号：US09384221B2

公开(公告)日：2016-07-05

申请号：US13926300

申请日：2013-06-25

Applicant: Google Inc.

Inventor： Jieyan Fan ,  Cedric Ho ,  Yuan Zhuge ,  Sagnik Nandy

IPC: G06F7/00 ,  G06F17/30

CPC classification number: G06F17/30292 ,  G06F17/30297

Abstract: Systems and methods for retroactively performing dimension widening on a data element are provided. A described method includes receiving a set of data elements from a database and a set of dimension widening rules. The method further includes identifying one or more of the data elements to which any of the dimension widening rules are applicable. The method further includes processing the identified data elements by applying the applicable dimension widening rules to the identified data elements. A dimension widening delta is generated for each data element, and the dimension widening deltas may be stored. The method further includes merging one or more of the data elements with one or more of the dimension widening deltas in response to a query.

Abstract translation: 提供了在数据元素上追溯性地进行尺寸加宽的系统和方法。 所描述的方法包括从数据库接收一组数据元素和一组维度扩大规则。 该方法还包括识别适用于任何维度扩大规则的一个或多个数据元素。 该方法还包括通过将适用的维度扩大规则应用到所识别的数据元素来处理所识别的数据元素。 为每个数据元素生成维度加宽增量，并且可以存储维度加宽三角形。 该方法还包括响应于查询而将一个或多个数据元素与一个或多个维度加宽三角形合并。

公开(公告)号：US09462083B1

公开(公告)日：2016-10-04

申请号：US13833459

申请日：2013-03-15

Applicant: Google Inc.

Inventor： Yuan Zhuge ,  Xiuduan Fang ,  Niranjan Heddese Sitaram Shastry ,  Nagaraju Pothineni ,  Sagnik Nandy ,  Jesse Savage ,  Sissie Hsiao ,  Chao Cai

IPC: H04L29/06

CPC classification number: H04L67/42 ,  G06Q30/02 ,  H04L67/02 ,  H04L67/10 ,  H04L67/20

Abstract: The present disclosure is directed generally to systems and methods for the server side matching of web analytics and content viewing. According to the methods and systems disclosed herein, a first identifier is delivered to a client device when the client device accesses a first website. If the client device later accesses of a second website the first identifier can be processed by the system to determine if the client device previously accessed the first website.

Abstract translation: 本公开一般涉及用于网络分析和内容观看的服务器端匹配的系统和方法。 根据本文公开的方法和系统，当客户端设备访问第一网站时，第一标识符被传送到客户端设备。 如果客户端设备稍后访问第二个网站，系统可以处理第一个标识符，以确定客户端设备以前是否访问过第一个网站。

公开(公告)号：US20140006963A1

公开(公告)日：2014-01-02

申请号：US14013664

申请日：2013-08-29

Applicant: Google Inc.

Inventor： Sagnik Nandy ,  Kevin Damm ,  David White

IPC: G06F3/0484

CPC classification number: G06F3/0484 ,  G06F16/958

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.

Abstract translation: 方法和系统动态创建聚合表。 实例化聚合表管理器，其接收多个聚合表定义，并且基于接收到的聚合表定义生成聚合表。 聚合表管理器创建与每个聚合表对应的视图。 聚合表管理器根据其对应的聚合表定义和从网站日志文件中提取的数据，在聚合表中创建和更新数据条目。

公开(公告)号：US20130297776A1

公开(公告)日：2013-11-07

申请号：US13841685

申请日：2013-03-15

Applicant: Google Inc.

Inventor： Jerry Hong ,  Paul Muret ,  Sagnik Nandy ,  Madhu Kallazhi Vasu ,  Evan S. Huang ,  Naomi Ben-Ayoun ,  James Lee Wogulis ,  Bradley David Townsend ,  Neil Rhodes ,  Stella Marie Laurenzo ,  Lucas Paul Hansen ,  Avi Mehta

IPC: G06F15/173

CPC classification number: G06F16/245 ,  G06F16/958 ,  G06Q30/0201 ,  H04L43/04 ,  H04L43/0876 ,  H04L43/10

Abstract: The subject technology provides configurations for processing late and/or out-of-order analytics tracking data communications. An analytics tracking data communication is received. The subject technology determines a timestamp included in the analytics tracking data from the received analytics tracking data communication. The subject technology determines a session based on the determined new state changing information. The subject technology determines other analytics tracking data included in the analytics tracking data communication to associate with the determined new state changing information in the determined session if new state changing information is included in the analytics tracking data from the received analytics tracking data communication. The analytics tracking data and the other analytics tracking data associated with the new campaign information is then stored.

Abstract translation: 主题技术提供用于处理后期和/或无序分析跟踪数据通信的配置。 接收到分析跟踪数据通信。 主题技术从接收到的分析跟踪数据通信中确定包括在分析跟踪数据中的时间戳。 主题技术基于所确定的新的状态改变信息来确定会话。 如果新的状态改变信息被包括在来自接收到的分析跟踪数据通信的分析跟踪数据中，则主题技术确定包括在分析跟踪数据通信中的其他分析跟踪数据与所确定的新的状态改变信息相关联。 然后存储与新的活动信息相关联的分析跟踪数据和其他分析跟踪数据。

公开(公告)号：US20160042013A1

公开(公告)日：2016-02-11

申请号：US13926262

申请日：2013-06-25

Applicant: GOOGLE INC.

Inventor： Jieyan Fan ,  Yuan Zhuge ,  Niranjan Heddese Sitaram Shastry ,  Sagnik Nandy

IPC: G06F17/30

CPC classification number: G06F16/283

Abstract: Systems and methods for performing dimension widening on a data element are provided. A described method includes receiving a set of dimension widening rules, and receiving a data element having one or more dimensions. The method further includes determining if any of the dimension widening rules are applicable to the data element. The data element may be stored in either a first database or second database based on a result of the determination. Data elements stored in the first database may be processed by applying the dimension widening rules to the data elements.

Abstract translation: 提供了用于在数据元素上进行尺寸加宽的系统和方法。 所描述的方法包括接收一组维度加宽规则，以及接收具有一个或多个维度的数据元素。 该方法还包括确定是否有任何维度扩大规则适用于数据元素。 可以基于确定的结果将数据元素存储在第一数据库或第二数据库中。 存储在第一数据库中的数据元素可以通过将维度扩大规则应用于数据元素来处理。