Patents by Inventor George R. Hughes, JR.

George R. Hughes, JR. 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).

  • Secure data access using SQL query rewrites
    Patent number: 9069987
    Abstract: A mechanism is provided for secure data access in a data 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 views are generated granting the second user access to the primary key's sensitive attribute values of both tables in the masked format. The masked format value is generated from an unmasked format value using a reversible function. A join operation between the two security views is performed by optimizing a query statement corresponding to the join operation.
    Type: Grant
    Filed: June 21, 2013
    Date of Patent: June 30, 2015
    Assignee: International Business Machines Corporation
    Inventors: Edward G. Branish, II, Veerabhadra R. Chinnam, George R. Hughes, Jr., James C. Sun
  • SECURE DATA ACCESS USING SQL QUERY REWRITES
    Publication number: 20140380051
    Abstract: A mechanism is provided for secure data access in a data 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 views are generated granting the second user access to the primary key's sensitive attribute values of both tables in the masked format. The masked format value is generated from an unmasked format value using a reversible function. A join operation between the two security views is performed by optimizing a query statement corresponding to the join operation.
    Type: Application
    Filed: June 21, 2013
    Publication date: December 25, 2014
    Applicant: International Business Machines Corporation
    Inventors: Edward G. Branish, II, Veerabhadra R. Chinnam, George R. Hughes, JR., James C. Sun