Patents by Inventor Nigel Anthony Campbell

Nigel Anthony Campbell 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).

  • Method of and Apparatus for Extraction and Analysis of Macro Operations within Query Language Statement
    Publication number: 20100153430
    Abstract: A method receives a query containing at least a statement, and analyzes the statement to determine a query structure of elements forming the statement. The text of the statement is formatted to reflect the query structure. The formatted text is replaced with an equivalent tree of logical blocs representing the statement in a higher level. The representation of one or more of the logical blocks is shortened. A data flow tree of macro operation nodes is generated based on the logical blocks for presentation to a user.
    Type: Application
    Filed: December 11, 2008
    Publication date: June 17, 2010
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Vladimir Mordvinov, Soufiane Azizi, Nigel Anthony Campbell
  • Method of managing slowly changing dimensions
    Patent number: 6847973
    Abstract: A method of managing slowly changing dimensions in a dimensional database, such as a dimensional data mart, is disclosed. The method consists of providing a dimension template for each dimension undergoing slow changes, which template assigns a behavior to each column of the dimension table. When a row of dimensional data is to be delivered to the dimension table, the table is searched for a record having the key value of the row of data to be delivered. If such a record exists and if any attributes of the row to be delivered have their values changed compared with the existing record, the table is updated according to the behavior type assigned to these attributes in the dimension template, either by overwriting the existing record with the record to be delivered or by creating a new record or records.
    Type: Grant
    Filed: June 18, 2001
    Date of Patent: January 25, 2005
    Assignee: Cognos Incorporated
    Inventors: David Antony John Griffin, Peter James Lawrence Griffiths, Stephen Hugh Judges, Nigel Anthony Campbell, Michael David Roberts
  • Method of managing slowly changing dimensions
    Publication number: 20020038306
    Abstract: A method of managing slowly changing dimensions in a dimensional database, such as a dimensional data mart, is disclosed. The method consists of providing a dimension template for each dimension undergoing slow changes, which template assigns a behavior to each column of the dimension table. When a row of dimensional data is to be delivered to the dimension table, the table is searched for a record having the key value of the row of data to be delivered. If such a record exists and if any attributes of the row to be delivered have their values changed compared with the existing record, the table is updated according to the behavior type assigned to these attributes in the dimension template, either by overwriting the existing record with the record to be delivered or by creating a new record or records.
    Type: Application
    Filed: June 18, 2001
    Publication date: March 28, 2002
    Inventors: David Antony John Griffin, Peter James Lawrence Griffiths, Stephen Hugh Judges, Nigel Anthony Campbell, Michael David Roberts