Abstract: Join-queried entities are selectively linked in an entity-relationship model of the database by defining a pre-join tag in the entity-relationship model of the database and selectively providing the pre-join tag between join-queried entities in the entity-relationship model of the database. Frequently join-queried entities in the entity-relationship model of the database may be identified, and a pre-join tag may be provided between the frequently join-queried entities. A non-relational database may be generated from the entity-relationship model by creating merged entities in the non-relational database based on the pre-join tags. A relational database may be generated from the entity-relationship model by selectively creating merged entities in the relational database based on the pre-join tags.

Abstract: A database modeling computer system defines a first entity, a second entity and a relationship between them according to an entity-relationship data model for a database. The database modeling computer system associates a first data volume attribute value with the first entity and a second data volume attribute value with the second entity. A database creation system selectively merges the first entity and the second entity into a common table, in response to the first and second data volume attribute values. Related systems, methods and computer program products are described.