>From my perspective (ML module), it will be very easy to talk about Ignite in SQL terms like table (with additional information about ability to make key-value CRUD operations, not only SELECT * FROM Table) Also we could look on PostgreSQL with different plugins for SQL extension like PostGIS or support of JSON-B and ability to store not only planar data with strict schema (I agrre here with Vladimir).
чт, 18 окт. 2018 г. в 14:33, Ilya Lantukh <ilant...@gridgain.com>: > I thought that current "caches" and "tables" have 1-to-N relation. If > that's not a problem, than I also think that "table" is the best term. > > On Thu, Oct 18, 2018 at 9:29 AM Vladimir Ozerov <voze...@gridgain.com> > wrote: > > > Well, I never thought about term “table” as a replacement for “cache”, > but > > it appears to be good candidate. > > > > This is used by many some major vendors whose underlying storage is > indeed > > a kind of key-value data structure. Most well-known example is MySQL with > > its MyISAM engine. Table can be used for both fixed and flexible (e.g. > > JSON) schemas, as well as key-value access (hash map -> hash table, both > > are good). > > > > Another important thing - we already use term “table”, and it is always > > hard to explain our users how it relates to “cache”. If “cache” is > dropped, > > then a single term “table” will be used everywhere. > > > > Last, but not least - “table” works well for both in-memory and > persistent > > modes. > > > > So if we are really aim to rename “cache”, then “table” is the best > > candidate I’ve heard so far. > > > > чт, 18 окт. 2018 г. в 8:40, Alexey Zinoviev <zaleslaw....@gmail.com>: > > > > > Or we could extend our SQL commands by "GET BY KEY = X" and "PUT (x1, > x2, > > > x3) BY KEY = X" and the IgniteTable could be correct. > > > Agree with Denis that each table in the 3rd normal form is like > key-value > > > store. Key-value operations are only subset of rich SQL commands. > > > > > > The problem with IgniteData that it's too common. Also, it's difficult > to > > > understand is it a plural or single object? For instance, the bunch of > > > IgniteTables could be IgniteData. But the set of IgniteData? > IgniteDatum? > > > > > > > > > > > > чт, 18 окт. 2018 г. в 4:18, Denis Magda <dma...@apache.org>: > > > > > > > Key-value calls are just primary key based calls. From a user > > > perspective, > > > > it's the same as "SELECT * FROM table WHERE primary_idx = X", just > > > > different API. > > > > > > > > -- > > > > Denis > > > > > > > > On Wed, Oct 17, 2018 at 5:04 PM Dmitriy Setrakyan < > > dsetrak...@apache.org > > > > > > > > wrote: > > > > > > > > > On Wed, Oct 17, 2018 at 4:58 PM Denis Magda <dma...@apache.org> > > wrote: > > > > > > > > > > > I've been calling everything "tables" instead of "caches" for a > > > while. > > > > > The > > > > > > main reason is the maturity of our SQL engine - seeing more SQL > > users > > > > and > > > > > > deployments which talk "tables" language. > > > > > > > > > > > > > > > > > I think "IgniteTable" only implies SQL, not key-value. We need > both. > > > > > > > > > > > > > > > > > -- > Best regards, > Ilya >
