You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Anil <an...@gmail.com> on 2016/10/26 17:06:22 UTC

Ignite load

HI,

What is the best way to load a normalized data from a db into flatten
object into ignite cache.

Ex :

CacheObject {

// person details   <person>

// person address  <person_address>

// person comany infomraiton <person_company>

}

both in RDBMS and nosql point of view


Thanks.

Re: Fwd: Ignite load

Posted by vkulichenko <va...@gmail.com>.
Do you mean that company in the object is just the company ID, not the actual
company object? If so, then this is the correct model and I don't see any
issues with loading it. Just load persons and companies separately and then
join using SQL queries.

-Val



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Ignite-load-tp8516p8533.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Fwd: Ignite load

Posted by Anil <an...@gmail.com>.
HI Val,

Thanks for your reply. Relation will be one to many.

My underlying data base is hbase. currently i am fetching the regions which
needs to loaded into ignite and broadcasting the region information.

Each IgniteCallable instance scan a region and load into Ignite using data
streamer.

Get cache entry and updating few fields (either put or data streamer. data
streamer is better to put operation) is expensive. correct ? any other
alternative ?

Thanks.


---------- Forwarded message ----------
From: vkulichenko <va...@gmail.com>
Date: 27 October 2016 at 01:09
Subject: Re: Ignite load
To: user@ignite.apache.org


Hi Anil,

Is there one-to-one relation between person and address/company? If yes,
then you just load three rows from different tables and create an object
based on fetch information. You can load data via IgniteDataStreamer or
within your implementation of CacheStore:
https://apacheignite.readme.io/docs/data-loading

-Val



--
View this message in context: http://apache-ignite-users.
70518.x6.nabble.com/Ignite-load-tp8516p8517.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Ignite load

Posted by vkulichenko <va...@gmail.com>.
Hi Anil,

Is there one-to-one relation between person and address/company? If yes,
then you just load three rows from different tables and create an object
based on fetch information. You can load data via IgniteDataStreamer or
within your implementation of CacheStore:
https://apacheignite.readme.io/docs/data-loading

-Val



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Ignite-load-tp8516p8517.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.