ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Denis Magda <dma...@gridgain.com>
Subject Re: Does ignite support UPDATE/DELETE sql
Date Thu, 14 Jul 2016 03:58:44 GMT

Please properly subscribe to the Ignite's user list. Refer to this page for
details - https://ignite.apache.org/community/resources.html#ask

See my answers inline.

zhaojun08 wrote
> I am new to ignite, and I have a few questions to confirm.
> 1. I want to use ignite to store RDBMS in MEM. Table in RDBMS have many
> rows, does ignite store every row as a Java object, like the "Person"
> object in docs? And is it the only way to store a row in Ignite?
> Yes, Apache Ignite is an in-memory key-value store meaning that for every
> key there should be a corresponding value. A key-value tuple will
> correspond to a row from your RDBMS store.
> 2. I notice that "Person" class implements Serializable, does it mean
> every row record stores in ignite in Serialization format? If so, will the
> Serialization degrade the select performance, and the reason for
> Serialization?
> Objects are stored in a serialized form in memory. However it doesn't mean
> that JDK serialization techniques are used to prepare an object for
> storage. In fact Ignite uses its own BinaryMarshaller (serializer) that
> has good performance characteristics -
> https://apacheignite.readme.io/docs/binary-marshaller
> 3. I have store RDBMS in Ignite, can I update specific row record using
> UPDATE/DELETE sql statement to alter the table?
> This kind of queries is not supported right know. You have to update
> caches with methods like cache.put, cache.putAll, cache.invoke, etc.
> If you need to pre-load data from RDBMS then you can rely on  one of the
> pre-loading strategies - https://apacheignite.readme.io/docs/data-loading.
> This topic should be useful for you as well -
> https://apacheignite.readme.io/docs/persistent-store
> --
> Denis
> Many Thanks!

View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Does-ignite-support-UPDATE-DELETE-sql-tp6290p6292.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

View raw message