Abstract: A method includes parsing a query to determine a plurality of data processing operations associated with the query and including an AS OF JOIN operation between first time series data in a first table and second time series data in a second table. A query plan of the query is generated. The query plan includes a plurality of nodes corresponding to the plurality of data processing operations. At least one of the plurality of nodes corresponding to the AS OF JOIN operation is modified to generate a modified query plan of the query. The modifying is based on applying a UNION operation on at least a first portion of column data in the first table and the second table to obtain a combined table. Execution of the query by at least one of a plurality of computing nodes is scheduled based on the modified query plan.

Abstract: A solution is provided for determining traffic patterns involving a web page or property of interest in a computer network. This includes receiving path data regarding the web page or property of interest. Then, the number of visits to each of the other pages or properties visited by users in a session that included a visit to the web page or property of interest is counted. Then, from the path data and the counts, an aggregated data structure is constructed including, for each of the other web pages or properties visited by users in a session that included a visit to the web page or property of interest, visit count information and information regarding which web page or property within the network users visited next, if any. Then one or more metrics directed to traffic surrounding the web page or property of interest is provided using information from the aggregated data structure.

Abstract: A solution is provided for determining traffic patterns involving a web page or property of interest in a computer network. This includes receiving path data regarding the web page or property of interest. Then, the number of visits to each of the other pages or properties visited by users in a session that included a visit to the web page or property of interest is counted. Then, from the path data and the counts, an aggregated data structure is constructed including, for each of the other web pages or properties visited by users in a session that included a visit to the web page or property of interest, visit count information and information regarding which web page or property within the network users visited next, if any. Then one or more metrics directed to traffic surrounding the web page or property of interest is provided using information from the aggregated data structure.