Patents by Inventor Selvaganapathy Ayyamperumal

Selvaganapathy Ayyamperumal 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).

  • Offline validation of data in a database system for foreign key constraints
    Patent number: 8065323
    Abstract: An aspect of the present invention performs offline validation of data in database system for foreign key constraints. In an embodiment, a foreign key constraint defined for a database system is identified and an SQL script designed to verify whether data values stored in a foreign key column of a detail table is present in a primary key column of a master table (corresponding to the identified foreign key constraint), is generated. The SQL script is executed to determine whether the data stored in the database system satisfies the identified foreign key constraint.
    Type: Grant
    Filed: February 23, 2009
    Date of Patent: November 22, 2011
    Assignee: Oracle International Corporation
    Inventors: Satish Kumar Sallakonda, Mary E. G Bear, Selvaganapathy Ayyamperumal
  • Offline Validation of Data in a Database System for Foreign Key Constraints
    Publication number: 20100228764
    Abstract: An aspect of the present invention performs offline validation of data in database system for foreign key constraints. In an embodiment, a foreign key constraint defined for a database system is identified and an SQL script designed to verify whether data values stored in a foreign key column of a detail table is present in a primary key column of a master table (corresponding to the identified foreign key constraint), is generated. The SQL script is executed to determine whether the data stored in the database system satisfies the identified foreign key constraint.
    Type: Application
    Filed: February 23, 2009
    Publication date: September 9, 2010
    Applicant: Oracle International Corporation
    Inventors: Satish Kumar Sallakonda, Mary E.G Bear, Selvaganapathy Ayyamperumal