PowerDesigner 12'5

1
PowerDesigner 12.5

• by Dejan Sunderic
• www.trigonblue.com
• www.tsql.ca

2
Agenda

• Whats new
• Overview of ERD modeling
• Other models

3
What's New

• Microsoft SQL Server 2005 support includes
• database mirroring
• Service Broker
• Analysis Services 2000/2005 plug-in
• Visual Studio 2005 plug-in
• Importing ERwin 7 models

4
Whats New 2

• Spell checking (object names, descriptions)
• Test Data Generation
• Database Size Estimate
• Impact Analysis
• Scripting

5
Models

• Requirements Model (RQM)
• Business Process Model (BPM)
• Data Flow diagrams
• Conceptual Data Model (CDM)
• Physical Data Model (PDM)
• Information Liquidity Model (ILM)
• Object-Oriented Model (OOM)
• .NET and .NET CF (VB/C)
• Java
• Unit Tests
• Web services (DB2, Sybase)
• XML Model (XSM)

6
Supported DB objects

• Tables, views, synonym
• SPs, UDFs, triggers
• Domains, FKs
• XML (types, indexes, schemas)
• Full-text indexes
• Encryption (s/a keys, certificates)

• SQL CLR
• Users, permissions
• Databases,filegroups
• Endpoints
• Broker (svcs, contrs, msg, queues, evnts)

7
Reverse Engineering

• Scripts-based
• Direct access
• ADO.NET
• JDBC
• ODBC
• Native drivers (new)

8
Procedure and trigger development

• Definition
• Dependencies(calculated)
• CRUDGenerationtemplates
• DML triggers
• Before
• After

9
ERD

• demo

10
Impact Analysis

• FK
• References
• Shortcuts
• Other diagrams
• Diagrams of other type

11
Denormalization

• Horizontal Partitioning (i.e. by date)
• Vertical Partitioning (super/sub type)
• Table collapsing (eliminate joins)
• Column Denormalization

12
Horizontal Partitioning
13
Vertical Partitioning
14
Table collapsing (eliminate joins)
15
Column Denormalization
16
Documenting

• Comments
• Notes
• Annotations

• Reports
• RTF
• HTML
• Templates
• Editable

17
MultiDimensional Diagrams

• Relational modeling
• Dims (hierarchies)
• Facts
• Relational Mapping
• OLAP
• extraction scripts
• Data text files

18
Generate Extraction Scripts

• Relational-Relational Mapping
• Relational-MultiDimensional Mapping

19
Visual Studio 2005 Plugin

• PowerDesigner Modeling Project
• Integration with Team System
• Link Work Items and Requirements (model)

20
Compare Model

• demo

21
Scripting OLE Automation

• Usage
• Repetitive commands
• Add col to all tables
• Change property of all cols
• New menu options
• Reporting
• Repository
• Workspace
• Db Generation
• Reverse Engineering

• Scripting
• VBScript
• C
• Java
• OLE Automation
• VB
• VBA

22
Working w/Repository

• Extract (check out) and merge w/local
• Consolidating (check in)
• on model level ?
• Permissions
• Querying
• Comparing

23
Linking and Generating models
24
Requirements Model (RQM)

• Three types of views
• Requirements document views numbered lists of
  requirements with a common set of properties
• Traceability matrix views grids indicating the
  links between requirements and design objects
  (objects from other types of models), external
  files, and/or other requirements
• User allocation matrix views grids indicating
  the links between requirements and users or
  groups who must meet these requirements during a
  development process

25
RQM Requirements Document View
26
RQM User Allocation Matrix
27
RQM Word Import Export Add-in

• Synch RQM and Word doc.
• 2 way

28
Information Liquidity Model (ETL EII)

• Transformation process
• Data transformation diagram
• Transformation control flow diagram
• Based on
• Replication Server (Sybase)
• Mobility Server (Sybase)

29
Transformation process
30
Data transformation diagram
31
Documentation

• Books
• Videos

32
Trial Version

• 15-day trial
• www.sybase.com
• DejanS at hotmail.com