Microsoft Technology Licensing, LLC

Samuel H Smith

Timothy T Brewer

Robert H Gerber

Kenneth R Robertson

Lora K McCambridge

Carl T Hellings

Anthony R Claflin

Daniel S Hoeger

Teresa L Kelsey

Paul E Henderson, Jr

James A Andrews

Eric W Hanson

James Robert Hamilton

Goetz Graefe

Balan Sethu Raman

Craig C Peeper

Cesar Alejandro Galindo-Legaria

Nigel Robin Ellis

Ajay Kalhan

Peter Alan Carlin

Vishal Kathuria

John F Ludeman

Shrinivas Ashwin

Yixue Zhu

Murali M Krishna

Harold R Berenson

Methods, systems, and computer-readable media are disclosed for transitioning clones and clone data access maps in response to node or media failure without blocking queries. In a system, a data request interface is configured to receive a query to access data at a storage device. Data management logic is configured to access clone state information of a plurality of clones including clones in a static state and clones in a transitory state. The data management logic is further configured to process the query to access the data according to the dynamic clone data access map, with functional correctness maintained.

Transitioning clone data maps and synchronizing with a data query

Mechanisms and techniques for database fragment cloning and management are provided. A database object, such as a table, rowset or index, is divided into fragments. Each fragment is cloned to create cloned fragments, which operationally are substantially identical to one another. One or more of the cloned fragments may be designated as a primary cloned fragment for performing database operations or as a secondary cloned fragment for serving as backup. Updates to each fragment are implemented on the primary cloned fragment and are then propagated from the primary cloned fragment to the corresponding secondary cloned fragments. A cloned fragment can go offline, becoming unavailable to be updated. When the cloned fragment returns online, the cloned fragment is refreshed with data included in the primary cloned fragment. While being refreshed, the cloned fragment may continue to be updated. The cloned fragment is eligible to be designated as a primary cloned fragment when the refreshing process has been completed.

Database fragment cloning and management

An auto-parameterization process transforms a database query into a parameterized basic query form by replacing any constant values in the query with parameters. The auto-parameterization process attempts to generate a safe execution plan from the basic query form if there is currently no such plan available. A safe execution plan is defined as an execution plan that is optimal over a range of values for the parameters. If a safe execution plan can be generated, it is passed for execution, along with the constant values that were present in the query. If a safe execution plan cannot be generated, the auto-parameterization process passes a specific execution plan for execution. The safe execution plan is cached either at the time it is created or at the time it is executed. The cache is searched each time a parameterized basic query plan is generated by the auto-parameterization process. The auto-parameterization process also evaluates the query before creating the corresponding parameterized basic query form to determine if it is likely that a safe execution plan can be generated for the query.

Auto-parameterization of database queries

A system determining an intended cursor location on the computer display screen and automatically repositions the cursor at the intended location. If the user selects a command that alters the contents of the display, such as opening a new window, the system analyzes the new screen display to determine whether there are user selectable options associated with the new screen display. The system determines if one of the user selectable options is a default option and automatically positions the cursor at the default option. If the new screen display is an application program, the system attempts to locate a user selectable option and repositions the cursor at the user selectable option. When the new window is closed, the system returns the cursor to the position it was at before the new window was opened. The system also predicts an intended location for a screen display that has not been altered, and automatically positions the cursor at the intended location. This feature can be selectively enabled to prevent the inadvertent repositioning of the cursor in the display.

System and method for computer cursor control

Growing community of inventors

Stanford, CA, United States of America

Samuel H Smith