The JDBC connector maps columns in the underlying datasource to Ignite. You don’t have to map all the columns if you don’t want to. You can also choose to pre-load only some records (see the loadCache method).
If you want to denormalise the data on the way into Ignite there are a couple of options. If you can expose the data as a view in your database, that should work in the same way it works with a table. If not, you can write your own cache store implementation. > On 9 May 2022, at 14:07, Reshma Bochare <rboch...@csod.com> wrote: > > 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 > <https://wiki.cornerstoneondemand.com/display/ISS/Security+Awareness>