This content has been marked as final. Show 3 replies
Yes, that's correct. You cannot exactly model this in TimesTen. You need to omit some of the relationships so that things are defined in TimesTen as a pure parent/child relationship. You may also consider putting the tables into separate cache groups. Of course, there are some consequences to doing this:
1. The 'missing' relationship cannot be enforced by TimesTen. The application must enforce/respect it. If it does not some updates may fail to propagate to Oracle if they violate the relationship in Oracle.
2. If parallel AWT is configured (to improve propagation performance) it will not be used for any tables where there are missing relationships. All updates to those tables will be applied sequentially.
It seems that I can create an independent cache group for the many-to-many relationship table.
Do you mean that in this case TimesTen will automatically detect those tables where there are miss relationships and propagate all updates about them to oracle sequentially if parallel AWT is configured?
Yes, that's correct.