This discussion is archived
1 Reply Latest reply: Oct 6, 2012 12:45 PM by greybird RSS

best approach for getting the data out other than keys

450652 Explorer
Currently Being Moderated
sometime we don't have keys to fetch the data, i was wondering what is the best approach to fetch the data using values, also wondering if there is any plans for query support like http://docs.oracle.com/cd/E15357_01/coh.360/e15723/api_cq.htm and indexing in the future.
  • 1. Re: best approach for getting the data out other than keys
    greybird Expert
    Currently Being Moderated
    Only keys may be used to fetch values, however, you can use a key prefix (parent key), sub-key range, and depth. By designing your keys with this in mind, you can sometimes avoid the need for indexing.

    It is also possible to create keys and values that work essentially as an index, by having one kv pair refer to another key via information in the value portion. But it is currently the application's responsibility to implement this -- to store all such associated kv pairs the and fetch the referenced kv pairs using multiple queries -- since there is no explicit support for it in the product.

    On future features, I'm afraid that as an Oracle employee I can't discuss them, sorry.

    --mark                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points