Systems and methods for managing foreign key constraints

Abstract

Systems and methods consistent with the invention may include generating, via a processor, an entity relationship model to indicate a plurality of types of relationships between the entities, determining relationships between the database tables corresponding to the entities by using the entity relationship model, wherein the database tables are stored in a computer memory device, generating a graph based on the entity relationship model, generating sets of database elements representing the entities and corresponding data objects stored in the database tables, wherein the element sets are generated based on the generated graph, assigning ordering numbers to the database element sets and database elements included in the database element sets and executing the query transaction by using the data objects in an order based on the ordering numbers.

Description

BACKGROUND

[0001] 1. Relevant Field

[0002] Systems and methods consistent with the present invention generally relate to the management of database objects and / or entries. More particularly, systems and methods consistent with the invention relate to the managing data objects by resolving foreign key constraints to process database queries.

[0003] 2. Background Information

[0004] Businesses and other organizations generate and / or receive a variety of entries, data items and electronic information (broadly referred to hereafter as “data objects”) during the course of their operation. These data objects may belong to different classes and may be generated and / or received from various locations in different regions and / or countries. To organize and manage operations of the organization, data objects may be stored in storage devices located in a variety of locations. These storage devices may include relational databases that store the data objects as tables of data, where the tables may consis...

Images