Paul J Andersen

US Patent:

7562195, Jul 14, 2009

Filed:

Nov 29, 2006

Appl. No.:

11/564339

Inventors:

Peter Frazier - Princeton NJ, US
Paul Andersen - San Diego CA, US
Gary Boggs - San Diego CA, US
Criselda Carrillo - San Diego CA, US
Donn Holtzman - San Diego CA, US
John Mark Morris - San Diego CA, US
P. Keith Muller - San Diego CA, US
Ronald Yellin - Poway CA, US

Assignee:

Teradata US, Inc. - Miamisburg OH

International Classification:

G06F 12/00

US Classification:

711151, 711 4, 711112, 700 28, 717151, 718104

Abstract:

A system calculates the optimal allocation of two or more resources provided by a resource provider to a task within a computer system from a plurality of possible allocations. In doing so, the system calculates the total volume of an N-dimensional cube, where N is the number of resources provided by the resource provider, representing the respective amounts of resources available to be allocated. The system also calculates the average volume of the N-1 dimensional shapes forming the sides of the N-dimensional cube. The system then calculates, at least partly from the ratio of the total volume to the average volume, the balance resulting from the allocation of resources represented by the N-dimensional cube. The system then calculates the imbalance resulting from the allocation of resources at least partly from the balance and determines the smallest imbalance as the optimal allocation of resources.

US Patent:

7730171, Jun 1, 2010

Filed:

May 8, 2007

Appl. No.:

11/745475

Inventors:

Peter Frazier - Princeton NJ, US
Paul Andersen - San Diego CA, US
Gary Boggs - San Diego CA, US
Criselda Carrillo - San Diego CA, US
Donn Holtzman - San Diego CA, US
John Mark Morris - San Diego CA, US
P. Keith Muller - San Diego CA, US
Paul Rubio - San Diego CA, US

Assignee:

Teradata US, Inc. - Miamisburg OH

International Classification:

G06F 15/177
G06F 15/173

US Classification:

709223, 709220, 709224, 709226

Abstract:

The subject matter herein relates to database management systems and, more particularly, to decoupled logical and physical data storage within a database management system. Various embodiments provide systems, methods, and software that separate physical storage from logical storage of data. These embodiments include a mapping of logical storage to physical storage to allow data to be moved within the physical storage to increase database responsiveness.

US Patent:

7822930, Oct 26, 2010

Filed:

Jul 13, 2009

Appl. No.:

12/502028

Inventors:

Peter Frazier - Princeton NJ, US
Paul Andersen - San Diego CA, US
Gary Boggs - San Diego CA, US
Criselda Carrillo - San Diego CA, US
Donn Holtzman - San Diego CA, US
John Mark Morris - San Diego CA, US
P. Keith Muller - San Diego CA, US
Ronald Yellin - Poway CA, US

Assignee:

Teradata US, Inc. - Miamisburg OH

International Classification:

G06F 12/00

US Classification:

711151, 711 4, 711112, 700 28, 717151, 718104

Abstract:

A system calculates the optimal allocation of two or more resources provided by a resource provider to a task within a computer system from a plurality of possible allocations. In doing so, the system calculates the total volume of an N-dimensional cube, where N is the number of resources provided by the resource provider, representing the respective amounts of resources available to be allocated. The system also calculates the average volume of the N−1 dimensional shapes forming the sides of the N-dimensional cube. The system then calculates, at least partly from the ratio of the total volume to the average volume, the balance resulting from the allocation of resources represented by the N-dimensional cube. The system then calculates the imbalance resulting from the allocation of resources at least partly from the balance and determines the smallest imbalance as the optimal allocation of resources.

US Patent:

8041802, Oct 18, 2011

Filed:

Nov 30, 2009

Appl. No.:

12/627716

Inventors:

Peter Frazier - Princeton NJ, US
Paul Andersen - San Diego CA, US
Gary Boggs - San Diego CA, US
Criselda Carrillo - San Diego CA, US
Donn Holtzman - San Diego CA, US
John Mark Morris - San Diego CA, US
P. Keith Muller - San Diego CA, US
Paul Rubio - San Diego CA, US

Assignee:

Teradata US, Inc. - Dayton OH

International Classification:

G06F 15/173
G06F 15/177

US Classification:

709223, 709220, 709224, 709226

Abstract:

The subject matter herein relates to database management systems and, more particularly, to decoupled logical and physical data storage within a database management system. Various embodiments provide systems, methods, and software that separate physical storage of data from logical storage of data. These embodiments include a mapping of logical storage to physical storage to allow data to be moved within the physical storage to increase database responsiveness.

US Patent:

8375193, Feb 12, 2013

Filed:

May 27, 2009

Appl. No.:

12/472414

Inventors:

Criselda Carrillo - San Diego CA, US
Paul Rubio - San Diego CA, US
Paul Andersen - San Diego CA, US
Donn Holtzman - San Diego CA, US

Assignee:

Teradata US, Inc. - Dayton OH

International Classification:

G06F 12/00

US Classification:

711173, 711170, 711E12001

Abstract:

The frequency with which data is accessed within the system may be periodically monitored and a corresponding access frequency quantifier assigned to the data is updated accordingly. The data access frequency quantifier may be associated with a storage device zone speed quality rating. The association between data access frequency quantifiers and the storage device zone speed quality ratings may be made in a hierarchical association such that quantifiable differentials may be ascertained between a particular access frequency quantifier and a storage device zone speed quality rating. In this manner, when no storage zone having a speed quality rating that is associated with data having a particular access frequency quantifier is available for storage of the data, a storage zone having a speed quality rating more proximate the speed quality rating associated with the access frequency quantifier may be identified for migration.

US Patent:

20070067669, Mar 22, 2007

Filed:

Sep 8, 2006

Appl. No.:

11/530144

Inventors:

John Morris - San Diego CA, US
Paul Andersen - San Diego CA, US
Gary Boggs - San Diego CA, US
Criselda Carrillo - San Diego CA, US
John Catozzi - San Diego CA, US
Peter Frazier - Princeton NJ, US

International Classification:

G06F 11/00

US Classification:

714006000

Abstract:

A technique for use in identifying a failing storage device from a plurality of such storage devices involves the use of an inconsistency map. This inconsistency map is maintained by selecting one or more protected objects and identifying the storage devices on which the protected objects are stored. Copies of the protected objects on the identified storage devices are compared. On detecting a mismatch between copies of one of the protected objects, details are stored in an inconsistency map of the mismatched protected object and details of the storage devices on which the mismatched protected object is stored.