Sunday, November 7, 2010

Optimization Process

Difference between standard DSO and optimized DSO

We have 3 types of Data Store Objects.
1. Standard DSO 2. Write Optimized 3. DSO for Direct update
Standard DSO :
--------------
1-Standard dso consists of three tables (New table, active table, change log).
2-Possible of having update rules
3-SID Generation for characteristics at the time of activation.
4-Bex queries possible
5-We can add or overwrite the records for new data requests
Write-Optimized:
-----------------
1)Consists of the table of active data only
2)Possible of having Update rules
3)No SID generation for characteristics and no concept of activation
4)Bex queries possible
5)We can only add the records for new data requests
DSO for direct update:
---------------------
1)Consists of the table of active data only
2)No possibility of update rules
3)No SID genertion for characteristis and No concept of activation
4)Bex queries possible
5)System deletes all existing records when we do new data request upload.

No comments:

Post a Comment