Show TOC

New Data Model Features v15.1Locate this document in the navigation structure

PowerDesigner v15.1 includes new features for the Physical Data Model (PDM).

Sybase IQ - Information Lifecycle Management

Sybase IQ 15.0 provides new data placement capabilities and supports hierarchical storage management with relocation of less critical data to cheaper storage. PowerDesigner provides a simple modeling structure to cost effectively manage "aging" of data inside the data center from 1st tier high performance storage for frequently accessed data through 2nd tier near-line storage for data that is infrequently accessed to 3rd tier archive storage for data that must remain available for regulatory audits.

Documented in:
  • Data Modeling > DBMS Definition Reference > Sybase AS IQ
DBMS Triggers

DBMS triggers are now supported for Oracle and MS SQL Server. These triggers are not associated with any table or view, and fire on modifications to the database structure itself, such as the creation or dropping of a table, or events like startup, shutdown, login etc. DBMS triggers can use trigger templates and trigger template items, just like table and view triggers.

Documented in:
  • Data Modeling> Building Data Models > Triggers and Procedures > DBMS Triggers (PDM)
New or Enhanced DBMS Support

The following DBMS versions are added or enhanced:

  • Teradata v12
  • IBM DB2 UDB v9.5 Common Server
  • Sybase IQ v15.0 and v15.1
Documented in:
  • Data Modeling > DBMS Definition Reference