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: A DVR, server, or other agent correlates media metadata from diverse sources, like an EPG data provider and multiple video-on-demand (VOD) service providers. Metadata sets from different sources are compared in order to attempt to identify identical programs to which the metadata sets pertain. From at least one metadata set, information about the program that the other metadata set lacks is selected. A “canonical” data structure instance for the program is created. The information that is lacking from at least one of the metadata sources is inserted into that instance. For each source from which a program is available, the DVR stores the identity of that source on the DVR's persistent storage device in association with the canonical data structure instance for that program. The DVR receives search criteria from a user and then searches the stored canonical data structure instance for programs that satisfy the criteria.

Abstract: In an embodiment, a filter chain object comprising an association of a starting set of data items and two or more filter links is created and stored in computer memory. Each of the filter links comprises a component object that associates a set operation and a membership criterion. Each of the filter links is associated with a particular filter view among a plurality of filter views. Each particular filter view comprises a graphical representation of a state of applying the membership criterion of the associated filter link to a subset of data resulting from filtering the starting set of data items according to zero or more preceding filter links.

Abstract: A method and system for the in-place evolution of XML schemas is disclosed. To automatically evolve an existing XML schema, a schema evolver receives both an existing XML schema and an XML document as input. The XML document indicates changes to be made to the existing XML schema. Based on the existing XML schema and the XML document, the schema evolver evolves the existing XML schema into a new XML schema that incorporates the changes indicated in the XML document. According to one aspect, the schema evolver generates one or more SQL statements based on the new XML schema. The SQL statements, when executed by a database server, cause the database server to evolve database structures that were based on the formerly existing XML schema so that the database structures conform to the new XML schema. This is accomplished “in place,” without copying the data in the database structures.

Abstract: A method for enhancing digital video recorder television advertising viewership provides a method wherein the first or last number of seconds of a commercial break are carefully authored to provide a “teaser” to entice the viewer to watch multiple commercials during the commercial break instead of skipping the commercial break using the fast forward or jump functions of the DVR. A bookending function displays an advertisement before and/or after a program that has been recorded on the DVR's storage device is played to the viewer. The viewer selects a recorded program from the DVR's storage device to playback. Before the program is played back, an advertisement is retrieved from the storage device and is displayed before the program is run. Another advertisement is retrieved and then played after the program is over.