What are the best practices for handling RDBMS table relationships. We usually c

sariqs over 8 years ago

What are the best practices for handling RDBMS table relationships. We usually create CDTs to map with our tables and in case there are multiple tables associated with each other we create nested CDTs.

My questions is more around mapping the inter related tables with nested CDTs using annotations with Lazy loading enabled. As Appian uses hibernate in the backend it should support lazy loading but I have seen whole object graph is fetched in process variables even if nested CDTs are configured as lazy loading enabled. In case lazy loading isn't supported in the process variables what are the best practice to model the nested CDTs in this case ?

Please let me know.

Discussion posts and replies are publicly visible

Parents

0 Stefan Helzle
A Score Level 3
over 8 years ago

I think it is best to create several CDTs mapped to the same tables tailored to a certain need. E.g. you need to fill a grid with many items but only need data from the main table, you create a flat CDT with only the needed data. For loading a single item you can create a full fledged CDT.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Stefan Helzle
A Score Level 3
over 8 years ago

I think it is best to create several CDTs mapped to the same tables tailored to a certain need. E.g. you need to fill a grid with many items but only need data from the main table, you create a flat CDT with only the needed data. For loading a single item you can create a full fledged CDT.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data