Patents by Inventor Robert G. Dillon, JR.

Robert G. Dillon, 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).

  • Foreign key constraint enforcement across database instances
    Patent number: 11176120
    Abstract: Disclosed techniques relate to enforcing table dependencies for a database schema when tables are maintained by separate database instances. In some embodiments, a database system generates configuration data based on foreign key constraints for multiple database tables. In some embodiments, in response to a request from an application server to access data, the database system accesses the configuration data (where the configuration data specifies a relationship between a field of a child table and a field of a parent table and at least a portion of the parent table is stored in a different database instance than the child table) and determines whether the request satisfies the specified relationship. In some embodiments, enforcing dependencies at an intermediate orchestration layer maintained by the database systems allows applications to submit requests without considering table dependencies.
    Type: Grant
    Filed: December 13, 2019
    Date of Patent: November 16, 2021
    Assignee: salesforce.com, inc.
    Inventors: Vijaya S. Pula, Kathiravan Sengodan, Robert G. Dillon, Jr.
  • FOREIGN KEY CONSTRAINT ENFORCEMENT ACROSS DATABASE INSTANCES
    Publication number: 20210182271
    Abstract: Disclosed techniques relate to enforcing table dependencies for a database schema when tables are maintained by separate database instances. In some embodiments, a database system generates configuration data based on foreign key constraints for multiple database tables. In some embodiments, in response to a request from an application server to access data, the database system accesses the configuration data (where the configuration data specifies a relationship between a field of a child table and a field of a parent table and at least a portion of the parent table is stored in a different database instance than the child table) and determines whether the request satisfies the specified relationship. In some embodiments, enforcing dependencies at an intermediate orchestration layer maintained by the database systems allows applications to submit requests without considering table dependencies.
    Type: Application
    Filed: December 13, 2019
    Publication date: June 17, 2021
    Inventors: Vijaya S. Pula, Kathiravan Sengodan, Robert G. Dillon, JR.