Good evening, I'm with a project where I have to consume tables generated in star format, for BI use, the company bought a paid tool, but does not want to spend much with licenses. So a user interface will have to be created, so using jdbc to load this information every query would be very heavy since it has queries that take more than 2 minutes to return the result.
I would like to know if JBoss Data Virtualization or JBoss Data Grid would serve my purpose.
I read that it performs queries and stores this information in a virtualized bank, so it can be consumed without having to re-query, other than the power to relate the data to other sources like WS or other banks.
I wanted to know if this is the same or whenever I use a table virtualized by JDV a new query is generated. I would also like to know if consuming this information is an "easy" process.
Thanks in advance for the help.