Skip to Content

Using a two-stage randomizer

An advantage of using the DEDB interface is that you can use a two-stage randomizing technique. The first stage is to use the key to select a partition and the second stage randomizes within the selected partition.

Using a Two-Stage Randomizing Routine

image2018-12-19_13-41-37.png

With a two-stage randomizer, it is possible to keep related database records in the same partition. For example, you can keep all records in a geographic area or time-zone in the same partition.

The algorithm to select the partition must not be affected by the number of partitions in the database. A key must always randomize to the same partition even if you change the number of partitions. If necessary, customize the randomizing algorithm in each partition to the key distribution in the partition.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Partitioned Database Facility for IMS 9.1.00