Chapter 7 Denormalizing a PDM


Intermodel generation of horizontal partitions

When you generate in update mode a PDM from a PDM, a CDM or an OOM, horizontal partitioning is preserved.

For example, model Sales.CDM contains entity Customer:


Sales.CDM is generated in SALES.PDM, entity Customer becomes table Customer:


You decide to create partitions for this table using the City criterion, you use horizontal partitioning to create table partitions from which you remove the city column:


You modify the CDM and regenerate the PDM in update mode. The partitions are taken into account in the merge dialog box as you can see in the merge dialog box: CDM changes (creation of the Activity attribute) are selected by default, and column modifications related to partition creation are not selected.


 


Copyright (C) 2005. Sybase Inc. All rights reserved.