Thanks Stephen for valuable feedback. I went through the link. I read below line on the link
you can store objects as a set of fields and can configure the mapping between table columns and objects fields via the configuration I am not copying the entire oracle table as it is. As we are into reporting, we have very complex queries involving so many tables in the query. So can I map those queries to pojo store? Thanks, Reshma From: Stephen Darlington <stephen.darling...@gridgain.com> Sent: Wednesday, May 4, 2022 4:22 PM To: user@ignite.apache.org Subject: [EXTERNAL] Re: Is apache ignite suitable for sql querying on ignite cache? You might also want to consider using third-party persistence (external-storage<https://urldefense.com/v3/__https:/ignite.apache.org/docs/latest/persistence/external-storage__;!!JqsUqw!0-ljTwf-RFUZChWtTy5pAtwCfqPiVuqIP5qjy6frlgIO7fNd9GEfNCDPrugGa070-VrkNaqvzzNE7ubRRe2ng4kBvW8$>) instead of “manually” reading/writing from Oracle. On 4 May 2022, at 07:11, Reshma Bochare <rboch...@csod.com<mailto:rboch...@csod.com>> wrote: Hi Team, Could you please help me with the below use case. Thanks, Reshma. From: Reshma Bochare Sent: Thursday, April 28, 2022 4:52 PM To: user@ignite.apache.org<mailto:user@ignite.apache.org> Subject: Is apache ignite suitable for sql querying on ignite cache? 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. ________________________________ *EXTERNAL MESSAGE WARNING: This email originated from outside of Cornerstone. Do not click links or open attachments unless you recognize the sender and know the content is safe. Please see this wiki for more information on email safety: https://wiki.cornerstoneondemand.com/display/ISS/Security+Awareness
