Abstract: Techniques are described for leveraging column dictionaries of tables for join, group-by and expression evaluation operations. In an embodiment, a table is stored in one or more data units, each data unit's metadata containing dictionaries for stored columns. Rather than storing unencoded column values, the data units may store columns as column vectors of dictionary-encoded values, in an embodiment. When performing a join operation, a matching of values may be performed on the build-side table using the unencoded, unencoded, values stored in the join-key dictionary(s) of the probe-side table, thus, significantly reducing the number of searching and matching operations. In an embodiment, a group-by operation may be executed by performing partial aggregations based on unique group-by key values as stored in the one or more group-by key dictionaries.

Abstract: Attributes and semantics of duplicate insignificance that are inherent or inferred in a database language statement are detected. Also, a join operation that is inherent or inferred in the database language statement is detected and examined for join semantics. The join semantics specifies or refers to a driving table to be subjected to a hash join operation that may populate one or more hash buckets. The optimizer and the execution layers may use cost estimation or heuristics to assign the left and right table roles to the tables involved in the join. The hash join operation removes left table duplicates during population of the hash buckets, resulting in full or partial duplicate elimination that occurs during the hash join operation.

Abstract: Techniques are described herein for processing queries comprising joins specifying a plurality of tables. The techniques involve partitioning the tables by assigning rows to partitions. One or more partition maps may be generated to indicate the partitions. Subsequent tables may be partitioned based on the generated partition maps. The partitions may be used to determine results for the joins.

Abstract: A system may receive a first list of users of a provider network. For each of the first list of users, the system may obtain data pertaining to the user's categories of interest from a social media system; infer video programs based on the data; infer a list of one or more video channels based on the video programs; score the one or more video channels; rank the list of one or more video channels based on the scores; and recommend the ranked list of one or more video channels.

Abstract: The present invention generally relates to a process for preparation of 9-halo-3-(2-haloacetyl)-10,11-dihydro-5H-dibenzo[c,g]chromen-8(9H)-one of Formula I, which is an intermediate in the preparation of Hepatitis C Virus (HCV) inhibitors.

Abstract: Techniques are provided herein for processing a query using in-memory cursor duration temporary tables. The techniques involve storing a part of the temporary table in memory of nodes in a database cluster. A part of the temporary table may be stored in disk segments of nodes in the database cluster. Writer threads running on a particular node writes data for the temporary table to the memory of the particular node. Excess data may be written to the disk segment of the particular node. Reader threads running on the particular node reads data for the temporary table from the memory of the particular node and the disk segment of the particular node.

Abstract: Techniques for query optimization for group-by extensions and distinct aggregate functions are provided. A query has an extended group-by clause with an extended group-by operator and a first set of group-by columns. The query has one or more distinct aggregate functions and one or more non-distinct aggregate functions. An initial subquery is constructed that generates a partially aggregated initial temporary (PAIT) table when executed. The initial subquery includes a GROUP BY clause with a second set of group-by columns that includes the first set of group-by columns of the extended group-by clause of the query and one or more columns specified by the one or more distinct aggregate functions. One or more subqueries are computed that compute groupings indicated by the extended group-by operator based on the PAIT table generated by the initial subquery.

Abstract: A user device receives, from a network device, a content index of content items available for presentation via a content distribution network. The user device presents a user interface to configure a personalized channel plan and receives, via the user interface, user input to configure the personalized channel plan. The personalized channel plan includes a schedule of selected content items, from the content index, for presentation on a remote viewing device. The user device sends, to a remote viewing device, presentation instructions for the personalized channel plan, wherein the instructions cause the viewing device to present the selected content items to the user.

Abstract: A routing device is coupled to a storage device to function as a digital video recorder (DVR) to store digital content. The routing device may include a client function to receive and store the digital content, and a server function to provide the stored digital content to a user device. Digital content directed to the client function may be recorded by the storage device, while other digital content may be passed by server function to the user device. The digital content may be received by the routing device in an encoded and/or encrypted format, and the digital content may be recorded by the storage device in the encoded and/or encrypted format.

Abstract: A server device may receive, from a user device, a request to store a unique copy of particular content, associated with a particular user; store, in a storage device associated with the server device, the unique copy of the particular content; determine a set of attributes of the particular content; determine a set of criteria based on which the unique copy of the particular content should be provided to the user device, the determining being based on one or more attributes, of the set of attributes of the particular content; determine that the set of criteria have been met; output, based on determining that the set of criteria have been met, the unique copy of the particular content to the user device; and delete the unique copy of the particular content from the storage device after outputting the particular content to the user device.

Abstract: According to one aspect of the invention, for a database statement that specifies evaluating reporting window functions, a computation-pushdown execution strategy may be used for the database statement. The computation-pushdown execution plan includes producer operators and consolidation operators. Each producer operator computes a respective partial aggregation for each reporting window function based on a subset of rows, and broadcasts the respective partial aggregation. Each consolidation operator fully aggregates all partial aggregations broadcasted from the producer operators. Alternatively, an extended-data-distribution-key execution plan may be used. Each producer operator sends rows based on hash keys to sort operators for computing partial aggregations for at least one reporting window function based on a subset of rows. Each consolidation operator receives and fully aggregates all partial aggregations broadcasted from the sort operators.

Abstract: One or more network devices provide, to a user device, a content list of content items available for presentation. The one or more network devices receive, from the user device, a personalized channel plan that includes a schedule of selected content items, from the content list, for presentation on a viewing device that is different than the user device. The one or more network devices select, based on the selected content items, advertising for inclusion with the selected content items and assign links for the viewing device to obtain the selected content items. The one or more network devices send the links to the user device, which may in turn be provided to the viewing device.

Abstract: Network devices provide, to a content source device, an uplink user interface to describe and upload video content. The network devices receive, via the uplink user interface, descriptive information for the video content and generate, based on the descriptive information received via the uplink user interface, a unique content identifier for the video content. The network devices incorporate, based on the descriptive information, a listing of the video content into a catalog of content available to users of a content distribution network. The network devices receive, from the content source device, the video content and receive, from a user device, a request to view the video content that includes the unique content identifier. The network devices provide, to the user device, a link to enable the user device to access the video content via the content distribution network.

Abstract: A user device receives, from a network device, a content index of content items available for presentation via a content distribution network. The user device presents a user interface to configure a personalized channel plan and receives, via the user interface, user input to configure the personalized channel plan. The personalized channel plan includes a schedule of selected content items, from the content index, for presentation on a remote viewing device. The user device sends, to a remote viewing device, presentation instructions for the personalized channel plan, wherein the instructions cause the viewing device to present the selected content items to the user.

Abstract: A local router for a home network pairs with a mobile device via a local network connection. The local router is also connected to a wide area network. The local router receives, from the mobile device and over the local network connection, configuration settings for a backup path for the wide area network. The backup path includes the local network connection and a mobile broadband connection using the mobile device. The local router detects an interruption with the local router's connection to the managed wide area network and forwards, based on the detecting, critical traffic from the home network via the backup path.

Abstract: According to one aspect of the invention, for a database statement that specifies evaluating reporting window functions, a computation-pushdown execution strategy may be used for the database statement. The computation-pushdown execution plan includes producer operators and consolidation operators. Each producer operator computes a respective partial aggregation for each reporting window function based on a subset of rows, and broadcasts the respective partial aggregation. Each consolidation operator fully aggregates all partial aggregations broadcasted from the producer operators. Alternatively, an extended-data-distribution-key execution plan may be used. Each producer operator sends rows based on hash keys to sort operators for computing partial aggregations for at least one reporting window function based on a subset of rows. Each consolidation operator receives and fully aggregates all partial aggregations broadcasted from the sort operators.

Abstract: A routing device is coupled to a storage device to function as a digital video recorder (DVR) to store digital content. The routing device may include a client function to receive and store the digital content, and a server function to provide the stored digital content to a user device. Digital content directed to the client function may be recorded by the storage device, while other digital content may be passed by server function to the user device. The digital content may be received by the routing device in an encoded and/or encrypted format, and the digital content may be recorded by the storage device in the encoded and/or encrypted format.

Abstract: A server device may receive, from a user device, a request to store a unique copy of particular content, associated with a particular user; store, in a storage device associated with the server device, the unique copy of the particular content; determine a set of attributes of the particular content; determine a set of criteria based on which the unique copy of the particular content should be provided to the user device, the determining being based on one or more attributes, of the set of attributes of the particular content; determine that the set of criteria have been met; output, based on determining that the set of criteria have been met, the unique copy of the particular content to the user device; and delete the unique copy of the particular content from the storage device after outputting the particular content to the user device.

Abstract: A system may receive a first list of users of a provider network. For each of the first list of users, the system may obtain data pertaining to the user's categories of interest from a social media system; infer video programs based on the data; infer a list of one or more video channels based on the video programs; score the one or more video channels; rank the list of one or more video channels based on the scores; and recommend the ranked list of one or more video channels.

Abstract: A local router for a home network pairs with a mobile device via a local network connection. The local router is also connected to a wide area network. The local router receives, from the mobile device and over the local network connection, configuration settings for a backup path for the wide area network. The backup path includes the local network connection and a mobile broadband connection using the mobile device. The local router detects an interruption with the local router's connection to the managed wide area network and forwards, based on the detecting, critical traffic from the home network via the backup path.