Greetings Erudites,
Can HRF be used as a decision-making tool to choose between real-time and materialized view?
Here's my scenario :
We have materialized our historical data and kept current data in real time.
Currently, we are using a table function which decides, at runtime, whether the CalcView result will be sourced out of a Materialized table or real-time CalcView.
So, if I were to draw a flow chart it would look like this:
CalcView->TableFunction->materialized table OR calcview.
The code inside the table function has an IF condition to direct the results coming out of table or real time CV
Now, we are witnessing that the table function is taking huge memory at runtime and due to this we are facing memory allocation issues. Now we want to replace the table function with something more optimized for memory...and while we are exploring this option, we are considering HANA HRF (Rule Framework) as one of our option..but can this sort of decision making and redirecting the CalcView to either materialized table or real time view, possible with HRF?
Please suggest.
Regards
Debanshu