atlas-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "V Seth (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (ATLAS-2139) Map IGC meta model and Atlas OMRS open metadata types
Date Tue, 08 May 2018 05:45:00 GMT

    [ 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)

Mime
View raw message