Pekka O Kostamaa

US Patent:

7792809, Sep 7, 2010

Filed:

Dec 8, 2006

Appl. No.:

11/608407

Inventors:

Pekka Kostamaa - Santa Monica CA, US
Bhashyam Ramesh - Secunderabad, IN

Assignee:

Tera data US, Inc. - Miamisburg OH

International Classification:

G06F 17/30

US Classification:

707705, 707802

Abstract:

There is provided a parallel database system. System includes a storage device for maintaining a plurality of rows. System also includes a plurality of access modules for accessing in parallel a respectively assigned one or more of rows. An interface receives data indicative of a table defined by a selection of rows. A processor is responsive to data for selectively designating table to be a single-module table. In this single module table, selection is collectively assigned to an owning one of modules , indicated by reference numeral.

US Patent:

7941424, May 10, 2011

Filed:

May 30, 2008

Appl. No.:

12/130060

Inventors:

Yu Xu - San Diego CA, US
Pekka Kostamaa - Santa Monica CA, US
Mark Sirek - San Diego CA, US

Assignee:

Teradata US, Inc. - Dayton OH

International Classification:

G06F 7/00
G06F 17/30

US Classification:

707714, 707770

Abstract:

A system, method, and computer-readable medium for dynamic detection and management of data skew in parallel join operations are provided. Receipt of an excessive number of redistributed rows by a processing module is detected thereby identifying the processing module as a hot processing module. Other processing modules then terminate redistribution of rows to the hot processing module and maintain rows of a skewed table of the join operation that would be redistributed to the hot processing module in a local spool. Rows of a smaller table that would be redistributed to the hot processing module are duplicated to each processing module involved in the join operation. Rows of tables that are to be redistributed by a processing module to any processing module excluding the hot processing module are redistributed accordingly and maintained locally by the processing module. The join operation is completed by merging results of local join data sets of each processing module.

US Patent:

8131711, Mar 6, 2012

Filed:

May 22, 2008

Appl. No.:

12/125299

Inventors:

Yu Xu - San Diego CA, US
Pekka Kostamaa - Santa Monica CA, US

Assignee:

Teradata Corporation - Dayton OH

International Classification:

G06F 17/30

US Classification:

707714, 707E17005

Abstract:

A system, method, and computer-readable medium that facilitate management of data skew during a parallel join operation are provided. Portions of tables involved in the join operation are distributed among a plurality of processing modules, and each of the processing modules is provided with a list of skewed values of a join column of a larger table involved in the join operation. Each of the processing modules scans the rows of the tables distributed to the processing modules and compares values of the join columns of both tables with the list of skewed values. Rows of the larger table having non-skewed values in the join column are redistributed, and rows of the larger table having skewed values in the join column are maintained locally at the processing modules. Rows of the smaller table that have non-skewed values in the join column are redistributed, and rows of the smaller table that have skewed values in the join column are duplicated among the processing modules.

US Patent:

20070130174, Jun 7, 2007

Filed:

Dec 7, 2005

Appl. No.:

11/295777

Inventors:

Bhashyam Ramesh - Secunderabad, IN
Pekka Kostamaa - Santa Monica CA, US

International Classification:

G06F 7/00

US Classification:

707100000

Abstract:

A method, computer system, and database system for automating a business rule in a database are disclosed. One or more database triggers associated with a business rule state machine are enabled and the business rule state machine is initialized.

US Patent:

20070143244, Jun 21, 2007

Filed:

Dec 8, 2006

Appl. No.:

11/608362

Inventors:

Pekka Kostamaa - Santa Monica CA, US
Bhashyam Ramesh - Secunderabad, IN

International Classification:

G06F 17/30

US Classification:

707001000

Abstract:

There is provided a database system including a source cluster, in the form of a source clique , for providing a clique shared spool file . This spool file is provided for consumption by a target module belonging to a target cluster, in the form of a target clique . A node interconnect receives of spool , and exports the spool for consumption by module

US Patent:

20070156724, Jul 5, 2007

Filed:

Dec 8, 2006

Appl. No.:

11/608278

Inventors:

Pekka Kostamaa - Santa Monica CA, US
Bhashyam Ramesh - Secunderabad, IN

International Classification:

G06F 7/00

US Classification:

707100000

Abstract:

FIG. illustrates a database system including a storage device . Device stores table data indicative of a plurality of rows . A source access module is assigned to access one of rows , this particular row being designated by reference numeral . Module is responsive to a command for reading row from device . Subsequently, module writes row to device in a packet accessible by a target module , this packet presently taking the form of a shared spool file