PowerDesigner与数据建模.pptVIP

PowerDesigner 与数据建模 PowerDesigner Data Modeling Overview No.1 Data Modeling Tool PowerDesigner separates data modeling in Conceptual Data Model (CDM) and Physical Data Model (PDM) PowerDesigner uses Entity-Relationship (ER) notation for CDM A CDM is independent of database A CDM can generate several PDMs A PDM is database specific PowerDesigner 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. PowerDesigner will use the Merge Model function to resolve conflicts Example of a Conceptual Data Model PowerDesigner 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 PowerDesigner Physical Data Model View data Data Warehouse modeling Star schema, Snowflake schema Multi-dimension diagram (cubes) External data source Import/export PowerBuilder extended attributes Generate Object-Oriented Model with O/R mapping Import Object-Oriented Model and generate O/R mapping Generate XML Model Example of a Physical Data Model *