Index
Exclude Null Keys
New option to Include/Exclude Null Keys
Business Time Period
Business Time Period added in Entity Properties dialog, tab General.
Dictionary Type
Array Type
New Type available for Dictionary Types - Array Type.
Inline Length parameter
Inline Length parameter for BLOB, CLOB and DBCLOB user data types/dictionary types.
Attribute
New data types Timestamp(x), Timestamp with time zone, Timestamp(x) with time zone.
Key
Column Names Business Time Without Overlaps box added in Key Properties dialog, tab Attributes, and Index Properties dialog, tab Items.
Trigger
Function
Checkbox SECURED in Trigger Properties dialog and Function Properties dialog for function types External Scalar and Table and SQL.
Available Data Providers are:
- Native Connection
- Connection via ODBC
Native Connection:
Connection via ODBC:
Greenplum database is based on PosgtreSQL 8.2, which defines basic features and structure.
Supported features - SQL/DDL script generation, reverse engineering, HTML/RTF/PDF reports, change scripting, verification.
Permissions can be set for entities, views and functions.
Entity
General tab
Storage Parameters tab
Table Partitions tab
Define partitions/subpartitions textually.
During reverse engineering, sub-tables of partitioned tables are filtered (the tables created because of partitioned tables). The behavior can be influenced in reverse engineering options, in checkbox Load Sub-Tables of Partitioned Tables.
Attribute
Array Type - Select the Is Array Type checkbox to enable the Array Dimension box.
Dictionary Type/Domain
Array Type - Select the Is Array Type checkbox to enable the Array Dimension box.
Function
If C is selected in Language combo box, C Language Parameters tab appears.
If internal is selected in Language combo box, Internal Language Parameters tab appears.
Foreign Key (Referential Integrity)
NO FUNCTIONALITY - Foreign key constraints are not supported in Greenplum database. They can be created but are not enforced.
Trigger
Triggers can be created but the functionality is considerably limited.
Other supported objects:
- Aggregate
- Sequences
- Rewrite Rules
- External Tables
Objects not supported in Toad Data Modeler:
- Resource Queue
- (Trusted) Protocol
- Filespace
Aggregate
Sequence
Rewrite Rules
External Tables
Object specifics for Greenplum db not present in PosgtreSQL 8.2.
- Set External Table to be Readable/Writable
Writable External Table - enables the Distribution Policy tab
- Set External Table to be Web or Regular type External Table
Web External Table - set Execute OS Command, Segment Instances, Parameter of Segment Instances
- Error Table Name - allows full table name, e.g. "schema1"."tablename"
