Defining the DataStore Object Type 

The following decision tree is intended to help you define the right DataStore object type for your purposes: The decision nodes represent the following functions and properties:

○       Data provision using a load process:
The data is loaded using the data transfer process (DTP).

○       Delta creation:
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 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 using the load process. In this case, the data is provided with APIs. More information: DataStore Objects for Direct Update.

If the data is provided using 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 creation

○       Single record reporting

○       Unique data

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

○       Delta creation

○       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 creation

○       Unique data

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

○       Delta creation

●      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 No Check on Uniqueness of Dataflag if you want to use the following function:

○       Single record reporting

 

More information about defining the DataStore object type: Performance Optimization for DataStore Objects.

 

More information about DataStore object types:

Standard DataStore Object

Write-Optimized DataStore Object