[
https://issues.apache.org/jira/browse/ATLAS-2709?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Madhan Neethiraj updated ATLAS-2709:
------------------------------------
Attachment: ATLAS-2709.patch
> 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
> Priority: Critical
> 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)
