Data Modeling Scenarios

Integrated modeling supports efficient message definition and database design, and consistent production deployments.

Using the RAP data model and extensions, you can:
  • Model RAP messages in the RAP Messages model, a PowerDesigner logical data model (LDM)
  • Convert a RAP Messages logical data model to RAPCache and RAPStore physical data models (PDMs)
  • Convert existing RAPCache and RAPStore physical data models to a RAP Messages logical data model
  • Generate RAP message templates and Publisher API stubs from a RAP Messages model
  • Validate a model using custom checks for RAP messages, in addition to standard PowerDesigner checks for all models
  • Analyze the impact of changes to a message, a model, or a database table on all components in the integrated model

The RAPCache database schema must match the RAPStore schema for all tables in which data will be inserted. After you make changes, you can use PowerDesigner to produce a set of data definition language (DDL) statements directly from the physical data model. PowerDesigner saves the DDL in a SQL script that you can run to generate the tables and other objects for the target databases.

DDL generation does not require use of the extended modeling feature.

Related concepts
Data Model
Related tasks
Creating a RAP Messages Model
Extending an Existing Model
Generating a RAPCache or RAPStore Model from a RAP Messages Model
Generating a RAP Messages Model from a RAPCache or RAPStore Model
Exporting a Single Message Definition
Exporting a Set of Message Definitions
Validating a Model
Launching an Impact and Lineage Analysis