公开(公告)号：CA2425048C

公开(公告)日：2008-06-03

申请号：CA2425048

申请日：2003-04-08

Applicant: IBM CANADA

Inventor： LIMOGES JOSEPH SERGE ,  EVANS DOMINIQUE J ,  GODINEZ MARIO S

IPC: G06F16/10

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

公开(公告)号：CA2382714A1

公开(公告)日：2003-10-19

申请号：CA2382714

申请日：2002-04-19

Applicant: IBM CANADA

Inventor： VINCENT TIMOTHY J ,  SCHIEFER KLAUS BERNHARD ,  O'CONNELL WILLIAM T ,  LIMOGES JOSEPH SERGE ,  BEGG ROBERT A ,  EVANS DOMINIQUE J

IPC: G06F17/30

Abstract: A method, computer program product and computing device for promoting reuse ofpreviously generated access plans in a relational DBMS 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 comprising 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 wi ll improve DBMS efficiency. If a substitution is unsound, the DBMS may obtain and optimize (i.e. select an access plan for) 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. Improvements in DBMS efficiency may thus be achieved .

公开(公告)号：CA2374290A1

公开(公告)日：2003-09-01

申请号：CA2374290

申请日：2002-03-01

Applicant: IBM CANADA

Inventor： STOCKER RUSSELL M ,  HURAS MATTHEW A ,  LIMOGES JOSEPH SERGE ,  EVANS DOMINIQUE J

IPC: G06F9/00 ,  G06F9/46 ,  G06F13/00 ,  G06F15/16

Abstract: A spin counter updating system and method for updating spin counters for spi n latches in a multiprocessor computing system. The updating system includes main spin counter value storage for storing spin counter data correlated to at least one spin counter value, and a master agent. The master agent includes agent spin counter value storage for storing spin counter data correlated to at least one spin counter value; and a spin counter signal handler, wherein the spin counter signal handler is adapted to read spin counter data from the main spin counter valu e storage and to store the read spin counter data to the agent spin counter value storage.

公开(公告)号：CA2425048A1

公开(公告)日：2004-10-08

申请号：CA2425048

申请日：2003-04-08

Applicant: IBM CANADA

Inventor： LIMOGES JOSEPH SERGE ,  GODINEZ MARIO S ,  EVANS DOMINIQUE J

IPC: G06F16/10 ,  G06F17/30 ,  G06F13/14

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

公开(公告)号：CA2381739A1

公开(公告)日：2003-10-15

申请号：CA2381739

申请日：2002-04-15

Applicant: IBM CANADA

Inventor： LIMOGES JOSEPH SERGE ,  WILDING MARK F ,  SCHORMANN STEPHEN A ,  HURAS MATTHEW A ,  EVANS DOMINIQUE J ,  HAGEN DALE J

IPC: G06F9/46 ,  G06F12/00 ,  G06F12/14 ,  G06F13/14 ,  G06F13/22 ,  G06F15/163

Abstract: An adaptive spin latch system is provided for use in a multiprocessor comput er 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 tim e 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.