Setting the DataStore Object Type

Use

The following decision tree is intended to help you set the right DataStore object type for your purposes: The decision nodes are formed by the following functions and properties:

• Data provision with load process:

  Data is loaded using the data transfer process (DTP).

• Delta calculation:

  Delta values are calculated from the loaded and activated data records in the DataStore object. These delta values can be written to InfoCubes, for example, by delta recording.

• Single record reporting:

  Queries are run based on DataStore objects that return just a few data records as the result.

• Unique data:

  Only unique data records are loaded and activated for DataStore keys. Existing records cannot be updated.

The graphic shows that a DataStore object must be used for direct updating if the data is not provided via the load process. In this case, the data is provided via APIs. See also: APIs of the DataStore Object for Direct Update.

If the data will be provided via the load process, you need a standard DataStore object or a write-optimized DataStore object, depending on how you want to use it. We make the following recommendations:

• Use a standard DataStore object and set the Unique Data Records flag if you want to use the following functions:

  • Delta calculation:

  • Single record reporting:

  • Unique data:

• Use a standard DataStore object if you want to use the following functions:

  • Delta calculation

  • Single record reporting

• Use a standard DataStore object and set the Create SIDs on Activation and Unique Data Records flags if you want to use the following functions:

  • Delta calculation

  • Unique data

• Use a standard DataStore object and set the Create SIDs on Activation flag if you want to use the following function:

  • Delta calculation

• Use a write-optimized DataStore object if you want to use the following function:

  • Unique data

• Use a write-optimized DataStore object and set the Duplicate Data Records flag if you want to use the following functions:

  • Single record reporting

Note the following with regard to determining the DataStore object type: Performance Tips for DataStore Objects.

You can find more information about DataStore object types under:

Standard DataStore Object

Write-Optimized DataStore Objects