Anchor Modeling - Vertica Implementation

SP

hello Friends,

We are thinking of adopting to Anchor Modeling for the Data Warehouse and DataMart Implementations on our side.

Based on your experience thus far, do you think we are on the right track of our thinking to adopt to Anchor Modeling on Vertica? Which we think we are , but wanted to gauge our thinking taking your inputs.

Does Anchor Modeling tool provide the required perspectives ( views/triggers etc.) to perform the DML Operations which I do not see them generating on the Test Version.

Finally, did you observe any problems in your earlier implementations.

We appreciate your help and taking time to provide your insights. Thank you.

Roenbaeck

I am the one who wrote the Vertica code generation. Please note that I am very far from being an expert in Vertica, and this was done more or less as a proof of concept. It may be possible to write the necessary triggers for DML, but they are not there at the moment. That being said, the largest Anchor in Vertica implementation at avito.ru (currently 280TB in a 20 node cluster) is not using triggers as far as I know, but instead loading each table separately and when possible in parallel. A DML trigger would work its way sequentially through the attributes connected to an anchor.