John S Metzger

US Patent:

7010521, Mar 7, 2006

Filed:

May 13, 2002

Appl. No.:

10/145571

Inventors:

Foster D. Hinshaw - Somerville MA, US
John K. Metzger - Westborough MA, US
Barry M. Zane - Wayland MA, US

Assignee:

Netezza Corporation - Framingham MA

International Classification:

G06F 17/30

US Classification:

707 3, 707 2

Abstract:

A system from processing database queries allows for cost and locale based distribution for execution of database queries. The database queries are executed on execution engines that provide flexible configuration and overlapping functionality. The system reduces various costs, including elapsed time, required to perform database queries. The system provides processing of a database query using a database catalog comprising database table locality information, record locality information and execution engine information. A query optimizer receives the query and accesses the database catalog to create a query execution plan comprising locality-based database operations. A central database operation processor providing a first execution engine executes the query execution plan by performing at least a portion of the locality-based database operations and distributing at least a portion of the locality-based database operations as a subplan. A second database operation processor providing a second execution engine executes the subplan received from the central database operation processor. At least one of the database operations can be executed on either the first execution engine or the second execution engine.

US Patent:

7089448, Aug 8, 2006

Filed:

Sep 18, 2003

Appl. No.:

10/667127

Inventors:

Foster D. Hinshaw - Somerville MA, US
Vincent F. Femia - Northboro MA, US
Craig S. Harris - Acton MA, US
John K. Metzger - Westborough MA, US
David L. Meyers - Shrewsbury MA, US
Barry M. Zane - Wayland MA, US

Assignee:

Netezza Corporation - Framingham MA

International Classification:

G06F 11/16

US Classification:

714 6, 714 5, 714 7, 714 8, 714 42, 711114

Abstract:

A disk is segmented into a first data segment and a secondary data segment. The secondary data segment stores a logical mirror of the first data segment of another disk. Fast access to data stored on the disk is provided by partitioning the disk such that the first data segment includes the fast tracks of the disk and the secondary data segment includes the slow tracks of the disk and forwarding all data requests to the first data segment. Upon detecting a failure, the logical mirror of data stored in the first data segment of the failed disk is accessible from the secondary data segment of a non-failed disk. The first data segment can be rebuilt quickly on another disk from the logical mirror stored in the secondary data segment.

US Patent:

7337351, Feb 26, 2008

Filed:

Jul 6, 2004

Appl. No.:

10/885519

Inventors:

Barry M. Zane - Wayland MA, US
Foster D. Hinshaw - Somerville MA, US
Philip J. MacDonald - Waltham MA, US
John K. Metzger - Westborough MA, US

Assignee:

Netezza Corporation - Framingham MA

International Classification:

G06F 11/00

US Classification:

714 6

Abstract:

A disk is segmented into a first data segment and a secondary data segment. The secondary data segment stores a logical mirror of the first data segment of another disk. Upon detecting a failure, the logical mirror of data stored in the first data segment of the failed disk is accessible from the secondary data segment of a non-failed disk. The first data segment can be rebuilt quickly on another disk from the logical mirror stored in the secondary data segment. During regenerating, accesses to the first data segment on the disk containing the logical mirror are handled by its own logical mirror, which is not involved in the regenerating process.

US Patent:

7464106, Dec 9, 2008

Filed:

Jan 13, 2006

Appl. No.:

11/332704

Inventors:

Foster D. Hinshaw - Somerville MA, US
John K. Metzger - Westborough MA, US
Barry M. Zane - Wayland MA, US

Assignee:

Netezza Corporation - Framingham MA

International Classification:

G06F 17/00

US Classification:

707102, 707100, 707101

Abstract:

A system from processing database queries allows for cost and locale based distribution for execution of database queries. The database queries are executed on execution engines that provide flexible configuration and overlapping functionality. The system reduces various costs, including elapsed time, required to perform database queries. The system provides processing of a database query using a database catalog comprising database table locality information, record locality information and execution engine information. A query optimizer receives the query and accesses the database catalog to create a query execution plan comprising locality-based database operations. A central database operation processor providing a first execution engine executes the query execution plan by performing at least a portion of the locality-based database operations and distributing at least a portion of the locality-based database operations as a subplan. A second database operation processor providing a second execution engine executes the subplan received from the central database operation processor. At least one of the database operations can be executed on either the first execution engine or the second execution engine.

US Patent:

7529752, May 5, 2009

Filed:

Sep 18, 2003

Appl. No.:

10/666729

Inventors:

Foster D. Hinshaw - Somerville MA, US
Sanjay G. Dixit - Southborough MA, US
John K. Metzger - Westborough MA, US
David L. Meyers - Shrewsbury MA, US
Venkannababu Tammisetti - Shrewsbury MA, US
Premanand Yerabothu - Southborough MA, US
Barry M. Zane - Wayland MA, US

Assignee:

Netezza Corporation - Marlborough MA

International Classification:

G06F 7/00
G06F 17/30

US Classification:

707 10, 707103 X, 700 2, 709213

Abstract:

An asymmetric data record processor and method includes host computers and Job processing units (JPU's) coupled together on a network. Each host computer and JPU forms a node on the network. A plurality of software operators allow each node to process streams of records. For each operator in a given sequence within nodes and across nodes, output of the operator is input to a respective succeeding operator. Data processing follows a logical data flow based on readiness of a record. As soon as a record is ready it is passed for processing from one part to a next part in the logical data flow. The flow of records during data processing is substantially continuous and of a streaming fashion.

US Patent:

7921130, Apr 5, 2011

Filed:

Oct 15, 2008

Appl. No.:

12/288160

Inventors:

Foster D. Hinshaw - Somerville MA, US
John K. Metzger - Westborough MA, US
Barry M. Zane - Wayland MA, US

Assignee:

Netezza Corporation - Framingham MA

International Classification:

G06F 17/00

US Classification:

707769, 707763, 707766, 707771

Abstract:

A system and method from processing database queries allows for cost and locale based distribution for execution of database queries. The database queries are executed on execution engines that provide flexible configuration and overlapping functionality. The system reduces various costs, including elapsed time, required to perform database queries. The method provides processing of a database query using a database catalog comprising database table locality information, record locality information and execution engine information. A query optimizer receives the query and accesses the catalog to create a query execution plan comprising locality-based database operations. A central database operation processor providing a first execution engine executes the query execution plan by performing at least a portion of the locality-based database operations and distributing at least a portion of the locality-based database operations as a subplan. A second database operation processor providing a second execution engine executes the subplan received from the central processor.