1
Good evening, I am with a project where I have to consume tables generated in star format, for use of BI, the company bought a paid tool, but do not want to spend much on licenses. Therefore a user interface will have to be created, only use jdbc to load this information each query would be very heavy since it has queries that take more than 2 minutes to return the result.
I wonder if the Jboss Data Virtualization or the Jboss Data Grid would serve my purpose.
I read that it performs queries and stores this information in a virtualized database, so it can be consumed, without having to perform new queries, besides the power to relate the data to other sources such as WS or other databases.
I wanted to know if that’s what it is or every time I consume a table virtualized by JDV a new query is generated. I would also like to know whether the consumption of this information is an "easy process".
Thanks for your help.
You managed to solve your problem?
– durtto
We ended up using Data Grid friend.
– João
Good John, so you could try to create an answer to your question, so you don’t leave your question unanswered, and still help other people.
– durtto
I will answer yes.
– João