Oracle NoSQL Database Indexing
By Charles Lamb on Oct 21, 2011
Oracle NoSQL Database's simple K/V pair model utilizes a B+Tree on each node to index by the key of each record. Is a Key-Value store useful with only primary key indexing? Absolutely.
- Click stream logs - indexed by timestamp or ipaddr
- User Profiles - indexed by UID
- Sensor/Stats/Network capture - indexed by timestamp
- Mobile device backup services - indexed by device id or user id
- Personalization - index these by user id and then do further look-up within the user id by sub key as needed
- Authentication services - indexed by user id
In an unstructured or semi-structured environment, primary-key indexing is very often sufficient. Further, consider the case of Map/Reduce post-processing of NoSQL Database data in any of the above scenarios. During the M/R steps, secondary indices, sometimes ad-hoc, are effectively generated on-the-fly.