Abstract: A method, apparatus, and non-transitory computer-readable storage medium for presenting information identifying relationships in a database. Entity labels identifying a plurality of different entity types modeled in the database are presented in a user interface. Input identifying one or more selected entity types is received. A plurality of entity instance relationship sets is accessed. Each entity instance relationship set identifies a relationship between entity instances of at least two different entity types. Attribute data of the entity instances identified in only those entity instance relationship sets that identify a relationship between entity instances of the one or more selected entity types are presented, such that attribute data for each unique relationship between entity instances of the one or more selected entity types are presented only once.

Abstract: A method, apparatus, and non-transitory computer-readable storage medium for generating and presenting information identifying relationships between entity instances in a database that has a plurality of entity structures.

Abstract: A method, apparatus, and non-transitory computer-readable storage medium for generating and presenting information identifying relationships between entity instances in a database that has a plurality of entity structures.

Abstract: A method, apparatus, and non-transitory computer-readable storage medium for presenting information identifying relationships in a database. Entity labels identifying a plurality of different entity types modeled in the database are presented in a user interface. Input identifying one or more selected entity types is received. A plurality of entity instance relationship sets is accessed. Each entity instance relationship set identifies a relationship between entity instances of at least two different entity types. Attribute data of the entity instances identified in only those entity instance relationship sets that identify a relationship between entity instances of the one or more selected entity types are presented, such that attribute data for each unique relationship between entity instances of the one or more selected entity types are presented only once.

Abstract: A method and apparatus for identifying relationships among entity instances of a plurality of entities in a database. A plurality of entity reference relationship structures is accessed. Each entity reference relationship structure includes at least a pair of entity instance identifiers that identifies a relationship between entity instances of a pair of entity structures of a plurality of entity structures. All complete graphs among all subsets of the plurality of entity structures are identified. Each complete graph includes at least one edge corresponding to an entity reference relationship structure, and two vertices connected by the at least one edge that correspond to entity structures between which the entity reference relationship structure establishes a relationship. For each complete graph, all matched sets of pairs of entity instance identifiers are determined. The entity instance identifiers in each matched set are stored in association with each other in an entity relationship structure.

Abstract: A method and apparatus for generating a data structure. A plurality of entity reference relationship structures is accessed. Each entity reference relationship structure establishes a relationship between a different pair of entity structures of a plurality of entity structures. Each path from a first vertex to a second vertex that corresponds to a second entity structure is determined. For each path, all coupled sets of pairs of entity instance identifiers, wherein each coupled set comprises a pair of entity instance identifiers from each entity reference relationship structure corresponding to the path are identified. For each coupled set, a first entity instance identifier in the each coupled set that refers to the first entity structure and a second entity instance identifier in the each coupled set that refers to the second entity structure are stored in association with one another in a new entity reference relationship structure.

Abstract: A method, apparatus, and non-transitory computer-readable storage medium for presenting information identifying relationships in a database. Entity labels identifying a plurality of different entity types modeled in the database are presented in a user interface. Input identifying one or more selected entity types is received. A plurality of entity instance relationship sets is accessed. Each entity instance relationship set identifies a relationship between entity instances of at least two different entity types. Attribute data of the entity instances identified in only those entity instance relationship sets that identify a relationship between entity instances of the one or more selected entity types are presented, such that attribute data for each unique relationship between entity instances of the one or more selected entity types are presented only once.

Abstract: A method and apparatus for identifying relationships among entity instances of a plurality of entities in a database. A plurality of entity reference relationship structures is accessed. Each entity reference relationship structure includes at least a pair of entity instance identifiers that identifies a relationship between entity instances of a pair of entity structures of a plurality of entity structures. All complete graphs among all subsets of the plurality of entity structures are identified. Each complete graph includes at least one edge corresponding to an entity reference relationship structure, and two vertices connected by the at least one edge that correspond to entity structures between which the entity reference relationship structure establishes a relationship. For each complete graph, all matched sets of pairs of entity instance identifiers are determined. The entity instance identifiers in each matched set are stored in association with each other in an entity relationship structure.

Abstract: A method and apparatus for generating a data structure. A plurality of entity reference relationship structures is accessed. Each entity reference relationship structure establishes a relationship between a different pair of entity structures of a plurality of entity structures. Each path from a first vertex to a second vertex that corresponds to a second entity structure is determined. For each path, all coupled sets of pairs of entity instance identifiers, wherein each coupled set comprises a pair of entity instance identifiers from each entity reference relationship structure corresponding to the path are identified. For each coupled set, a first entity instance identifier in the each coupled set that refers to the first entity structure and a second entity instance identifier in the each coupled set that refers to the second entity structure are stored in association with one another in a new entity reference relationship structure.

Abstract: The present invention is directed to software for creating a database structure. Specifically, the software creates multiple tables to represent an entity in a database. The software processes information input by the user and generates the following three types of tables to represent each entity: (1) a static table containing all the static attributes plus the identifying attribute; (2) a semi-dynamic table containing all the semi-dynamic attributes and the identifying attribute; and (3) a set of dynamic tables for every group of dynamic attributes that have the same record frequency, each of the tables containing the dynamic attributes and the identifying attribute. The software of the present invention also generates intelligent reports on the data stored in the database.