International Business Machines Corporation

Dominique Jeremy Evans

Joseph Serge Limoges

Matthew Albert Huras

Mark Francis Wilding

Michael Henry D'Amico

Thomas Bradley Allen

Timothy Jon Vincent

William T O'Connell

Brand Lee Hunt

Brian Eugene Macy

Robert Alan Begg

Klaus B Schiefer

Dale J Hagen

Stephen A Schormann

Mario S Godinez

A method, article and apparatus for calculating a measure of similarity between names is disclosed. Generally, name elements from an inbound name may be matched to name elements in a candidate matching name. A measure of similarity for the inbound name and candidate matching name may be calculated based on the number of matching name elements, an inbound name word count, a candidate name word count, and the number of transpositions that occur in matching name elements with one another.

Method, apparatus and article for assigning a similarity measure to names

A method, computer program product and computing device for promoting reuse of previously generated access plans are disclosed. SQL statements containing literals are amended so as to substitute a parameter marker for each literal. Amended statements are provided to the DBMS along with parameters including the substituted literals and a substitution indicator indicating that the substitution has been performed. The DBMS assesses the soundness of the substitutions that are performed. Soundness may be measured in terms of the semantic correctness of the amended statement and the likelihood that the literal substitution will improve DBMS efficiency. If a substitution is unsound, the DBMS may obtain and optimize the original version of the amended SQL statement. Otherwise, the amended statement is optimized. Advantageously, SQL statements originally differing only in the value of one or more literals may become functionally equivalent, and the reuse of cached, previously generated access plans is thus promoted.

Substituting parameter markers for literals in database query language statement to promote reuse of previously generated access plans

A method and database management system for connecting to a database involves reusing connections for operations performed in sequence, rather than creating independent connections for each requested client connection. An application server, or layer, receives the requests and parses them to identify modes of operation. Separate connections are created to support each mode of operation so that the database receives the operations and requests in a format that is sorted by type, at a rate that can be adjusted to match capacity of the database.

System and method for accessing resources in a database

An adaptive spin latch system is provided for use in a multiprocessor computer system. The spin latch system includes a run queue, a spin latch module and a wait queue. The run queue is adapted to store agent index data correlated to at least one agent in run mode. The spin latch module is adapted to put the at least one agent into sleep mode for a period of time correlated to a number of agents awaiting access to a resource. The wait queue is adapted to store agent index data correlated to the at least one agent in sleep mode. A method of regulating access by agents to a resource in a multiprocessor computing system is also provided.

Adaptive spin latches

Growing community of inventors

North York, Canada

Dominique Jeremy Evans