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: 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: 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: 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.

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: Techniques are described for parallelizing qualifying window functions without reliance on partitioning criteria specified in the command that includes the qualifying window functions. Because the techniques do not rely on partitioning criteria specified in the command, the techniques may be used on commands in which no partitioning criteria is specified. In general, the techniques involve partitioning the work of a qualified window function into ranges, and sharing precomputed aggregate values between computational elements to calculate the value for the window functions.

Abstract: Establishing a conference between a customer at a customer terminal and a live agent at an agent station, by (a) accepting a call request from the customer terminal, (b) requesting that an available live agent take the call request, (c) when a live agent becomes available to take the call request, passing customer information to the agent station associated with the available live agent, and (d) establishing a conference from the agent station associated with the available live agent to the customer terminal. The conference may be an audio-video conference. The audio-video conference may be compliant with the H.323 standard. The call request may generated in response to an event sensed by an API which was previously downloaded to the customer terminal from a web server. The call request may be generated in response to a trigger event.

Abstract: Techniques are described herein for supporting efficient evaluation of pivot operations. In an embodiment, a pivoting query on a data table is received. The query identifies pivot columns, measure columns, and grouping columns. In response to receiving the query, a staging table that comprises new pivot columns, aggregated columns, and new grouping columns may be created. For each particular unique combination of values of the grouping columns and the pivot columns in the data table, stored values in the measure columns in the data table are aggregated for certain rows in the plurality of rows in the data table. Each row of the certain rows comprises the each particular unique combination of values of the grouping columns and the pivot columns in the data table. Results of aggregating are stored in the staging table. Data that has been populated in the staging table is transposed into a result set.