atlas-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Madhan Neethiraj (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (ATLAS-2709) RDBMS typedefs for Atlas
Date Tue, 29 May 2018 14:32:00 GMT

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

Madhan Neethiraj commented on ATLAS-2709:
-----------------------------------------

[~barbara] - please create an account in review board to respond to review comments.

> RDBMS typedefs for Atlas
> ------------------------
>
>                 Key: ATLAS-2709
>                 URL: https://issues.apache.org/jira/browse/ATLAS-2709
>             Project: Atlas
>          Issue Type: New Feature
>          Components:  atlas-core
>            Reporter: Barbara Eckman
>            Assignee: Barbara Eckman
>            Priority: Critical
>             Fix For: 1.0.0
>
>         Attachments: ATLAS-2709.patch, rdbms_typedefs.tar
>
>
> Currently the base types in Atlas do not include RDMBS objects. It would be nice to
add generic typedefs for the basic objects found in virtually any RDBMS.  From this, one
can subclass types specific to Oracle, MS SQL Server, etc if desired.  For example:
>  
>  * rdbms_instance represents the host platform that the database is running on. It supports:
>  ** rdbms_type (eg Oracle, mysql) 
>  ** hostname
>  ** port
>  ** protocol
>  ** platform
>  ** contact_info for the instance owner
>  ** array of databases (schemas) associated with the instance
>  
>  * rdbms_db represents a database (schema) running on an rdbms_instance. It supports:
>  ** inverse reference to the rdbms_instance
>  ** contact_info for the database owner
>  ** prodOrOther: a self-documenting attribute name representing whether the database
is production, development, staging, etc
>  ** array of tables in the database
>  
>  * rdbms_table represents a table in a database (schema). It supports:
>  ** inverse reference to the rdbms_db
>  ** time of creation
>  ** comment
>  ** type (e.g., table or view)
>  ** contact_info for the table owner
>  ** array of columns in the table
>  ** array of indexes on the table
>  ** array of foreign keys defined on the table
>  
>  * rdbms_column represents a column in a table. It supports:
>  ** data_type of the column
>  ** length
>  ** default_value
>  ** comment
>  ** inverse reference to the rdbms_table
>  ** isNullable boolean
>  ** isPrimaryKey boolean
>  * rdbms_index represents an index on a set of columns in a table. It supports:
>  ** inverse reference to the rdbms_table
>  ** index_type (e.g., "NORMAL", "BITMAP", "DOMAIN")
>  ** isUnique boolean
>  ** ordered list of columns in the index
>  ** comment
>  
>  * rdbms_foreign_key represents a foreign key relationship between columns in source
and referenced tables.  It supports:
>  ** inverse reference to the source table
>  ** key_columns: ordered list of columns in the source table
>  ** references_table: table that the foreign key references
>  ** references_columns: ordered list of columns in the referenced table
>  ** comment
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message