Details
-
New Feature
-
Status: Resolved
-
Critical
-
Resolution: Fixed
-
None
-
None
Description
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