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.