UML China AllinOne Design Tool Power Designer 10

UML China 讲座 All-in-One Design Tool Power. Designer 10. 0与模型驱动开发 • 王晓昀 Power. Designer 首席架构师 • xwang@sybase. com • 2004年 3月25日

议程 § § § 我的�介 为什么要使用模型驱动开发 具 Power. Designer 简介 Power. Designer 与业务流程建模 Power. Designer 与对象建模 Power. Designer 与数据建模 Power. Designer 与XML建模 Power. Designer 的共同功能 Power. Designer 10. 0 的新功能介紹 Power. Designer 与模型驱动开发 Power. Designer 的路线图 2

为什么要使用模型驱动开发 具? Would You Build a House Without a Blueprint? • The Architect will do the first high level drawings to validate the concept with its client He will then make a detailed plan for the Builders • The Builders will take this blueprint and optimize it based on technical constraints 5

开发软件的问题 • How to improve application quality, reduce development time and ease maintenance? • How to model business-driven application? • How to design applications in such way that they are easy to change? • Different techniques (E/R, UML, BP Modeling) have forced corporations to buy different tools, raising communication and co-ordination issues • Lack of central place to store and manage models 6

模型驱动开发 具 • To improve application quality, reduce development time and ease maintenance – Use Modeling tool to analyze and design the applications – Use Modeling tool to generate the specification – Use code generators to generate the database, the application code – Use repository to store models and manage versions • To model business-driven application and allow applications to be easilly changed – Use Business Process Model, UML and Data Model together 7

Power. Designer 简介

Power. Designer的历史 Old Releases, focus on E/R modeling and extensions 1989 (v 1) 1990 1991 1992 v 4 French, V 3 English Enterprise CDM only CDM & PDM edition 1994 Powersoft 1996 Sybase v 5 v 6 Modules Maturity release Process. Analyst Data. Warehouse New generation, UML and new techniques 1999 2000 2001 v 7. 5 v 8. 0 first UML added new More UML diagram (Class) repository (Use Case, Sequence) 2002 2003 v 9. 0 v 9. 5 More UML All UML diagrams (Activity, UML profiles Component) BP Modeling Datawarehouse extensions EJB … Business Process modeling v 10. 0 SOA. NET MDA 9

Gartner说 Power. Designer在数据建模上占世界第一位 Power. Designer Market share in 2002 was 39% (Document Gartner August 2003) 10

Gartner说Power. Designer在数据建模上占世界第一位 Data Modeling ‘Magic Quadrant’ 2004 Power. Designer Market share in 2002 was 39% (Document Gartner August 2003) Note: Quest Software resell an OEM version of Power. Designer under the name ‘QDesigner’. 11

OOAD & BPA Market Overview Gartner modeling quadrants Object Modeling at version 9. 5. 2 2003 quadrant BP Modeling at version 10 2004 quadrant Visionnary Challenger 12

Gartner说三个建模技术要连结在一起 • Gartner research note decembre 2003 • Strategic Planning, SPA-21 -5951 - M. Blechar § Predicts 2004: BPA, UML and Data Modeling Converge « Techniques such as business process analysis are converging to provide technical architects, business modelers, developers and database designers consistency, productivity and quality via reuse and code automation. » § « …Vendors such as Sybase (Power. Designer) and … offer single products that span all three markets. Most UML modeling tool vendors already have some BPA and database design support in their tools, and vice versa. … » Source: Gartner 14

Power. Designer Key Features • • • Good Business Process Modeling support Full UML Modeling support Complet Data Modeling support XML Modeling Integrated BP, UML & Data Modeling O/R Mapping Repository Report generator Customizable code generator (Java, EJB, Web Service, C#, VB. NET, Power. Builder, XML, BPEL 4 WS, …) • VBScript and OLE automation support 15

Power. Designer的体系结构 Maximum coverage 资料库 (optionnel) 商业流程模型 数据模型 (E/R) O/R Mapping 面向对象模型 (UML) - Free Model - XML Model 商业流程模型 (Targets: eb. XML, BPEL 4 WS, Sybase IO) 编码生成 - Metadata - Profiles - Model-to-Model Generation - MDA - Report - XMI … IDE 数据库 Persistence Management Application Servers Integration Servers 17

Power. Designer的模型 商业流程模型 Java, C#, VB. Net, Power. Builder, WSDL, … 面向对象模型 eb. XML BPEL 4 WS IO 概念性数据模型 O/R Mapping XML DTD XML Schema XML模型 Script DDL SQL 物理数据模型 ODBC 数据库 Generation Reverse engineering Import/Export Synchronization 18

Modeling in Development Cycle Business Requirements 分析 开� 设计 测试 Deployment Maintenance Roles 商业用户 IT用户 分析员 设计师 开发人员, DBAs, Administrators, etc Team work, Change management, Methodology, Documentation, Reuse Power. Designer coverage 今天 明天 Control points 19

Exemple of Power. Designer Object-Oriented Model (UML) 20

Industry Endorsement – Customer Adoption • Power. Designer is already used by many public and private organizations worldwide • Total today over 50, 000 users at 30, 000 sites worldwide – we are doing something right! • Examples of strengths in specific areas: – Financial Community embraces Power. Designer – France – Germany – UK – USA – French market – 80% market share – and they know about design! 21

Hurwitz on Power. Designer 9. 0 Benchmark Rating – Overall Rating 8. 0 Ease-of-use Comprehensiveness Deployment Flexibility Developer Resources Life-Cycle Management Developer Productivity Aids/Wizards Adherence to Standards 0 2 4 6 8 • Comprehensiveness: ‘… a rich all in one modeling environment…’ • Deployment flexibility: variety of languages and target platforms • Developer resources: Sybase Developer Network • Life-cycle management: integration with IDE • Developer productivity: ‘… a solid set of wizards and tools to speed development tasks such as EJB creation, object/relational mapping (O/R map), report generation, and a customizable user interface’ 10 22

Competitive Differentiation – Power. Designer 10. 0 IBM Rational Rose Computer Associates • Competitive Differentiation Power. Designer 9. 5 Business Process Modeling Data Modeling Object Modeling Repository only, – UML IT style & – limited complex – – Sterling, BPwin products + Erwin is a declining leader UML visionary two overlapping products (Platinum/Sterling) limited integration issue due to multiple products – – Embarcadero – E/R Studio technical limitations + + No Describe limited awareness integration issue due to multiple products – Borland Together – – + No limited Leader for developers – usability issues 23

Competitive Differentiation – Power. Designer 10. 0 • Competitive Differentiation Sybase Power. Designer 9. 5 Business Process Modeling Power. Designer Challenger with specific offering Data Modeling Leader mature technology proven over years of success Object Modeling Complete offering with version 10. 0 showing growth in market and technology Repository Most complete and integrated design-time enterprise repository in the industry 24

Competitive Differentiation – Power. Designer 10. 0 • • Best integrated BP, UML, Data modeling tool No. 1 Data Modeling tool, better than ERwin Very good UML modeling, better than Rose Best O/R mapping support Best Repository Very good report generator Extensible (code generator, profile, VBScript, …) Repository 25

Power. Designer 与业务流程建模

Why Using Business Process Modeling? • It is not technical; it is easy to use. • Business users can use it to: – – Describe the current business processes Define the future business processes Optimize business processes Improve ROI • BPM can be used to design and generate BPM and workflow standards (eb. XML, BPML, XPDL, …) • BPM can be used to design and generate Web Services orchestration standards (BPEL 4 WS, …) 27

Why We Use BPM instead of UML? • BPM tool is essentially for business users. It should be very easy to use. • UML is more technical and more complex. It is good for designing applications but not for describing business processes. • We offer well adapted tools for different usages instead of forcing all users to use UML. 28

Business Process Model Concepts • • • Predefined Symbols Start End Process Flow Decision Synchronization Organization Unit Resource Service provider, interface, operation Data 29

Example of a High-Level BPM • Describe system architecture 30

Example of a Detailed BPM Swimlan e 31

Power. Designer 10. 0 BPM Features • • • Simple user-interface Custom symbols, predefined symbols tool palette Support Simulation (use Simul 8) Support Service-Oriented Architecture (SOA) Generate/reverse engineer BPEL 4 WS Generate Sybase Integration Orchestrator model Generate/reverse engineer eb. XML Import/export data from/to OOM and CDM Export UML Activity diagram using VBScript Swimlane CRUD matrix (Create, Read, Update, Delete) 32

Support Simuation (new in V 10) • • Use simulation to optimize business processes (costs, delay, resources) Define Simul 8 specific properties Generate Simul 8 models Reverse engineer Simul 8 properties 33

Support Service-Oriented Architecture (SOA) • • • Support Service provider, Service interface and operation Import WSDL, UDDI browser Assign service operation to process Web Services assembling Design, generate, reverse engineer BPEL 4 WS 34

Generate Sybase Integration Orchestrator Model • Define IO specific Business Process Model in Power. Designer • Generate IO model • Refine IO model 35

Support eb. XML BPSS • Design, generate and reverse engineer eb. XML Business Process Specification Schema (BPSS) • Generate Private Process Options for Process Server • Process Server can import the generated eb. XML BPSS. 36

Power. Designer 与对象建模

Why Using UML? • Visually define and communicate the structure and behavior of an application • Represent systems using Object-Oriented concepts • Link OO concepts to executable code 38

Brief Overview of UML • UML is defined by OMG. • UML consists of 9 diagrams: – Static – Class diagram – Object diagram – Dynamic – – – Use Case diagram Sequence diagram Statechart diagram Collaboration diagram Activity diagram – Implementation – Component diagram – Deployment diagram 39

UML Support in Power. Designer • Power. Designer supports all nine UML diagrams • Power. Designer supports UML 1. 4 • Future version of Power. Designer will support UML 2. 0 40

Use Case Diagram • A Use Case Diagram describes the Actors, the Use Cases and the interaction between the Actors and the Use Cases. 41

Collaboration Diagram • A Collaboration Diagram describes the interaction between objects (instance of classes) by exchanging messages. • Collaboration Diagram can be used to identify classes and operations 42

Sequence Diagram • A Sequence Diagram describes the interaction between objects and how the messages are exchanged over time. • Sequence Diagram is used to identify classes and operations 43

Activity Diagram • An Activity Diagram describes the logic and the control flow of a Use Case, an Operation or another Activity. 44

Statechart Diagram • A Statechart Diagram is used to model the States and Transitions of a Class 45

Object Diagram • An Object Diagram shows the relationships between Object Instances 46

Class Diagram • A Class Diagram defines the Classes, Interfaces, Attributes, Operations, Relationships, Inheritances, … • A Class Diagram can be used to define persistent objects, control objects and user-interface objects. • A Class Diagram can be used to generate the Physical Data Model and the application implementation code. 47

Component Diagram • A Component Diagram can be used to define the components you need to create for an application • A Component can use Classes, Interfaces • Power. Designer uses Components to represent EJBs, Servlets, JSPs, ASPs and Web Services 48

Deployment Diagram • A Deployment Diagram is used to define the deployment architecture • Deployment Diagram shows the Nodes (machines, servers), the Component Instances deployed in a Node and the Links between Nodes 49

Object/Relational (O/R) Mapping • Generate a Class Diagram from a Physical Data Model with O/R mapping • Generate a Physical Data Model from a Class Diagram with O/R mapping • Manually define complex O/R mapping • Generate select, insert, update, delete SQL statements • Use O/R mapping to generate EJB CMP (Web. Logic, Web. Sphere, EAServer), JDO, Cocobase, . NET (future) 50

O/R Mapping Example Use O/R mapping to generate SQL Generate O/R mapping when generating a PDM from an OOM 51

Java Support • Provide wizards to automatically create EJBs, Servlets, JSPs, Web Services • Generate and reverse engineer Java code • Generate collection management accessor functions • Generate deployment descriptors • Generate O/R mapping descriptor for Web. Logic, Web. Sphere, EAServer, JDO, JBoss (future) • Generate project files for JBuilder and Eclipse • Generate Ant script to compile, package and deploy J 2 EE application 52

Example of EJB wizard EJB Component EJB Classes and Interfaces 53

. NET Support • • • Reverse engineer C# and Visual Basic. NET code Reverse engineer. NET binary code in C# or VB. NET Generate C# and VB. NET code Generate collection management accessor functions Generate Visual Studio. NET project files Create Web Services for C# or VB. NET (. asmx files) 54

Code Generation • Templates and macros based code generator • Generate Java, C#, VB. NET, VB, C++, Power. Builder, … • User could add their own code generation templates C# code preview 55

Power. Designer 与数据建模

Power. Designer Data Modeling Overview • No. 1 Data Modeling Tool • Power. Designer separates data modeling in Conceptual Data Model (CDM) and Physical Data Model (PDM) • Power. Designer uses Entity-Relationship (ER) notation for CDM • A CDM is independent of database • A CDM can generate several PDMs • A PDM is database specific 57

Power. Designer Conceptual Data Model • Use Entity-Relationship (ER) notation. • Support Business Rules, Domains, Data Items, Inheritances and Relationships. • A CDM can generate one or several PDMs. • After a PDM is generated, users can denormalize and optimize a PDM, change the CDM again and regenerate the PDM. Power. Designer will use the Merge Model function to resolve conflicts 58

Example of a Conceptual Data Model 59

Power. Designer Physical Data Model • Supports more than 45 major databases • Supports Logical Data Model using the <Logical Model> DBMS • Supports indexes, keys, stored-procedures, triggers, views, referential integrity • Supports permissions and synonyms • Supports denormalization (split tables, merge tables, copy columns) for optimizing performance • Generate and reverse engineer database • Synchronize database with PDM (modify database or modify PDM) • Estimate database size • Test data generation 60

Power. Designer Physical Data Model • View data • Data Warehouse modeling – Star schema, Snowflake schema – Multi-dimension diagram (cubes) – External data source • • Import/export Power. Builder extended attributes Generate Object-Oriented Model with O/R mapping Import Object-Oriented Model and generate O/R mapping Generate XML Model 61

Example of a Physical Data Model 62

Power. Designer 与XML建模

XML Model § Power. Designer 10 introduces a new XML Model § Design, generate and reverse engineering XML Schema and DTD § Special diagramming tool § Horizontal and vertical styles § Graphical tools for tree diagram § Expand collapse nodes § § Preview XML Schema or DTD Convert XML Schema to DTD and DTD to XML Schema Define mapping between XML Model, PDM and OOM Generate XML Model from PDM or OOM 64

Example of a XML Model 65

Power. Designer 的共同功能

Power. Designer 的共同功能 • Compare and merge models • Free Model • Complete Model-Driven Architecture (MDA) support for all models • Report generation • Repository • Profile • Code generation • VBScript • OLE automation 67

Compare and Merge Models • The model merge window is used when generating model, generating database, reverse engineer database, consolidate model in repository, … 68

Model-Driven Architecture (MDA) § Model-Driven Architecture (MDA) is defined by OMG § Main ideas: § Separating specification with implementation § Specifying a system that is independent of a platform § Transforming a platform independent system specification into a specific platform § Code generation Code 69

Complete MDA Support for All Models § Extend metamodel using profile for all models § § Stereotype and criteria Extended Object, Extended Link and Extended Collection for all models Events handlers Custom commands § Model-to-Model generation § Model transformation script § Code generation templates § GTL language (macros) § VBScript 70

Report Generation • Generate complete report in HTML, RTF formats • Support English, French, Chinese, … 71

Repository • Power. Designer has an enterprise repository for model sharing and versioning – Consolidation/Extraction of Models and other non. Power. Designer files – Object level versioning – Branching, Configuration – Security – Comparing versions – Use relational database 72

Profile (Extended Model Definition) • • • Similar to UML Profile; applies to all models Can be used to extend an existing model type Stereotype and criteria Extended attributes, objects and collections Code generation templates – Generation Template Language (templates & macros) • • Custom symbols Custom tool palette Custom checks Custpom popup menus 73

Code Generation • Code generation templates – Generation Template Language (templates & macros) • All Power. Designer code generators are defined as templates (Java, C#, VB. NET, PB, eb. XML, BPEL 4 WS, SQL, XML, …) • You could modify existing code generation or define your own code generation 74

VBScript • You can use VBScript to control Power. Designer (query objects attributes and collections, create objects, import/export models, generate code, generate reports, …) • You can define menu items to launch VBScripts • You can use VBScripts to define model transformation • You can use VBScripts to define Design Patterns • There is a VB Script samples directory 75

OLE Automation • OLE automation can be used by a program outside of Power. Designer • You can use any language (VB, VBA, VB. NET, C#, PB, C++, Java. Script, Java, …) that supports COM to work with Power. Designer • You can create your own user-interface • There is an OLE automation samples directory 76

Power. Designer 10. 0的新功能

Power. Designer 10. 0的新功能 Available February 9, 2004 § § § § § Business Process Simulation using Simul 8 Service-Oriented Architecture (SOA) Round-trip. NET Support Complete MDA support New XML Model Support Pocket Power. Builder 1. 5 Integration with Power. Builder 10 (V 10. 1) Integration with Eclipse (V 10. 1) Other Improvements 78

Integration with Power. Builder § Support Pocket Power. Builder 1. 5 § Reverse engineer Pocket Power. Builder 1. 5 code § Design and generate Pocket Power. Builder code using Class Diagram § Plugin for Power. Builder 10 (V 10. 1, April 2004) § Integrate Power. Designer 10. 0 into Power. Builder 10. 0 IDE § Create a Class Diagram from a Power. Builder target § Navigate Between Class Diagram and Power. Builder browser § Open Power. Builder painter from Class Diagram § Regenerate Power. Builder application 79

Example of Power. Designer Plugin for Power. Builder 10 80

Integration with Eclipse § Plugin for Eclipse (V 10. 1, April 2004) § Run Power. Designer inside Eclipse IDE § Support all type of models (CDM, PDM, OOM, Business Process Model, XML Model) § Synchronize Java code with Class Diagram § Generate Java, EAServer Web Service and IO projects § Automatically import or refresh generated Java project or IO project 81

Example of Power. Designer Plugin for Eclipse 82

Other Improvements § § § § § Support IDEF 1 X notation Bitmap join index for Oracle Multiple databases for DB 2 Support Apache Axis Support EAServer 5. 0 Composite view for process, package Committee process symbol Improve eb. XML support Support PNG image format in report … 83

Power. Designer 与模型驱动开发

模型��开� • How to use Power. Designer Business Process, UML and Data models in application analysis and design? • Some software engineer processes are too complex (RUP, CMM, …) • Each company should carefully select a process and adapt it to its own needs based on – Type of application – Size of team – … 85

A Typical Process for Developing New Application with Power. Designer 86

Example of How to Use UML for a New Application • Define Use Case Diagram – Identify classes • Define Collaboration Diagram and/or Sequence Diagram – Identify classes and operations • • • Design Class Diagram Generate a report and use the report as a specification Generate a Physical Data Model with O/R mapping Optimize the PDM Generate the Database Define classes implementation in Class Diagram Generate the code and O/R mapping Use an IDE to finish the implementation, compile and test Reverse engineer the code to update the UML model 87

Example of How to Use UML for an Existing Application • • • Reverse engineer existing code to create a Class Diagram Reverse engineer existing database to create a PDM Understand the existing application’s logic Define Use Case Diagram Define Collaboration Diagram and/or Sequence Diagram Improve Class Diagram Generate a report and use the report as a specification Modify the Database Improve classes implementation Generate the code and O/R mapping Use an IDE to finish the implementation, compile and test Reverse engineer the code to update the UML model 88

Power. Designer的路线图

Power. Designer的路线图 Advanced BP Modeling release Enterprise Modeling release Advanced Enterprise Modeling release Power. Designer Minerva • Process decomposition diagram Power. Designer 10. 0 • Requirements management • Strong BP Modeling • Impact analysis • IO support • XML & Web Service in databases • Round-trip. Net support • Replication Server support • Complete MDA support • Mobi. Link support • XML model • Pocket Power. Builder support • Support J 2 EE 1. 4 • Integration with Visual Studio. NET 10. 1 • Enhancements for existing features Power. Builder 10 • Support Unicode &Eclipse Plugins Q 4 2003 Q 1 2004 1 H 2004 2 H 2004 Beyond Minerva • Improved enterprise features • UML 2. 0 • Use MDA to generate complete application • Design Pattern 2005 90

More Information § Microsoft Windows Script online help § Can be downloaded from http: //msdn. microsoft. com § Power. Designer VBScript online help § Accessible from Power. Designer help menu § Power. Designer Advanced Documentation § Accessible from Power. Designer help menu § OLE Automation samples § OLE Automation*. * § Power. Designer Metamodel § ExamplesMeta. Model. oom 92

More Information 1. Power. Designer网站: – http: //www. sybase. com/products/enterprisemodeling/powerdesigner 2. Sybase China Power. Designer网站: – http: //www. sybase. com. cn § Code. XChange: – http: //powerdesigner. codexchange. sybase. com § Newsgroup: § news: //forums. sybase. com/sybase. public. powerdesigner. general 93

UML China 讲座 All-in-One Design Tool Power. Designer 10. 0与模型驱动开发 • 王晓昀 Power. Designer 首席架构师 • xwang@sybase. com • 2004年 3月25日