James S Carlson

US Patent:

8005820, Aug 23, 2011

Filed:

Sep 27, 2006

Appl. No.:

11/535670

Inventors:

James Carlson - Rancho Palos Verdes CA, US
Grace Au - Rancho Palos Verdes CA, US
Bhashyam Ramesh - Secunderabad, IN
Haiyan Chen - Yorktown Heights NY, US

Assignee:

Teradata US, Inc. - Dayton OH

International Classification:

G06F 17/30
G06F 7/00

US Classification:

707714

Abstract:

A SQL query that includes an IN-List is optimized by utilizing an array insert to insert the IN-List into a spool and piggybacking IN-List rows into a join step.

US Patent:

60092645, Dec 28, 1999

Filed:

Aug 28, 1997

Appl. No.:

8/919971

Inventors:

John Earl Merritt - Torrance CA
Moo Yong Kim - LaPalma CA
James Ronald Carlson - Manhattan Beach CA

Assignee:

NCR Corporation - Dayton OH

International Classification:

G06F 928
G06F 9445

US Classification:

39550049

Abstract:

A method, apparatus, and article of manufacture for coordinating a plurality of sub-tasks performed by a group of nodes of a parallel processor computer system. An application subdivides a function into the plurality of sub-tasks and assigns the sub-tasks to a group of participating nodes. A message is transmitted by the application to the group of participating nodes, wherein the message spawns one or more threads on each participating node and the threads are encapsulated by a virtual processor to perform a desired one or more of the sub-tasks. A channel object is created in all participating nodes and a coordinator node in response to the transmitted message, wherein the channel object in the coordinator node includes a data element identifying the group of participating nodes performing the sub-tasks. Each of the virtual processors in the participating nodes are monitored for completion of their assigned sub-tasks and a message is transmitted from the participating node to the coordinator node when all of the virtual processors in the participating node have completed their assigned sub-tasks. The coordinator node modifies the data element in the channel object in response to the transmitted message and indicates completion of the sub-tasks to the application when the data element in the channel object is modified to a specific value.

US Patent:

20190163753, May 30, 2019

Filed:

Nov 29, 2017

Appl. No.:

15/825314

Inventors:

- Dayton OH, US
James Ronald Carlson - Rancho Palos Verdes CA, US

International Classification:

G06F 17/30
G06F 11/30
G06F 11/34

Abstract:

A database table is defined as a load isolated table (LDI table) that supports a current table version number, multiple row versions, and special load protocols. An isolated loading statement on the LDI table is identified in a Data Manipulation Language (DML), causing the table to be placed in an isolated loading state associated with an incremented new value of the table's current version number. A designated group of DML operations in one or more sessions are then used to load/modify rows in the table, and affected rows are marked with the uncommitted new version. Read-committed queries supported for LDIs ignore the uncommitted rows during an isolated load, seeing only previously committed versions of the rows. When an end isolated loading on the table is identified, the table's version is updated to the new incremented value, causing the newly loaded/modified rows to be recognized as committed by subsequent read-committed queries.