FOREIGN KEY CONSTRAINT ENFORCEMENT ACROSS DATABASE INSTANCES

    公开(公告)号:US20210182271A1

    公开(公告)日:2021-06-17

    申请号:US16713370

    申请日:2019-12-13

    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.

Patent Agency Ranking