Hi Team,
We want to use apache ignite for below use case.
We provide reports to customer . We execute query on oracle and feed it into
oracle. And on the top of report, we allow pagination, sorting, grouping and
export etc. Right now for each and every action after report execution, we hit
oracle to get data. So we want we will hit oracle once and get data in memory
and execute query on memory data to get data of further operations like
pagination, sorting, grouping and export .
To achieve this, I am thinking to use of apache ignite as below
1. We execute query on oracle database and want to save that data into
apache ignite as cache. (Like memory store, persistence mode enabled)
2. And on ignite cache, execute some complicated queries and fetch data
from ignite cache.
3. Keep the expiry of this cache to 5 minutes.
4. So there will be lot of insertion of new data and at the same time get
of cache also like User executes report and performs some grouping, and closes
report. In this case we will create cache in ignite and keep in the memory till
user closes it. Meanwhile perform sql queries on ignite cache.
5. For cache, considering creating class with different data types fields
to it. And perform query on this class
Is it apache ignite suitable for this use case.?
Thanks,
Reshma.
This message, together with any attachments, is intended only for the use of
the individual or entity to which it is addressed and may contain confidential
and/or privileged information. If you are not the intended recipient(s), or the
employee or agent responsible for delivery of this message to the intended
recipient(s), you are hereby notified that any dissemination, distribution or
copying of this message, or any attachment, is strictly prohibited. If you have
received this message in error, please immediately notify the sender and delete
the message, together with any attachments, from your computer. Thank you for
your cooperation.
