A physical data model (PDM) helps you to analyze the tables, views, and other objects in a database, including multidimensional objects necessary for data warehousing. A PDM is more concrete than a conceptual (CDM) or logical (LDM) data model. You can model, reverse-engineer, and generate for all the most popular DBMSs.
-
Operational PDM - You use a physical diagram (see Physical Diagrams) to design the structure of an operational database. Usually, in data modeling, the physical analysis follows the conceptual and/or logical analysis, and addresses the details of the actual physical implementation of data in a database, to suit your performance and physical constraints.
-
Business intelligence PDM - You can use a PDM to design the structure of a data environment, which consists of:
-
Data warehouse or data mart database – are populated with data transferred from operational databases, and gather together all the information that may be needed in an OLAP database, where queries for business analysis and decision making are performed. The data warehouse database gathers all the data manipulated in a company for example, whereas the data mart focuses on smaller entities in the company.
You use physical diagrams to design a data warehouse or data mart database. Since these databases usually contain very large amounts of data for storage, you do not need to design them for performance. You may assign types (fact and dimension) to the database tables to have a preview of the multidimensional structure in an OLAP database.
-
A multidimensional OLAP database - which is generally populated with data that has first been aggregated in a data warehouse or data mart (though sometimes it is transferred directly from operational databases), and in which information is organized to facilitate queries performed by different tools. Business analysts use OLAP databases to send queries and retrieve business information from the different dimensions existing in the database.
You use multidimensional diagrams (see Multidimensional Diagrams) to design the different dimensions and cubes within the OLAP database.
-
PowerDesigner provides support for a wide range of database families through DBMS definition files (*.xdb, located in Resource Files\DBMS inside your installation directory), which customize the metamodel to support the specific syntax of a DBMS, through extended attributes, objects, and generation templates. To view and edit the resource file for your DBMS, select . For detailed information about working with these files, see Customizing and Extending PowerDesigner > DBMS Definition Files.