Patents by Inventor John K. Metzger
John K. Metzger has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 7921130Abstract: 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.Type: GrantFiled: October 15, 2008Date of Patent: April 5, 2011Assignee: Netezza CorporationInventors: Foster D. Hinshaw, John K. Metzger, Barry M. Zane
-
Publication number: 20090132475Abstract: 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.Type: ApplicationFiled: October 15, 2008Publication date: May 21, 2009Inventors: Foster D. Hinshaw, John K. Metzger, Barry M. Zane
-
Patent number: 7529752Abstract: 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.Type: GrantFiled: September 18, 2003Date of Patent: May 5, 2009Assignee: Netezza CorporationInventors: Foster D. Hinshaw, Sanjay G. Dixit, John K. Metzger, David L. Meyers, Venkannababu Tammisetti, Premanand Yerabothu, Barry M. Zane
-
Patent number: 7464106Abstract: 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.Type: GrantFiled: January 13, 2006Date of Patent: December 9, 2008Assignee: Netezza CorporationInventors: Foster D. Hinshaw, John K. Metzger, Barry M. Zane
-
Patent number: 7337351Abstract: 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.Type: GrantFiled: July 6, 2004Date of Patent: February 26, 2008Assignee: Netezza CorporationInventors: Barry M. Zane, Foster D. Hinshaw, Philip J. MacDonald, John K. Metzger
-
Patent number: 7089448Abstract: 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.Type: GrantFiled: September 18, 2003Date of Patent: August 8, 2006Assignee: Netezza CorporationInventors: Foster D. Hinshaw, Vincent F. Femia, Craig S. Harris, John K. Metzger, David L. Meyers, Barry M. Zane
-
Patent number: 7010521Abstract: 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.Type: GrantFiled: May 13, 2002Date of Patent: March 7, 2006Assignee: Netezza CorporationInventors: Foster D. Hinshaw, John K. Metzger, Barry M. Zane
-
Patent number: 6973452Abstract: A large information space is divided into many smaller information extents. These extents are annotated with statistics about the information they contain. When a search for information includes a restriction based on value, the desired value ranges can be compared to the value ranges of each extent. If the desired value range lies outside the range of the extent, then the extent cannot hold the desired value and does not need to be included in the search.Type: GrantFiled: May 18, 2004Date of Patent: December 6, 2005Assignee: Netezza CorporationInventors: John K. Metzger, Barry M. Zane, Foster D. Hinshaw
-
Publication number: 20040128442Abstract: 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.Type: ApplicationFiled: September 18, 2003Publication date: July 1, 2004Applicant: Netezza CorporationInventors: Foster D. Hinshaw, Vincent F. Femia, Craig S. Harris, John K. Metzger, David L. Meyers, Barry M. Zane
-
Publication number: 20040117037Abstract: 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.Type: ApplicationFiled: September 18, 2003Publication date: June 17, 2004Applicant: Netezza CorporationInventors: Foster D. Hinshaw, Sanjay G. Dixit, John K. Metzger, David L. Meyers, Venkannababu Tammisetti, Premanand Yerabothu, Barry M. Zane
-
Publication number: 20030212668Abstract: 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.Type: ApplicationFiled: May 13, 2002Publication date: November 13, 2003Inventors: Foster D. Hinshaw, John K. Metzger, Barry M. Zane