Gary H Roberts

US Patent:

8495034, Jul 23, 2013

Filed:

Jan 25, 2011

Appl. No.:

13/013651

Inventors:

Mark A. Hodgens - San Diego CA, US
Fred S. Kaufmann - Irvine CA, US
Donald R. Pederson - San Diego CA, US
Gary A. Roberts - Carlsbad CA, US

Assignee:

Teradata US, Inc. - Dayton OH

International Classification:

G06F 17/30

US Classification:

707693

Abstract:

A method, apparatus, and article of manufacture for accessing data in a computer system. Compression and decompression functions are associated with a column of the table, in order to perform compression of decimal, numeric or date data stored in the column when the data is inserted or updated in the table, and in order to perform decompression of the data stored in the column when the data is retrieved from the table. The compression function compresses and stores the data in a fixed-length compressed field in the column without a length value, and the fixed-length compressed field has a size that is determined by a range of values for the data stored in the fixed-length compressed field. The decompression function retrieves and decompresses the data from the fixed-length compressed field.

US Patent:

20120078860, Mar 29, 2012

Filed:

Nov 11, 2010

Appl. No.:

12/944185

Inventors:

Gary Roberts - Carlsbad CA, US
Venkata Ramakrishna Tirunagari - Hyderabad, IN
Harish Ramachandran - Bangalore, IN
Frederick Kaufmann - Irvine CA, US
Mark Hodgens - San Diego CA, US
Donald Pederson - San Diego CA, US

Assignee:

TERADATA US, INC. - Miamisburg OH

International Classification:

G06F 17/00

US Classification:

707693, 707E17007

Abstract:

A method, apparatus, and article of manufacture for accessing data in a computer system. One or more user-defined functions (UDFs) implementing a desired compression or decompression algorithm are created, wherein the UDFs are associated with one or more columns of a table when the table is created or altered, in order to perform compression or decompression of data stored in the associated columns, such that the data is compressed by the UDF implementing the desired compression algorithm when the data is inserted or updated in the table, and the data is decompressed by the UDF implementing the desired decompression algorithm when the data is retrieved from the table.

US Patent:

20130173564, Jul 4, 2013

Filed:

Mar 8, 2012

Appl. No.:

13/414768

Inventors:

Gary Roberts - Carlsbad CA, US
Guilian Wang - San Diego CA, US
Frederick Kaufmann - Irvine CA, US

International Classification:

G06F 7/00

US Classification:

707693, 707E17002

Abstract:

A system and method for compressing and decompressing multiple types of character data. The system and method employ multiple encoding tables, each designed for encoding a subset of character data, such as numeric data, uppercase letters, lowercase letters, Latin, or UNICODE data, to perform compressions and decompression of character data. The character encoding tables are smaller than the size of the alphabet of the uncompressed strings.