[jira] [Comment Edited] (ATLAS-2139) Map IGC meta model and Atlas OMRS open metadata types

["V Seth (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ATLAS-2139?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16466907#comment-16466907 ] 

V Seth edited comment on ATLAS-2139 at 5/17/18 9:54 PM:
--------------------------------------------------------

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 an Asset 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 Asset(column) via AssetSchemaType relationship.  This second entity identified the Asset 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.


was (Author: sethv):
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)