Patents by Inventor Steven Sit

Steven Sit 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).

  • Patent number: 7895191
    Abstract: A system, method, and program for improving the performance for SQL queries. Multidimensional metadata associated with a cube model metadata object is obtained. One or more summary tables to be built are automatically identified based on the obtained multidimensional metadata. One or more indexes to create are automatically identified based on the obtained multidimensional metadata.
    Type: Grant
    Filed: April 9, 2003
    Date of Patent: February 22, 2011
    Assignee: International Business Machines Corporation
    Inventors: Nathan Gevaerd Colossi, Daniel Martin DeKimpe, Jason Dere, Steven Sit
  • Patent number: 7401321
    Abstract: An apparatus for processing data relating to software defects operates within an on-line analytical processing environment that includes an on-line analytical processing presentation tool (60). An on-line analytical processing cube model builder (32) builds a plurality of interrelated tables (22) with on-line analytical processing cube model metadata (30). The cube model (30) is configured to be processed by the associated on-line analytical processing presentation tool (60). A data extraction tool (36) communicates with a defect tracking database (10, 12) containing said data relating to software defects. The data extraction tool (36) extracts said data from the defect tracking database (10, 12), transforms the extracted data into the software defect entries, and loads the software defect entries into the tables (22).
    Type: Grant
    Filed: April 14, 2003
    Date of Patent: July 15, 2008
    Assignee: International Business Machines Corporation
    Inventors: Steven Sit, Daniel DeKimpe, Tamuyen Phung
  • Publication number: 20040215626
    Abstract: Disclosed is a system, method, and program for improving the performance for SQL queries. Multidimensional metadata associated with a cube model metadata object is obtained. One or more summary tables to be built are automatically identified based on the obtained multidimensional metadata. One or more indexes to create are automatically identified based on the obtained multidimensional metadata.
    Type: Application
    Filed: April 9, 2003
    Publication date: October 28, 2004
    Applicant: International Business Machines Corporation
    Inventors: Nathan Gevaerd Colossi, Daniel Martin DeKimpe, Jason Dere, Steven Sit
  • Publication number: 20040205727
    Abstract: An apparatus for processing data relating to software defects operates within an on-line analytical processing environment that includes an on-line analytical processing presentation tool (60). An on-line analytical processing cube model builder (32) builds a plurality of interrelated tables (22) with on-line analytical processing cube model metadata (30). The cube model (30) is configured to be processed by the associated on-line analytical processing presentation tool (60). A data extraction tool (36) communicates with a defect tracking database (10, 12) containing said data relating to software defects. The data extraction tool (36) extracts said data from the defect tracking database (10, 12), transforms the extracted data into the software defect entries, and loads the software defect entries into the tables (22).
    Type: Application
    Filed: April 14, 2003
    Publication date: October 14, 2004
    Applicant: International Business Machines Corporation
    Inventors: Steven Sit, Daniel DeKimpe, Tamuyen Phung