You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@atlas.apache.org by "Eckman, Barbara (JIRA)" <ji...@apache.org> on 2018/05/29 14:30:00 UTC
[jira] [Commented] (ATLAS-2709) RDBMS typedefs for Atlas
[ https://issues.apache.org/jira/browse/ATLAS-2709?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16493581#comment-16493581 ]
Eckman, Barbara commented on ATLAS-2709:
----------------------------------------
Hi Madhan,
Thanks for your quick action on my Jiras!
I would like to answer the question posed by David Radley on the review board about the rdbms typedefs. I don't see a way to respond, and even though I'm logged into Jira I'm not logged into the review page (and don't seem to have permission). How should I proceed?
Thanks, sorry if this is a dumb question.
Barbara
On 5/25/18, 7:50 PM, "Madhan Neethiraj (JIRA)" <ji...@apache.org> wrote:
[ https://issues.apache.org/jira/browse/ATLAS-2709?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Madhan Neethiraj reassigned ATLAS-2709:
---------------------------------------
Assignee: Barbara Eckman
> 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)
> 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)