[ATLAS-3056] update rdbms types to remove use of ownedRef/inverseRef constraints for relationships

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.2.0, 2.0.0
• Component/s: atlas-core
• Assignee: Madhan Neethiraj
• Reporter: Madhan Neethiraj
• Created: 22/Feb/19 02:36
• Updated: 26/Sep/19 00:39
• Resolved: 07/Mar/19 18:37

Description

RDBMS types use following attributes, with ownedRef/inverseRef constraints, to create relationships between entity-types:

• rdbms_instance.database, rdbms_db.instance
• rdbms_db.tables, rdbms_table.db
• rdbms_table.columns, rdbms_column.table
• rdbms_table.indexes, rdbms_index.table
• rdbms_table.foreign_keys, rdbms_foreign_key.table

These attributes are not necessary, as corresponding relationship-types (already present in the model) will automatically inject the same attributes as relationship-attributes.

Above change has several benefits, including:

• improved performance, due to use of only one edge between two related entities (compare this to 2 edges when ownedRef/inverseRef constraints are used)
• simper to update a container entity, as there is not need to provide all contained entities; same for contained entities as well