Abstract:
A self-healing database engine and optimizer framework support automatically responding to execution errors to allow continued execution of a query plan. Upon encountering an execution error, the database engine automatically initiates a rebuilding of the query plan and executes the rebuilt execution plan. If an error is encountered in the rebuilt query plan then the query implementation methods are analyzed. If a query function is identified for which an alternative implementation method is available, then this alternative implementation method is substituted to create a new query plan. The new query plan is then executed to determine if the error is corrected.
Abstract:
A compiler has the capability to selectively compile individual portions of a compilable code module for optimum execution performance or for serviceability. In one aspect, individual portions, such as procedures (being less than the entire module) are selectively optimized. In another aspect, debug activity data is used for determining whether or not to optimize compiled code. It is optionally possible to support one or more levels of partial selective optimization.
Abstract:
A method and apparatus for group billing purchasers of transmitted programming events is provided. In one embodiment, a subscriber group includes two or more individual subscribers who receive programming from a programming provider. The individual subscribers periodically elect to view a program provided via the program provider. The program is provided on a pay-per-view basis, meaning that the program provider requires a sum of money to be paid in order to view the program. The sum of money is determined according to the number of viewers in a single subscriber group. In one embodiment, the subscribers interact during a program via a network connection.
Abstract:
A database engine and optimizer framework support the use of transitive closure to assist in rewriting GROUP BY and ORDER BY clauses to reduce the number of referenced tables (optimally to a single table if possible) and to free the join order selected for the query plan. The SQL parser and optimizer, by performing transitive closure on the selection, or search, conditions is able to identify which fields referenced by the ORDER BY and GROUP BY clauses can be replaced with equivalent fields to improve the performance of the query. In one instance, the fields are replaced so that the ORDER BY or GROUP BY clause references only a single table. If more than one such possible ORDER BY or GROUP BY clause exists, then the optimizer selects from among the different possible clauses to select the one that provides the best performing join order.
Abstract:
A method of providing rebroadcast programming includes encoding a rebroadcast program, specifying a preferred play time, and providing a broadcast that fits the preferred play time. The encoding of the rebroadcast program can use a replay plan which prioritizes portions of the rebroadcast. A priority can be assigned to commercials which have been made to be shortened or dropped, or an alternative commercial substituted, depending on time limitations. A rebroadcast packaging and playlist are provided. The specifying a preferred play time can be done by one of the following ways: specifying the preferred play time in response to a specific user request; specifying the preferred play time based on a user profile; specifying the preferred play time automatically by another program; connecting a replay timing to other events, wherein the other events includes setting an automatic pause when phone calls come in, lengthening a rebroadcast on certain days, and shortening a rebroadcast based on location of an automobile; providing a radio/television player which has functions of pause and replay which can be selected by the user to deduct time dynamically during the rebroadcast and which performs at least one of: replaying the broadcast; reacting to the need to pause/rewind; respecifying the adjusted time; playing unlistened to material at a later time; and displaying a list of unlistened/unviewed segments. A default play time for the rebroadcast program is used if no time is otherwise specified.
Abstract:
The invention, in an embodiment, relates to optimizing database performance by taking advantage of sleepy drives. The invention analyzes queries to indexes based on usage frequency, and determines whether to access an index stored on a sleepy drive, or perform an alternate access plan based on green optimization. Furthermore, the invention transfers data, such as, for example, indexes, files, data areas, journals, and statistics, between active and sleepy drives based on usage frequency. In another embodiment, the invention provides an improved sleepy drive which optimizes energy savings by a graduated degree based on a speed setting. In yet another embodiment, the invention controls when read-write heads are unloaded from disks to reduce drag and power consumption by a disk drive.
Abstract:
A method, apparatus, system, and signal-bearing medium that, in an embodiment, receive a request for an address watch breakpoint to a variable, determine that the variable is referenced via a basing pointer expression, and monitor for initialization of the basing pointer prior to monitor for a change to the contents of the variable that is pointed to by the basing pointer expression. In an embodiment, the basing pointer expression is implemented as an instruction that uses an indirect addressing mode. In an embodiment, the basing pointer is determined to be uninitialized, and thus needs monitoring for initialization, by detecting an error that results from adding an offset for the variable to the contents of the basing pointer, or by detecting an error when the result of the adding is used as a pointer. In an embodiment, the basing pointer expression comprises a plurality of basing pointers, each of which is monitored for initialization in turn. In this way, the user is freed from the difficulty involved in attempting to determine where and if the basing pointer is set prior to monitoring for a modification to a variable that is pointed to by the basing pointer.
Abstract:
A method and system for controlling an automatic transmission is disclosed. The method and system include obtaining positioning data using a global positioning satellite (GPS) and monitoring the automatic transmission to obtain transmission data. The method and system also include learning whether performance of the automatic transmission can be improved utilizing the positioning data and the transmission data. Moreover, the method and system include adjusting a shift threshold for the positioning data for the automatic transmission if it is determined that the performance of the automatic transmission can be improved.
Abstract:
A method, apparatus, system, and signal-bearing medium that, in an embodiment, receive a close command directed to a window, and determine whether the close command was received within a close threshold time of the display of the window. If the close command was received within the threshold time, in various embodiments, a close dialog is displayed, the window is faded, the window is shrunk, or a status message is displayed indicating that the window is closing. If a cancel command is received within a cancel-close threshold, the closing of the window is canceled. If the number of times the cancel command has been received for the window exceeds a cancel threshold, then in various embodiments, the close threshold is increased, magnification is recommended, a sound option is recommended, or speech recognition is recommended. In an embodiment, in response to a close command directed to a window, a determination is made whether the number of times the window has been resized is greater than a resize threshold. If the window has been resized greater than the resize threshold, in various embodiments, the cancel dialog is displayed, the window is faded, the window is shrunk, or a status message is displayed indicating that the window is closing. In another embodiment, if input to a window has been received within an input threshold time since the window was opened, then a confirmation message is displayed.