guava cache for table like structure

[Andrei Sereda]

Hi Everybody,

I wanted to ask your advice on how to best implement in-memory "table" like structure using K/V store (guava cache). The table has a PK which resolves to a unique element. However there are also secondary indexes which map a value to a collection of elements (Multimap in google's parlance). Add cache semantics to the above data structure (eviction, concurrency, data population/cache loader, refresh etc.) and that's pretty much what is needed.

To give a concrete example imagine a User object having attributes [id, country]. Sometimes you search by (unique) attribute id, sometimes you want all users from country XYZ.

Probably it is not directly related to guava however I was wondering if combination of cache and multimaps (or Table?) can achieve desired result ? What's the best way to keep indexes in sync ?

Thanks for your help,

Andrei.

[Louis Wasserman]

If concurrency is in play, then I don't think you'll be able to use Guava like this.  It's typically difficult or impossible to shove two concurrency abstractions together and expect their synchronization guarantees to work together like that.

I suspect that a proper in-memory database would probably be of more use to you?

Louis Wasserman
wasserm...@gmail.com
http://profiles.google.com/wasserman.louis

--
guava-...@googlegroups.com
Project site: http://guava-libraries.googlecode.com
This group: http://groups.google.com/group/guava-discuss
 
This list is for general discussion.
To report an issue: http://code.google.com/p/guava-libraries/issues/entry
To get help: http://stackoverflow.com/questions/ask (use the tag "guava")

[Kevin Bourrillion]

Friendly reminder from the guava-libraries.googlecode.com main page:

To get help on a specific question or problem, post a question to Stack Overflow with the tag "guava". We monitor these questions using this RSS feed.)

--
Kevin Bourrillion @ Google

Java Core Libraries Team
http://guava-libraries.googlecode.com

[Paul Bellora]

He has posted this as a question:  http://stackoverflow.com/questions/10808436/maintaining-multiple-indexes-with-guava-cache-in-memory-table 

[Andrei Sereda]

Hi,

Apologies if I misused the channel. This group seemed more active than stackoverlow. I'll be glad to discuss this question there.

[Kevin Bourrillion]

Ah. If you're having trouble getting an answer on SO, feel free to ping the list here but just send us a link to the SO page so we can keep the answers in one place!

[Andrei Sereda]

Thanks, Kevin. I'll wait for an answer on SO.

[Andrei Sereda]

Ping.
Eager to hear your opinions.