Ellen M Nolan

US Patent:

8229966, Jul 24, 2012

Filed:

Sep 7, 2007

Appl. No.:

11/851417

Inventors:

Ellen Nolan - San Diego CA, US

Assignee:

Teradata US, Inc. - Dayton OH

International Classification:

G06F 17/30

US Classification:

707797

Abstract:

A tree-structured database is collapsed into a two-column table. The two-column table includes a characteristic key value for a given leaf node in the first column and the system identification (SID) relating to the characteristic key value in the second column and also identifying the node that leads to the characteristic key value. Data is presented by coupling the characteristic key value with a transaction table. A query that is formulated in an infocube may be translated to a relational data base query, collapsed, and reformulated into an infocube result set, or vice versa.

US Patent:

20090024594, Jan 22, 2009

Filed:

Jul 17, 2007

Appl. No.:

11/778709

Inventors:

Ellen Nolan - San Diego CA, US
Michael Eschwege - San Diego CA, US

International Classification:

G06F 7/00

US Classification:

707 4, 707 3, 707E17014

Abstract:

Techniques for integrating disparate data access mechanisms are provided. A user attempts data access against an infocube and its data access mechanism. Transparently, that access attempt is translated into a format recognized and processed by a relational database access mechanism to produce results. The results are then translated from a relational database format back to an infocube format and presented to the user within the infocube's data access mechanism.