Patents by Inventor Gregory R Wiley

Gregory R Wiley 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).

  • Sharing a single instance of a user defined type
    Patent number: 9116959
    Abstract: Methods, systems and apparatus for implementing behavior of a user defined type (UDT) in a database by providing a data table with multiple rows and generating a UDT table having only a single row. An instance of a UDT is created and stored in the single row of the UDT table. A query having a Cartesian product is implemented to join the UDT table and data table for invoking behavior of the UDT and generating a resultant data table without increasing cardinality thereof. The single instance of the UDT may be shared amongst several users of the database as a result of all required persisted objects of the UDT residing within only a single row of the UDT table.
    Type: Grant
    Filed: April 27, 2010
    Date of Patent: August 25, 2015
    Assignee: International Business Machines Corporation
    Inventors: Andrea C. Martinez, Charles Matula, David H. Starke, Gregory R. Wiley
  • SHARING A SINGLE INSTANCE OF A USER DEFINED TYPE
    Publication number: 20100211598
    Abstract: Methods, systems and apparatus for implementing behavior of a user defined type (UDT) in a database by providing a data table with multiple rows and generating a UDT table having only a single row. An instance of a UDT is created and stored in the single row of the UDT table. A query having a Cartesian product is implemented to join the UDT table and data table for invoking behavior of the UDT and generating a resultant data table without increasing cardinality thereof. The single instance of the UDT may be shared amongst several users of the database as a result of all required persisted objects of the UDT residing within only a single row of the UDT table.
    Type: Application
    Filed: April 27, 2010
    Publication date: August 19, 2010
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Andrea C. Martinez, Charles Matula, David H. Starke, Gregory R. Wiley
  • Sharing a single instance of a user defined type
    Patent number: 7779037
    Abstract: Methods, systems and apparatus for implementing behavior of a user defined type (UDT) in a database by providing a data table with multiple rows and generating a UDT table having only a single row. An instance of a UDT is created and stored in the single row of the UDT table. A query having a Cartesian product is implemented to join the UDT table and data table for invoking behavior of the UDT and generating a resultant data table without increasing cardinality thereof. The single instance of the UDT may be shared amongst several users of the database as a result of all required persisted objects of the UDT residing within only a single row of the UDT table.
    Type: Grant
    Filed: March 27, 2007
    Date of Patent: August 17, 2010
    Assignee: International Business Machines Corporation
    Inventors: Andrea C Martinez, Charles Matula, David H Starke, Gregory R Wiley
  • SHARING A SINGLE INSTANCE OF A USER DEFINED TYPE
    Publication number: 20080243911
    Abstract: Methods, systems and apparatus for implementing behavior of a user defined type (UDT) in a database by providing a data table with multiple rows and generating a UDT table having only a single row. An instance of a UDT is created and stored in the single row of the UDT table. A query having a Cartesian product is implemented to join the UDT table and data table for invoking behavior of the UDT and generating a resultant data table without increasing cardinality thereof. The single instance of the UDT may be shared amongst several users of the database as a result of all required persisted objects of the UDT residing within only a single row of the UDT table.
    Type: Application
    Filed: March 27, 2007
    Publication date: October 2, 2008
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Andrea C Martinez, Charles Matula, David H Starke, Gregory R Wiley