[
https://issues.apache.org/jira/browse/ATLAS-2139?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16466907#comment-16466907
]
V Seth commented on ATLAS-2139:
-------------------------------
Thanks [~davidrad] [~grahamwallis] for the response.
[~mandy_chessell], here are the mappings from IGC to OMRS per your response:
1 IGC database maps to DeployedDatabaseSchema entity. ServerDeployment
relationship ties the DeployedDatabaseSchema entity with Host entity.
2a IGC schema is a DataSet entity in OMRS. Database thru DataContentForDataSet
relationship contains the schema.
2b For IGC schema a second entity and relationship will have to be created.
RelationalDBSchemaType entity and it links to DataSet(schema) via
AssetSchemaType relationship. This second entity identifies
the DataSet as a schema.
3a IGC table is a DataSet entity in OMRS. Dataset(Schema) thru
DataContentForDataSet relationship contains the table.
3b For IGC table a second entity and relationship will have to be created -
RelationalTableType entity and it links to DataSet(table) via AssetSchemaType
relationship. This second entity identifies the DataSet as a table.
3c For IGC table a third entity and relationship will have to be created -
RelationalTable entity and it links to RelationalTableType entity via
AttributeForSchema relationship
4a IGC column is a DataSet entity in OMRS. DataSet(Table) thru
DataContentForDataSet relationship contains the column.
4b For IGC column a second entity and relationship will have to be created -
RelationalColumnType entity and it links to DataSet(column) via AssetSchemaType
relationship. This second entity identified the DataSet as a column.
4c For IGC column a third entity and relationship will have to be created -
RelationalColumn entity and it links to RelationalColumnType entity via
SchemaAttributeType relationship.
Here are few questions I have:
1 Would Asset qualifiedName be the right place to put schema name, table name,
column name. i guess i can duplicate that name in SchemaType and
SchemaAttribute because there is nothing in IGC which differentiates.
2 Does the above mapping look correct to you?
3 I am concerned about the number of messages that will be generated to create
an entity. For a single schema entity, two entities and two relationships.
For a single table or column three entities and three relationships. Any
thoughts on this?
Thanks in advance.
> Map IGC meta model and Atlas OMRS open metadata types
> -----------------------------------------------------
>
> Key: ATLAS-2139
> URL: https://issues.apache.org/jira/browse/ATLAS-2139
> Project: Atlas
> Issue Type: Sub-task
> Reporter: Jerry He
> Assignee: Jerry He
> Priority: Major
> Attachments: Relational Tables and Columns.png
>
>
> Create the two-way mapping between IGC meta model and Atlas OMRS open
> metadata types.
> It is used by the IGC Event Mapper and IGC metadata repository connector.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
