Patents by Inventor Edward Gust BRANISH, II

Edward Gust BRANISH, II 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).

  • Optimization of aggregate queries in database management systems using an early out join when processing min and max functions
    Patent number: 9524317
    Abstract: A method, computer program product, and system for optimizing aggregate queries are provided. The method, computer program product, and system provide for receiving an aggregate query comprising a GROUP BY operation and an aggregate function, creating an access plan for executing the aggregate query, the access plan including a join between an outer relation and an inner relation, and designating the join included in the access plan as an early out join.
    Type: Grant
    Filed: August 24, 2007
    Date of Patent: December 20, 2016
    Assignee: International Business Machines Corporation
    Inventors: Edward Gust Branish, II, John F. Hornibrook, Dieu Quang La, Calisto Paul Zuzarte
  • High performance secure data access in a parallel processing system
    Patent number: 8930382
    Abstract: A mechanism is provided for secure data access in a parallel processing system. A database having two tables is provided. A subset of the tables' primary key attributes is considered sensitive. A first user is authorized to access the primary key's sensitive attribute in an unmasked format, while a second user is authorized to access same data in a masked format. Two security tables are generated having a plurality of entries mapping the values of the primary key attribute in the unmasked format to the values of the primary key attribute in the masked format. A security view is generated joining the two security tables. The security view grants the first user access to the values of the primary key's sensitive attribute in the unmasked format only and grants the second user access to the values of the primary key's sensitive attribute in the masked format only.
    Type: Grant
    Filed: October 10, 2012
    Date of Patent: January 6, 2015
    Assignee: International Business Machines Corporation
    Inventors: Edward Gust Branish, II, Veerabhadra Chinnam, George Richard Hughes, Jr., James Sun
  • HIGH PERFORMANCE SECURE DATA ACCESS IN A PARALLEL PROCESSING SYSTEM
    Publication number: 20140101129
    Abstract: A mechanism is provided for secure data access in a parallel processing system. A database having two tables is provided. A subset of the tables' primary key attributes is considered sensitive. A first user is authorized to access the primary key's sensitive attribute in an unmasked format, while a second user is authorized to access same data in a masked format. Two security tables are generated having a plurality of entries mapping the values of the primary key attribute in the unmasked format to the values of the primary key attribute in the masked format. A security view is generated joining the two security tables. The security view grants the first user access to the values of the primary key's sensitive attribute in the unmasked format only and grants the second user access to the values of the primary key's sensitive attribute in the masked format only.
    Type: Application
    Filed: October 10, 2012
    Publication date: April 10, 2014
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Edward Gust Branish, II, Veerabhadra Chinnam, George Richard Hughes, JR., James Sun
  • AGGREGATE QUERY OPTIMIZATION
    Publication number: 20090055350
    Abstract: A method, computer program product, and system for optimizing aggregate queries are provided. The method, computer program product, and system provide for receiving an aggregate query comprising a GROUP BY operation and an aggregate function, creating an access plan for executing the aggregate query, the access plan including a join between an outer relation and an inner relation, and designating the join included in the access plan as an early out join.
    Type: Application
    Filed: August 24, 2007
    Publication date: February 26, 2009
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Edward Gust BRANISH, II, John F. Hornibrook, Dieu Quang La, Calisto Paul Zuzarte