Patents by Inventor Ellen Nolan

Ellen Nolan 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).

  • System to generate a structured query language query by using a dimensional hierarchy
    Patent number: 8229966
    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.
    Type: Grant
    Filed: September 7, 2007
    Date of Patent: July 24, 2012
    Assignee: Teradata US, Inc.
    Inventor: Ellen Nolan
  • Techniques for integrating disparate data access mechanisms
    Patent number: 8108335
    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.
    Type: Grant
    Filed: July 17, 2007
    Date of Patent: January 31, 2012
    Assignee: Teradata US, Inc.
    Inventors: Ellen Nolan, Michael Eschwege
  • SYSTEM TO GENERATE A STRUCTURED QUERY LANGUAGE QUERY BY USING A DIMENSIONAL HIERARCHY
    Publication number: 20090070359
    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.
    Type: Application
    Filed: September 7, 2007
    Publication date: March 12, 2009
    Inventor: Ellen Nolan
  • TECHNIQUES FOR INTEGRATING DISPARATE DATA ACCESS MECHANISMS
    Publication number: 20090024594
    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.
    Type: Application
    Filed: July 17, 2007
    Publication date: January 22, 2009
    Inventors: Ellen Nolan, Michael Eschwege