Jason O Lowe

US Patent:

20090019029, Jan 15, 2009

Filed:

Jul 11, 2007

Appl. No.:

11/775980

Inventors:

James Joseph Tommaney - Allen TX, US
Robert J. Dempsey - Plano TX, US
Phillilp R. Figg - The Colony TX, US
Patrick M. LeBlane - McKinney TX, US
Jason B. Lowe - Dallas TX, US
John D. Weber - Plano TX, US
Weidong Zhou - Trophy Club TX, US

International Classification:

G06F 17/30

US Classification:

707 5, 707E17002, 707E17017

Abstract:

A method and system for performing a scan operation on a table of a column-oriented database is described. One embodiment receives a database query that references a particular column in a table, the particular column being horizontally partitioned into at least one extent, the at least one extent including at least one data block; consults, for each extent in the particular column for which associated metadata is available, the metadata associated with that extent to determine whether that extent is required to process the scan operation; acquires, for each extent in the particular column for which associated metadata is not available, metadata associated with that extent and uses the acquired metadata associated with that extent to determine whether that extent is required to process the scan operation; and performs the scan operation on only those extents in the particular column determined to be required to process the scan operation.

US Patent:

20090019103, Jan 15, 2009

Filed:

Jul 11, 2007

Appl. No.:

11/775976

Inventors:

James Joseph Tommaney - Allen TX, US
Robert J. Dempsey - Plano TX, US
Phillip R. Figg - The Colony TX, US
Patrick M. LeBlanc - McKinney TX, US
Jason B. Lowe - Dallas TX, US
John D. Weber - Plano TX, US
Weidong Zhou - Trophy Club TX, US

International Classification:

G06F 15/16
G06F 17/30
G06F 7/06

US Classification:

709201, 707 3, 707E17015, 707E17032

Abstract:

A method and system for processing a database query is described. One embodiment is a scalable, reconfigurable database query processing system comprising one or more director, user, and performance modules in a configuration that includes shared-nothing behavior of the modules and the distributed processing of primitives for resolving a database query in accordance with a column-oriented database architecture.

Address:

6401 Castle Rock Cir, McKinney, TX 75071

VIN:

1FMFU19507LA67009

Make:

FORD

Model:

EXPEDITION

Year:

2007